Re: [SQL] how to use explain analyze

2011-10-27 Thread Brent Dombrowski
On Oct 25, 2011, at 7:12 AM, 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? > > I ask because I'm writing a typical web app tha

[SQL] how to use explain analyze

2011-10-27 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.