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

[Giles Westwood]

Giles Westwood wrote:
> Greg Sabino Mullane wrote:
>>> 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.
>>
> 
> Hi Greg,
> 
> We've made quite a few changes from the original version now, the patch 
> is to make all the changes, so it still might be better to just look at 
> the function. For what it's worth I tested on 8.2, and we've seen those 
> columns on 8.1.
> 
> g.
> 
Hi Greg,

Found a typo on the msg line:-

$msg .= " procpid:$procpid, client_addr:$client_addr, 
client_port:$client_port. Run sudo netstat -anp and grep $client_port?";


-- 
Giles Westwood, Systems Administrator,
Semantico, Floor 1, 21-23 Dyke Road, Brighton BN1 3FE
<http://www.semantico.com/>
<mailto:Giles.Westwood at semantico.com>
<tel:+44-1273-358231> <fax:+44-1273-723232>