>If you look at the "actual time" it's completing very quickly indeed.
So
>- it must be something to do with either:
>1. Fetching/formatting
the data
>>2. Transferring the data to the client.
I do agree.
>What
happens if you only select half the rows? Does the time to run the
>select halve?
Yes, it does.
Using pgAdmin, the time to get all 36
rows is about 67500ms while it's 24235ms to get only 18 rows.
Massimo