Re: [PERFORM] Measuring server performance with psql and pgAdmin

2004-10-26 Thread Josh Berkus
Joost, > 1. The manual says about "explain analyze" : "The ANALYZE option causes the > statement to be actually executed, not only planned. The total elapsed time > expended within each plan node (in milliseconds) and total number of rows > it actually returned are added to the display." Does this

[PERFORM] Measuring server performance with psql and pgAdmin

2004-10-26 Thread Joost Kraaijeveld
Hi all, I am (stilll) converting a database from a Clarion Topspeed database to Postgresql 7.4.5 on Debian Linux 2.6.6-1. The program that uses the database uses a query like "select * from table" to show the user the contents of a table. This query cannot be changed (it is generated by Clarion