From: Alan Hodgson <ahodgson@simkin.ca>
To: pgsql-performance@postgresql.org
Subject: Re: Bad performance on simple query
Date: Mon, 17 Nov 2008 08:28:51 -0800
Message-ID: <200811170828.51424@hal.medialogik.com> (raw)
In-Reply-To: <1226937197.5760.89.camel@dimi.lattica.com>
References: <1226937197.5760.89.camel@dimi.lattica.com>
On Monday 17 November 2008, Dimi Paun <dimi@lattica.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: ahodgson@simkin.ca
Subject: Re: Bad performance on simple query
In-Reply-To: <200811170828.51424@hal.medialogik.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox