| From: | Arvind Singh <arvindps(at)hotmail(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | PG Log |
| Date: | 2012-03-29 05:30:50 |
| Message-ID: | BLU164-W3228F2829E6C7E5B6134BBCA480@phx.gbl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I have queries regarding columns in Postgres CSV Log.
Following is a sample Logline
------------------------------------------------------------------------
2012-03-28 19:25:47.968 IST,"postgres","stock_apals",2388,"localhost:1898",4f731863.954,6,"SET",2012-03-28 19:25:47 IST,2/0,0,LOG,00000,"QUERY STATISTICS","! system usage stats:
! 0.047000 elapsed 0.000000 user 0.000000 system sec
! [0.078125 user 0.031250 sys total]",,,,,"Select * from stock_apals"
,,"ShowUsage, .\src\backend\tcop\postgres.c:4305",""
------------------------------------------------------------------------
I am aware of all the data segments except the following
------------------------------------------------------------------------
"! system usage stats:
! 0.047000 elapsed 0.000000 user 0.000000 system sec
! [0.078125 user 0.031250 sys total]",
------------------------------------------------------------------------
What do the number mean, it seems to appear only with a Logline for SQL statements
thank you
arvind
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Carson Gross | 2012-03-29 05:32:29 | why is pg_dump so much smaller than my database? |
| Previous Message | Brian Fehrle | 2012-03-28 23:33:34 | Re: scripted 'pg_ctl start' hangs and never finishes, goes <defunct> |