Re: Incoming/Sent traffic data

I just got a try with the wireshark, it's indeed nice, but I didn't figure a
good filter for knowing what's my app trafic (I'm on localhost), so I put
the 'lo' interface, executed the test, pick some random package that have
just been collected, get the source port (the application port that's
random), and filter packages that use it.

I did a fast test with both languages and it's still look that the Java
traffic is somewhat bigger. (I couldn't isolate the setup traffic)

Total Traffic (same test of before but the select is in a loop of 20
iterations)
28KB python
39KB java

The strange thing is, I compared the results of my proxy and wireshark for
the Java test, and it's ok. For the python test, there was a difference of
10KB between the proxy and wireshark result. I dunno why. I'll have to
explore this a bit more.

Do you have experience with this Macieck? Could I sent direct email to you
regarding the wireshark questions?

2011/5/12 Maciek Sakrejda <msakrejda(at)truviso(dot)com>

> > About the log, i'm using log_statement = "all", on the postgres config,is
> there any
> > other specific option?
>
> You could try setting log_min_messages = debug1 (I don't think
> anything below that--i.e., debug2 through debug5--is useful for your
> case, but you can give it a shot to see what's there).
>
> > My current implementation of proxy just use sockets to transmit the data
> between the app (that's
> > why the port 4444 on connections) to the database, that's how I check the
> size of data
> > transfered with it (it have a GUI to clear the traffic so I can check
> only the operation, not the
> > setup).
>
> Nice. I didn't mean to imply you were entirely unscientific about
> this, just that you should be careful regarding assumptions as to what
> is sent where when. A tool like Wireshark is (relatively) easy to pick
> up and gives you tremendous insight into what's going on on the wire
> with no application changes required (and it even has a PostgreSQL
> protocol plugin by default so you don't need to stare at raw bytes).
>
> ---
> Maciek Sakrejda | System Architect | Truviso
>
> 1065 E. Hillsdale Blvd., Suite 215
> Foster City, CA 94404
> (650) 242-3500 Main
> www.truviso.com
>