Richard van den Berg <[EMAIL PROTECTED]> writes: > Christopher Kings-Lynne wrote: >> No explain analyze is done on the server...
> Yes, but the psql \timing is calculated on the client, right? That is > the value that PFC was refering to. You didn't show us any \timing. The 94.109 ms figure is all server-side. As an example: regression=# \timing Timing is on. regression=# explain analyze select * from tenk1; QUERY PLAN ------------------------------------------------------------------------------------------------------------- Seq Scan on tenk1 (cost=0.00..458.00 rows=10000 width=244) (actual time=0.050..149.615 rows=10000 loops=1) Total runtime: 188.518 ms (2 rows) Time: 210.885 ms regression=# Here, 188.5 is at the server, 210.8 is at the client. The difference is not all network delay, either --- parse/plan overhead is in there too. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings