Thread: CSVLOG fields
I tested the csvlog option for PostgreSQL and it works beautifully. Where can I find the reference information for all fields? I'd like to write a little Perl script, something like PgFouine or pgsi, but working on the csv version, which is the easiest one to parse. -- Mladen Gogala Sr. Oracle DBA 1500 Broadway New York, NY 10036 (212) 329-5251 http://www.vmsinfo.com The Leader in Integrated Media Intelligence Solutions
On Thu, Nov 11, 2010 at 8:58 AM, Mladen Gogala <mladen.gogala@vmsinfo.com> wrote: > I tested the csvlog option for PostgreSQL and it works beautifully. Where > can I find the reference information for all fields? Forgive me, if you've already seen this but this is all I'm familiar with: http://www.postgresql.org/docs/9.0/interactive/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-CSVLOG -- Regards, Richard Broersma Jr. Visit the Los Angeles PostgreSQL Users Group (LAPUG) http://pugs.postgresql.org/lapug
Richard Broersma wrote: > On Thu, Nov 11, 2010 at 8:58 AM, Mladen Gogala > <mladen.gogala@vmsinfo.com> wrote: > >> I tested the csvlog option for PostgreSQL and it works beautifully. Where >> can I find the reference information for all fields? >> > > Forgive me, if you've already seen this but this is all I'm familiar with: > http://www.postgresql.org/docs/9.0/interactive/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-CSVLOG > > > Thanks Richard! I have somehow missed that. I was trying to calculate the duration of the invocation in the CSV file. -- Mladen Gogala Sr. Oracle DBA 1500 Broadway New York, NY 10036 (212) 329-5251 http://www.vmsinfo.com The Leader in Integrated Media Intelligence Solutions
On Thu, Nov 11, 2010 at 10:04 AM, Mladen Gogala <mladen.gogala@vmsinfo.com> wrote: > Thanks Richard! I have somehow missed that. I'm glad that I could help. > I was trying to calculate the > duration of the invocation in the CSV file. I not sure I understand, did the link provide you with the answer you needed? -- Regards, Richard Broersma Jr. Visit the Los Angeles PostgreSQL Users Group (LAPUG) http://pugs.postgresql.org/lapug
Mladen,
Do you mean something like this?
http://www.postgresql.org/docs/current/static/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-CSVLOG
It isn't a verbose description but the columns within the table creation script give enough information to figure out what each item of information represents.
Do you mean something like this?
http://www.postgresql.org/docs/current/static/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-CSVLOG
It isn't a verbose description but the columns within the table creation script give enough information to figure out what each item of information represents.
On Thu, Nov 11, 2010 at 4:58 PM, Mladen Gogala <mladen.gogala@vmsinfo.com> wrote:
I tested the csvlog option for PostgreSQL and it works beautifully. Where can I find the reference information for all fields? I'd like to write a little Perl script, something like PgFouine or pgsi, but working on the csv version, which is the easiest one to parse.
--
Mladen Gogala Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
http://www.vmsinfo.com The Leader in Integrated Media Intelligence Solutions
--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice
Hi Mladen, I am interested in writing the same perl script as you mentioned. Have you finished it yet? Best regards, Roye -- View this message in context: http://postgresql.1045698.n5.nabble.com/CSVLOG-fields-tp3260652p4991136.html Sent from the PostgreSQL - novice mailing list archive at Nabble.com.