Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2011
    Posts
    42

    Question Unanswered: query regarding PG Log column

    I have a few queries regarding columns in Postgres CSV Log.

    Query 1
    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

    ------------------------------------------------------------------

    Query 2
    I have my CSV Log with lot of occurances of a certain Log select statement.

    2012-03-28 19:25:48.015 IST,"postgres","stock_apals",2388,"localhost:1898" ,4f731863.954,7,"idle",2012-03-28 19:25:47 IST,2/98,0,LOG,00000,"statement: SELECT typname, oid FROM pg_type WHERE typname IN ('oidvector', '_oidvector', 'unknown', '_unknown', 'refcursor', '_refcursor', 'char', '_char', 'bpchar', '_bpchar', 'varchar', '_varchar', 'text', '_text', 'name', '_name', 'bytea', '_bytea', 'bit', '_bit', 'bool', '_bool', 'int2', '_int2', 'int4', '_int4', 'int8', '_int8', 'oid', '_oid', 'float4', '_float4', 'float8', '_float8', 'numeric', '_numeric', 'inet', '_inet', 'money', '_money', 'point', '_point', 'lseg', '_lseg', 'path', '_path', 'box', '_box', 'circle', '_circle', 'polygon', '_polygon', 'uuid', '_uuid', 'xml', '_xml', 'interval', '_interval', 'date', '_date', 'time', '_time', 'timetz', '_timetz', 'timestamp', '_timestamp', 'abstime', '_abstime', 'timestamptz', '_timestamptz')",,,,,,,,"exec_simple_query, .\src\backend\tcop\postgres.c:900",""
    Is is a performance concern. ?
    is there anything that i can do to keep this statement from recurring.


    thank you
    arvind

  2. #2
    Join Date
    Aug 2011
    Posts
    42
    Ok i found the answer

    They contain execution statistics for the query. The "user" and "sys"times are acquired by the getrusage(2) or times(2) system call,dependingon 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 thequery.The values in brackets are the values accumulated for this databasesession.

    and the Repeated logline is because of too many recurrance of opening and closing sessiong that take place in a Loop

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •