Re: Bad performance on simple query

On Monday 17 November 2008, Dimi Paun <dimi(at)lattica(dot)com> 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