Total runtime: 16.000 ms

Even though this query isn't that optimized, it's still only 16 milliseconds.
        Why does it take this long for PHP to get the results ?

Can you try pg_query'ing this exact same query, FROM PHP, and timing it with getmicrotime() ?

You can even do an EXPLAIN ANALYZE from pg_query and display the results in your webpage, to check how long the query takes on the server.

        You can also try it on a Linux box.

        This smells like a TCP communication problem.

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to