Re: Query preformence - Mailing list pgsql-patches

From Ferdinand Smit
Subject Re: Query preformence
Date
Msg-id 200111081412.fA8ECNd31462@server9.telegraafnet.nl
Whole thread Raw
In response to Re: Query preformence  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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

pgsql-patches by date:

Previous
From: Karel Zak
Date:
Subject: Re: stupid patch of pg_dumplo
Next
From: "Greg Sabino Mullane"
Date:
Subject: Enhanced index details using \d in psql