On Monday 17 November 2008, Dimi Paun <dimi@xxxxxxxxxxx> wrote: >> It takes 0.091s (!): > perpedes_db=# EXPLAIN ANALYZE SELECT * FROM triphistory WHERE ownerId = > 10015 ORDER BY accessTS DESC LIMIT 5; QUERY PLAN > ------------------------------------------------------------------------- >-------------------------------------------------------------------------- >--------------- Limit (cost=0.00..7.99 rows=5 width=106) (actual > time=0.024..0.042 rows=5 loops=1) -> Index Scan Backward using > idx_trip_history_owner_access_ts on triphistory (cost=0.00..142.20 > rows=89 width=106) (actual time=0.021..0.034 rows=5 loops=1) Index Cond: > (ownerid = 10015) > Total runtime: 0.091 ms That's 0.091 milliseconds (0.000091 seconds). -- Corporations will ingest natural resources and defecate garbage until all resources are depleted, debt can no longer be repaid and our money becomes worthless - Jay Hanson -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
