API tools faq
paste
Advertisement
Guest User

PostgreSql Sample Log

a guest
Mar 22nd, 2012
314
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.62 KB | None | 0 0
raw download clone embed print report
  1. 2012-03-22 15:14:01.453 IST,"postgres","stock_apals",2980,"localhost:2599",4f6af459.ba4,12,"idle",2012-03-22 15:13:53 IST,,0,LOG,00000,"disconnection: session time: 0:00:08.110 user=postgres database=stock_apals host=localhost port=2599",,,,,,,,"log_disconnections, .\src\backend\tcop\postgres.c:4339",""
  2. 2012-03-22 15:27:14.312 IST,,,4048,,4f6af77a.fd0,1,,2012-03-22 15:27:14 IST,,0,LOG,00000,"SSL certificate revocation list file ""root.crl"" not found, skipping: No such file or directory","Certificates will not be checked against revocation list.",,,,,,,"initialize_SSL, .\src\backend\libpq\be-secure.c:854",""
  3. 2012-03-22 15:27:14.312 IST,,,4048,"",4f6af77a.fd0,2,"",2012-03-22 15:27:14 IST,,0,LOG,00000,"connection received: host=localhost port=2765",,,,,,,,"BackendInitialize, .\src\backend\postmaster\postmaster.c:3414",""
  4. 2012-03-22 15:27:14.328 IST,"postgres","stock_apals",4048,"localhost:2765",4f6af77a.fd0,3,"authentication",2012-03-22 15:27:14 IST,2/436,0,LOG,00000,"connection authorized: user=postgres database=stock_apals",,,,,,,,"PerformAuthentication, .\src\backend\utils\init\postinit.c:242",""
  5. 2012-03-22 15:27:14.343 IST,"postgres","stock_apals",4048,"localhost:2765",4f6af77a.fd0,4,"idle",2012-03-22 15:27:14 IST,2/437,0,LOG,00000,"statement: SET ssl_renegotiation_limit=0",,,,,,,,"exec_simple_query, .\src\backend\tcop\postgres.c:900",""
  6. 2012-03-22 15:27:14.343 IST,"postgres","stock_apals",4048,"localhost:2765",4f6af77a.fd0,5,"SET",2012-03-22 15:27:14 IST,2/0,0,LOG,00000,"duration: 0.000 ms",,,,,,,,"exec_simple_query, .\src\backend\tcop\postgres.c:1128",""
  7. 2012-03-22 15:27:14.343 IST,"postgres","stock_apals",4048,"localhost:2765",4f6af77a.fd0,6,"SET",2012-03-22 15:27:14 IST,2/0,0,LOG,00000,"QUERY STATISTICS","! system usage stats:
  8. ! 0.000000 elapsed 0.000000 user 0.000000 system sec
  9. ! [0.093750 user 0.031250 sys total]",,,,,"SET ssl_renegotiation_limit=0",,"ShowUsage, .\src\backend\tcop\postgres.c:4305",""
  10. 2012-03-22 15:27:14.375 IST,"postgres","stock_apals",4048,"localhost:2765",4f6af77a.fd0,7,"idle",2012-03-22 15:27:14 IST,2/438,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",""
  11. 2012-03-22 15:27:14.390 IST,"postgres","stock_apals",4048,"localhost:2765",4f6af77a.fd0,8,"SELECT",2012-03-22 15:27:14 IST,2/0,0,LOG,00000,"duration: 15.000 ms",,,,,,,,"exec_simple_query, .\src\backend\tcop\postgres.c:1128",""
  12. 2012-03-22 15:27:14.390 IST,"postgres","stock_apals",4048,"localhost:2765",4f6af77a.fd0,9,"SELECT",2012-03-22 15:27:14 IST,2/0,0,LOG,00000,"QUERY STATISTICS","! system usage stats:
  13. ! 0.015000 elapsed 0.015625 user 0.000000 system sec
  14. ! [0.109375 user 0.031250 sys total]",,,,,"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')",,"ShowUsage, .\src\backend\tcop\postgres.c:4305",""
  15. 2012-03-22 15:27:14.406 IST,"postgres","stock_apals",4048,"localhost:2765",4f6af77a.fd0,10,"idle",2012-03-22 15:27:14 IST,2/439,0,LOG,00000,"statement: SELECT version()",,,,,,,,"exec_simple_query, .\src\backend\tcop\postgres.c:900",""
  16. 2012-03-22 15:27:14.406 IST,"postgres","stock_apals",4048,"localhost:2765",4f6af77a.fd0,11,"SELECT",2012-03-22 15:27:14 IST,2/0,0,LOG,00000,"duration: 0.000 ms",,,,,,,,"exec_simple_query, .\src\backend\tcop\postgres.c:1128",""
  17. 2012-03-22 15:27:14.406 IST,"postgres","stock_apals",4048,"localhost:2765",4f6af77a.fd0,12,"SELECT",2012-03-22 15:27:14 IST,2/0,0,LOG,00000,"QUERY STATISTICS","! system usage stats:
  18. ! 0.000000 elapsed 0.000000 user 0.000000 system sec
  19. ! [0.109375 user 0.031250 sys total]",,,,,"SELECT version()",,"ShowUsage, .\src\backend\tcop\postgres.c:4305",""
  20. 2012-03-22 15:27:14.406 IST,"postgres","stock_apals",4048,"localhost:2765",4f6af77a.fd0,13,"idle",2012-03-22 15:27:14 IST,2/440,0,LOG,00000,"statement: unlisten *",,,,,,,,"exec_simple_query, .\src\backend\tcop\postgres.c:900",""
  21. 2012-03-22 15:27:14.406 IST,"postgres","stock_apals",4048,"localhost:2765",4f6af77a.fd0,14,"UNLISTEN",2012-03-22 15:27:14 IST,2/0,0,LOG,00000,"duration: 0.000 ms",,,,,,,,"exec_simple_query, .\src\backend\tcop\postgres.c:1128",""
  22. 2012-03-22 15:27:14.406 IST,"postgres","stock_apals",4048,"localhost:2765",4f6af77a.fd0,15,"UNLISTEN",2012-03-22 15:27:14 IST,2/0,0,LOG,00000,"QUERY STATISTICS","! system usage stats:
  23. ! 0.000000 elapsed 0.000000 user 0.000000 system sec
  24. ! [0.109375 user 0.031250 sys total]",,,,,"unlisten *",,"ShowUsage, .\src\backend\tcop\postgres.c:4305",""
  25. 2012-03-22 15:27:40.546 IST,"postgres","stock_apals",4048,"localhost:2765",4f6af77a.fd0,16,"idle",2012-03-22 15:27:14 IST,2/441,0,LOG,00000,"statement: select 1",,,,,,,,"exec_simple_query, .\src\backend\tcop\postgres.c:900",""
  26. 2012-03-22 15:27:40.546 IST,"postgres","stock_apals",4048,"localhost:2765",4f6af77a.fd0,17,"SELECT",2012-03-22 15:27:14 IST,2/0,0,LOG,00000,"duration: 0.000 ms",,,,,,,,"exec_simple_query, .\src\backend\tcop\postgres.c:1128",""
  27. 2012-03-22 15:27:40.546 IST,"postgres","stock_apals",4048,"localhost:2765",4f6af77a.fd0,18,"SELECT",2012-03-22 15:27:14 IST,2/0,0,LOG,00000,"QUERY STATISTICS","! system usage stats:
  28. ! 0.000000 elapsed 0.000000 user 0.000000 system sec
  29. ! [0.109375 user 0.031250 sys total]",,,,,"select 1",,"ShowUsage, .\src\backend\tcop\postgres.c:4305",""
  30. 2012-03-22 15:27:40.546 IST,"postgres","stock_apals",4048,"localhost:2765",4f6af77a.fd0,19,"idle",2012-03-22 15:27:14 IST,2/442,0,LOG,00000,"statement: SELECT SUBSTR(itemname, 1, 15) as Product,
  31.  
  32. SUM(qty) as TotalSold,
  33.  
  34. AVG(qty) as Average,
  35.  
  36. COUNT(qty) as Transactions,
  37.  
  38. MIN(qty) as MinQty,
  39.  
  40. MAX(qty) as MaxQty,
  41.  
  42. Min(edate) as Startdate,
  43.  
  44. Max(edate) as Lastdate,
  45.  
  46. Max(rate) as MaxRate,
  47.  
  48. Min(rate) as Minrate,
  49.  
  50. avg(rate) as Avgrate
  51.  
  52. FROM issue_stock WHERE extract(year from issue_stock.edate) = '2011'
  53.  
  54. GROUP BY itemname
  55.  
  56. order by itemname",,,,,,,,"exec_simple_query, .\src\backend\tcop\postgres.c:900",""
  57. 2012-03-22 15:27:40.812 IST,"postgres","stock_apals",4048,"localhost:2765",4f6af77a.fd0,20,"SELECT",2012-03-22 15:27:14 IST,2/0,0,LOG,00000,"duration: 266.000 ms",,,,,,,,"exec_simple_query, .\src\backend\tcop\postgres.c:1128",""
  58. 2012-03-22 15:27:40.812 IST,"postgres","stock_apals",4048,"localhost:2765",4f6af77a.fd0,21,"SELECT",2012-03-22 15:27:14 IST,2/0,0,LOG,00000,"QUERY STATISTICS","! system usage stats:
  59. ! 0.266000 elapsed 0.000000 user 0.000000 system sec
  60. ! [0.109375 user 0.031250 sys total]",,,,,"SELECT SUBSTR(itemname, 1, 15) as Product,
  61.  
  62. SUM(qty) as TotalSold,
  63.  
  64. AVG(qty) as Average,
  65.  
  66. COUNT(qty) as Transactions,
  67.  
  68. MIN(qty) as MinQty,
  69.  
  70. MAX(qty) as MaxQty,
  71.  
  72. Min(edate) as Startdate,
  73.  
  74. Max(edate) as Lastdate,
  75.  
  76. Max(rate) as MaxRate,
  77.  
  78. Min(rate) as Minrate,
  79.  
  80. avg(rate) as Avgrate
  81.  
  82. FROM issue_stock WHERE extract(year from issue_stock.edate) = '2011'
  83.  
  84. GROUP BY itemname
  85.  
  86. order by itemname",,"ShowUsage, .\src\backend\tcop\postgres.c:4305",""
  87. 2012-03-22 15:29:53.484 IST,,,2396,,4f6af819.95c,1,,2012-03-22 15:29:53 IST,,0,LOG,00000,"SSL certificate revocation list file ""root.crl"" not found, skipping: No such file or directory","Certificates will not be checked against revocation list.",,,,,,,"initialize_SSL, .\src\backend\libpq\be-secure.c:854",""
  88. 2012-03-22 15:29:53.484 IST,,,2396,"",4f6af819.95c,2,"",2012-03-22 15:29:53 IST,,0,LOG,00000,"connection received: host=localhost port=2766",,,,,,,,"BackendInitialize, .\src\backend\postmaster\postmaster.c:3414",""
  89. 2012-03-22 15:29:53.484 IST,"postgres","stock_apals",2396,"localhost:2766",4f6af819.95c,3,"authentication",2012-03-22 15:29:53 IST,3/74,0,LOG,00000,"connection authorized: user=postgres database=stock_apals",,,,,,,,"PerformAuthentication, .\src\backend\utils\init\postinit.c:242",""
  90. 2012-03-22 15:29:53.484 IST,"postgres","stock_apals",2396,"localhost:2766",4f6af819.95c,4,"idle",2012-03-22 15:29:53 IST,3/75,0,LOG,00000,"statement: SET ssl_renegotiation_limit=0",,,,,,,,"exec_simple_query, .\src\backend\tcop\postgres.c:900",""
  91. 2012-03-22 15:29:53.484 IST,"postgres","stock_apals",2396,"localhost:2766",4f6af819.95c,5,"SET",2012-03-22 15:29:53 IST,3/0,0,LOG,00000,"duration: 0.000 ms",,,,,,,,"exec_simple_query, .\src\backend\tcop\postgres.c:1128",""
  92. 2012-03-22 15:29:53.484 IST,"postgres","stock_apals",2396,"localhost:2766",4f6af819.95c,6,"SET",2012-03-22 15:29:53 IST,3/0,0,LOG,00000,"QUERY STATISTICS","! system usage stats:
  93. ! 0.000000 elapsed 0.000000 user 0.000000 system sec
  94. ! [0.078125 user 0.046875 sys total]",,,,,"SET ssl_renegotiation_limit=0",,"ShowUsage, .\src\backend\tcop\postgres.c:4305",""
  95. 2012-03-22 15:29:53.531 IST,"postgres","stock_apals",2396,"localhost:2766",4f6af819.95c,7,"idle",2012-03-22 15:29:53 IST,3/76,0,LOG,00000,"statement: SELECT SUBSTR(itemname, 1, 15) as Product,
  96.  
  97. avg(rate) as Avgrate
  98.  
  99. FROM issue_stock WHERE extract(year from issue_stock.edate) = '2011'
  100.  
  101. GROUP BY itemname
  102.  
  103. order by itemname",,,,,,,,"exec_simple_query, .\src\backend\tcop\postgres.c:900",""
  104. 2012-03-22 15:29:53.546 IST,"postgres","stock_apals",2396,"localhost:2766",4f6af819.95c,8,"SELECT",2012-03-22 15:29:53 IST,3/0,0,LOG,00000,"duration: 15.000 ms",,,,,,,,"exec_simple_query, .\src\backend\tcop\postgres.c:1128",""
  105. 2012-03-22 15:29:53.546 IST,"postgres","stock_apals",2396,"localhost:2766",4f6af819.95c,9,"SELECT",2012-03-22 15:29:53 IST,3/0,0,LOG,00000,"QUERY STATISTICS","! system usage stats:
  106. ! 0.015000 elapsed 0.000000 user 0.015625 system sec
  107. ! [0.078125 user 0.062500 sys total]",,,,,"SELECT SUBSTR(itemname, 1, 15) as Product,
  108.  
  109. avg(rate) as Avgrate
  110.  
  111. FROM issue_stock WHERE extract(year from issue_stock.edate) = '2011'
  112.  
  113. GROUP BY itemname
  114.  
  115. order by itemname",,"ShowUsage, .\src\backend\tcop\postgres.c:4305",""
  116. 2012-03-22 15:38:47.390 IST,"postgres","stock_apals",2396,"localhost:2766",4f6af819.95c,10,"idle",2012-03-22 15:29:53 IST,3/0,0,LOG,08P01,"unexpected EOF on client connection",,,,,,,,"SocketBackend, .\src\backend\tcop\postgres.c:348",""
  117. 2012-03-22 15:38:47.390 IST,"postgres","stock_apals",2396,"localhost:2766",4f6af819.95c,11,"idle",2012-03-22 15:29:53 IST,,0,LOG,00000,"disconnection: session time: 0:08:53.906 user=postgres database=stock_apals host=localhost port=2766",,,,,,,,"log_disconnections, .\src\backend\tcop\postgres.c:4339",""
  118. 2012-03-22 15:38:47.390 IST,"postgres","stock_apals",4048,"localhost:2765",4f6af77a.fd0,22,"idle",2012-03-22 15:27:14 IST,2/0,0,LOG,XX000,"could not receive data from client: No connection could be made because the target machine actively refused it.
  119.  
  120. ",,,,,,,,"pq_recvbuf, .\src\backend\libpq\pqcomm.c:779",""
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!