Re: Query preformence

From: Ferdinand Smit <ferdinand(at)telegraafnet(dot)nl>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: Query preformence
Date: 2001-11-08 14:09:16
Message-ID: 200111081412.fA8ECNd31462@server9.telegraafnet.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Hoi Tom,

> Sure you do: you look at the execution statistics you don't like and
> then look back to see the most recent query logged by the same backend.

Our DB is heavily used so this would be a full-time job.

> I do see an issue here, which is that the STATISTICS messages should be
> emitted by elog() so that they will be tagged with a PID when log_pid is
> true. But that's easily fixed.

This would be a good solution, so i can generate automatic reports.

Ferdinand

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Greg Sabino Mullane 2001-11-08 15:08:24 Enhanced index details using \d in psql
Previous Message Tom Lane 2001-11-08 13:44:50 Re: Query preformence