PG Log - Mailing list pgsql-general

From Arvind Singh
Subject PG Log
Date
Msg-id BLU164-W3228F2829E6C7E5B6134BBCA480@phx.gbl
Whole thread Raw
Responses Re: PG Log
List 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

 

pgsql-general by date:

Previous
From: Brian Fehrle
Date:
Subject: Re: scripted 'pg_ctl start' hangs and never finishes, goes
Next
From: Carson Gross
Date:
Subject: why is pg_dump so much smaller than my database?