From: Julius Tuskenis <julius@nsoft.lt>
To: pgsql-performance@postgresql.org
Subject: Re: how to use explain analyze
Date: Wed, 26 Oct 2011 10:48:33 +0300
Message-ID: <4EA7BB51.4020904@nsoft.lt> (raw)
In-Reply-To: <8f370776-9394-46ad-b712-ceceaf02b279@hj4g2000vbb.googlegroups.com>
References: <8f370776-9394-46ad-b712-ceceaf02b279@hj4g2000vbb.googlegroups.com>
Hello, Alan
On 2011.10.25 17:12, alan wrote:
> I'm new to postgres and was wondering how to use EXPLAIN ANALYZE ....
>
> Can I use the output from ANALYZE EXPLAIN to estimate or predict the
> actual time
> it would take for a given query to return?
Explain analyze executes the query, so you get the actual execution time
(not always accurate as some extra job must be done while executing the
query to compute the rows and loops).
> I ask because I'm writing a typical web app that allows the user to
> build and submit a query
Be carefull about that idea - especially if a user can write custom
queries like "delete from important_table"
> Thanks,
> Alan
>
--
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050
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: julius@nsoft.lt
Subject: Re: how to use explain analyze
In-Reply-To: <4EA7BB51.4020904@nsoft.lt>
* 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