Arvind Singh wrote: > 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 These lines are emitted if you set log_statement_stats to "on". They contain execution statistics for the query. The "user" and "sys" times are acquired by the getrusage(2) or times(2) system call, depending on your operating system (on Windows, GetProcessTimes is used). You can look at the man page for your system for details. The values you see are: wall time, CPU user time and kernel CPU time it took to execute the query. The values in brackets are the values accumulated for this database session. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
