Search Postgresql Archives

PG Log

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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

 

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux