Postgres

The postgres.log file is the main database log file. It contains information about database activities.

Log files

/nz/kit/log/postgres/pg.log: Current log
/nz/kit/log/postgres/pg.log.n: Archived log

Sample messages

2012-12-31 04:02:10.229470 EST [19122]  DEBUG:  connection: host=1.2.3.4 user=
MYUSR database=SYSTEM remotepid=6792 fetype=1
2012-12-31 04:02:10.229485 EST [19122]  DEBUG:  Session id is 325340
2012-12-31 04:02:10.231134 EST [19122]  DEBUG:  QUERY: set min_quotient_scale to 
default
2012-12-31 04:02:10.231443 EST [19122]  DEBUG:  QUERY: set timezone = 'gmt'
2012-12-31 09:02:10.231683 gmt [19122]  DEBUG:  QUERY: select current_timestamp,
avg(sds_size*1.05)::integer as avg_ds_total, avg(sds_used/(1024*1024))::integer as
avg_ds_used from _v_spudevicestate