[check_postgres] Change to show query details for slow query time

Greg Sabino Mullane greg at endpoint.com
Tue Mar 2 16:05:58 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:-

Thanks again - I took the idea and expanded it a bit more, to include 
the username as well, and also took the opportunity to clean up the 
query_time subroutine a lot. Pushed to git if you would like to test.

-- 
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/20100302/543088d7/attachment.bin 


More information about the Check_postgres mailing list