Re: [PERFORM] how to use explain analyze

2011-10-26 Thread Julius Tuskenis
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 actua

[PERFORM] how to use explain analyze

2011-10-25 Thread alan
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? I ask because I'm writing a typical web app that allows the user to build and submit a query to my DB.