Re: stats for network traffic WIP - Mailing list pgsql-hackers

From Greg Stark
Subject Re: stats for network traffic WIP
Date
Msg-id CAM-w4HPchecrcRPtaL3mzfkLQOy=2DFV7fCywvzQ5D4nXK_2AQ@mail.gmail.com
Whole thread Raw
In response to Re: stats for network traffic WIP  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
<p dir="ltr">I could see this being interesting for FDW plan nodes of the status were visible in explain. Possibly also
timespent waiting on network reads and writes.<p dir="ltr">I have a harder time seeing why it's useful to have these
staysin aggregate but I suppose if you had lots of FDW connections or lots of steaming slaves you might want to be able
toidentify which ones are not getting used or are dominating your network usage. <p dir="ltr">-- <br /> greg<div
class="gmail_quote">On11 Dec 2013 10:52, "Tom Lane" <<a href="mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>>
wrote:<brtype="attribution" /><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc
solid;padding-left:1ex">Atri Sharma <<a href="mailto:atri.jiit@gmail.com">atri.jiit@gmail.com</a>> writes:<br />
>On Wed, Dec 11, 2013 at 11:12 PM, Peter Eisentraut <<a href="mailto:peter_e@gmx.net">peter_e@gmx.net</a>>
wrote:<br/> >> Is there a reason why you can't get this directly from the OS?<br /><br /> > I would say that
itsmore of a convenience to track the usage directly<br /> > from the database instead of setting up OS
infrastructureto store it.<br /><br /> The thing that I'm wondering is why the database would be the right place<br />
tobe measuring it at all.  If you've got a network usage problem,<br /> aggregate usage across everything on the server
isprobably what you<br /> need to be worried about, and PG can't tell you that.<br /><br />                        
regards,tom lane<br /><br /><br /> --<br /> Sent via pgsql-hackers mailing list (<a
href="mailto:pgsql-hackers@postgresql.org">pgsql-hackers@postgresql.org</a>)<br/> To make changes to your
subscription:<br/><a href="http://www.postgresql.org/mailpref/pgsql-hackers"
target="_blank">http://www.postgresql.org/mailpref/pgsql-hackers</a><br/></blockquote></div> 

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: clang's -Wmissing-variable-declarations shows some shoddy programming
Next
From: Jim Nasby
Date:
Subject: Re: Changeset Extraction Interfaces