On Wed, Feb 6, 2013 at 9:52 PM, Kevin Grittner <kgri...@ymail.com> wrote: > Will Platnick <wplatn...@gmail.com> wrote: >> Will Platnick <wplatn...@gmail.com> wrote: > >>> The only thing that stands out is: on your production server I see >>> "Total runtime: 7.515 ms", but the top node in EXPLAIN ANAYZE shows >>> actual time as 0.179 ms. Not sure where that additional time is being >>> spent though. It could be ExecutorStart/End, but have no idea why they >>> should take so long. > >> Any ideas on how to troubleshoot this delay? > > Is the client which is running the query on the same machine as the > server? If not, what's the ping time between them? >
I don't think the network latency can cause that. The "Total runtime" is calculated on the server side itself - see ExplainOnePlan(). Thanks, Pavan -- Pavan Deolasee http://www.linkedin.com/in/pavandeolasee -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
