[check_postgres] Change to show query details for slow query time
Greg Sabino Mullane
greg at endpoint.com
Mon Mar 1 16:31:37 UTC 2010
> We had a need to see the client port of slow query to trace the pid of
> the process holding the connection open. I modified check_postgres to
> display this:-
Excellent, thanks. Two minor things:
* Can you supply this as a diff? Ideally as a github branch, but
any ol' diff is fine.
* Have you tested against older versions of Postgres? I don't know
offhand which columns from pg_stat_activity go back how far, but
check_postgres purports to check back to version 8.
--
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
Url : https://mail.endcrypt.com/pipermail/check_postgres/attachments/20100301/3a6e7727/attachment.bin
More information about the Check_postgres
mailing list