Testing server 'PostgreSQL 6.5' at 1999-10-04 11:44:46

ATIS table test

Creating tables
Time for create_table (28):  0 wallclock secs ( 0.06 usr  0.00 sys +  0.00 cusr  0.00 csys =  0.00 CPU)

Time for book-keeping (1):  1 wallclock secs ( 0.00 usr  0.00 sys +  0.00 cusr  0.00 csys =  0.00 CPU)

Inserting data
Time to insert (9768): 24 wallclock secs ( 7.49 usr  0.67 sys +  0.00 cusr  0.00 csys =  0.00 CPU)

Time for book-keeping (1):  1 wallclock secs ( 0.00 usr  0.00 sys +  0.00 cusr  0.00 csys =  0.00 CPU)

Retrieving data
Time for select_simple_join (500):  4 wallclock secs ( 1.48 usr  0.07 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
Time for select_join (200): 18 wallclock secs ( 9.97 usr  0.26 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
Time for select_distinct (800): 20 wallclock secs ( 4.12 usr  0.08 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
Warning: Query 'select distinct from_airport.time_zone_code,to_airport.time_zone_code,(FLOOR(arrival_time/100)*60+MOD(arrival_time,100)-FLOOR(departure_time/100)*60-MOD(departure_time,100)-time_elapsed)/60 AS time_zone_diff FROM flight,airport AS from_airport,airport AS to_airport WHERE flight.from_airport=from_airport.airport_code AND flight.to_airport=to_airport.airport_code GROUP BY from_airport.time_zone_code,to_airport.time_zone_code,arrival_time,departure_time,time_elapsed' returned 557 rows when it should have returned 21 rows
Time for select_group (2500): 77 wallclock secs ( 4.65 usr  0.16 sys +  0.00 cusr  0.00 csys =  0.00 CPU)

Removing tables
Time to drop_table (28):  0 wallclock secs ( 0.02 usr  0.00 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
Time for book-keeping (1):  1 wallclock secs ( 0.00 usr  0.00 sys +  0.00 cusr  0.00 csys =  0.00 CPU)

Total time: 146 wallclock secs (27.82 usr  1.24 sys +  0.00 cusr  0.00 csys =  0.00 CPU)