Tips by tag: analysis
Echo Hidden
by xinu on Jan 15, 2005 02:47 PM
If you want to see how a query like \du is being built:
\set ECHO_HIDDEN
analysiscommandsconfigurationpostgresqlpsqlsql
Query performance analysis
by cygnus on Jan 12, 2005 10:14 AM
Use explain:
EXPLAIN SELECT * FROM some_table WHERE condition;
analysisexplainperformancepostgresqlsql
Query Timing
by xinu on Jan 19, 2005 09:43 AM
If you want to see how long a query is taking to run, you can either run explain analyze or enable timing for the client by typing \timing.
analysisconfigurationdebuggingdurationoutputperformancepostgresqlpsqlruntimesqltiming