Skip site navigation (1) Skip section navigation (2)

Re: how to use explain analyze

From: Julius Tuskenis <julius(at)nsoft(dot)lt>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: how to use explain analyze
Date: 2011-10-26 07:48:33
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
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

In response to

pgsql-performance by date

Next:From: LinosDate: 2011-10-26 09:00:48
Subject: Re: CTE vs Subquery
Previous:From: Merlin MoncureDate: 2011-10-25 17:11:23
Subject: Re: CTE vs Subquery

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group