1. 2012-05-18 13:55:39 EEST [6168]: [1-1] LOG: database system was shut down at 2012-05-18 13:55:36 EEST
  2. 2012-05-18 13:55:39 EEST [4256]: [1-1] LOG: database system is ready to accept connections
  3. 2012-05-18 13:55:39 EEST [6420]: [1-1] LOG: autovacuum launcher started
  4. 2012-05-18 13:55:41 EEST [4520]: [1-1] LOG: statement: SELECT version();
  5. 2012-05-18 13:55:41 EEST [4520]: [2-1] LOG: duration: 2.000 ms
  6. 2012-05-18 13:55:41 EEST [4520]: [3-1] LOG: statement: SET DateStyle=ISO;
  7. SET bytea_output=escape;
  8. SELECT oid, pg_encoding_to_char(encoding) AS encoding, datlastsysoid
  9. FROM pg_database WHERE datname='postgres'
  10. 2012-05-18 13:55:41 EEST [4520]: [4-1] LOG: duration: 5.000 ms
  11. 2012-05-18 13:55:41 EEST [4520]: [5-1] LOG: statement: set client_encoding to 'UNICODE'
  12. 2012-05-18 13:55:41 EEST [4520]: [6-1] LOG: duration: 0.000 ms
  13. 2012-05-18 13:55:41 EEST [4520]: [7-1] LOG: statement: SELECT usecreatedb, usesuper, CASE WHEN usesuper THEN pg_postmaster_start_time() ELSE NULL END as upsince, CASE WHEN usesuper THEN pg_conf_load_time() ELSE NULL END as confloadedsince, CASE WHEN usesuper THEN pg_is_in_recovery() ELSE NULL END as inrecovery, CASE WHEN usesuper THEN pg_last_xlog_receive_location() ELSE NULL END as receiveloc, CASE WHEN usesuper THEN pg_last_xlog_replay_location() ELSE NULL END as replayloc, CASE WHEN usesuper THEN pg_last_xact_replay_timestamp() ELSE NULL END as replay_timestamp, CASE WHEN usesuper AND pg_is_in_recovery() THEN pg_is_xlog_replay_paused() ELSE NULL END as isreplaypaused
  14. FROM pg_user WHERE usename=current_user
  15. 2012-05-18 13:55:41 EEST [4520]: [8-1] LOG: duration: 3.000 ms
  16. 2012-05-18 13:55:41 EEST [4520]: [9-1] LOG: statement: SELECT rolcreaterole, rolcreatedb FROM pg_roles WHERE rolname = current_user;
  17. 2012-05-18 13:55:41 EEST [4520]: [10-1] LOG: duration: 1.000 ms
  18. 2012-05-18 13:55:41 EEST [4520]: [11-1] LOG: statement: SELECT db.oid, datname, db.dattablespace AS spcoid, spcname, datallowconn, (SELECT array(select coalesce('''' || rolname || '''', '') || '=' || unnest(setconfig) FROM pg_db_role_setting setting LEFT JOIN pg_roles role ON setting.setrole=role.oid WHERE setdatabase = db.oid)) AS datconfig, datacl, pg_encoding_to_char(encoding) AS serverencoding, pg_get_userbyid(datdba) AS datowner,has_database_privilege(db.oid, 'CREATE') as cancreate,
  19. current_setting('default_tablespace') AS default_tablespace,
  20. descr.description
  21. , db.datconnlimit as connectionlimit, db.datcollate as collate, db.datctype as ctype FROM pg_database db
  22. LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
  23. LEFT OUTER JOIN pg_shdescription descr ON db.oid=descr.objoid
  24. ORDER BY datname
  25. 2012-05-18 13:55:41 EEST [4520]: [12-1] LOG: duration: 6.000 ms
  26. 2012-05-18 13:55:41 EEST [4520]: [13-1] LOG: statement: SELECT ts.oid, spcname, spclocation, spcoptions, pg_get_userbyid(spcowner) as spcuser, spcacl, pg_catalog.shobj_description(oid, 'pg_tablespace') AS description FROM pg_tablespace ts
  27. ORDER BY spcname
  28. 2012-05-18 13:55:41 EEST [4520]: [14-1] LOG: duration: 2.000 ms
  29. 2012-05-18 13:55:41 EEST [4520]: [15-1] LOG: statement: SELECT cl.oid FROM pg_class cl JOIN pg_namespace ns ON ns.oid=relnamespace
  30. WHERE relname='pga_job' AND nspname='pgagent'
  31. 2012-05-18 13:55:41 EEST [4520]: [16-1] LOG: duration: 1.000 ms
  32. 2012-05-18 13:55:41 EEST [4520]: [17-1] LOG: statement: SELECT has_table_privilege('pg_authid', 'SELECT')
  33. 2012-05-18 13:55:41 EEST [4520]: [18-1] LOG: duration: 1.000 ms
  34. 2012-05-18 13:55:41 EEST [4520]: [19-1] LOG: statement: SELECT tab.oid, tab.*, pg_catalog.shobj_description(tab.oid, 'pg_authid') AS description, setting.setconfig AS rolconfig FROM pg_authid tab LEFT OUTER JOIN pg_db_role_setting setting ON (tab.oid=setting.setrole AND setting.setdatabase=0)
  35. WHERE NOT rolcanlogin ORDER BY rolname
  36. 2012-05-18 13:55:41 EEST [4520]: [20-1] LOG: duration: 1.000 ms
  37. 2012-05-18 13:55:41 EEST [4520]: [21-1] LOG: statement: SELECT has_table_privilege('pg_authid', 'SELECT')
  38. 2012-05-18 13:55:41 EEST [4520]: [22-1] LOG: duration: 0.000 ms
  39. 2012-05-18 13:55:41 EEST [4520]: [23-1] LOG: statement: SELECT tab.oid, tab.*, pg_catalog.shobj_description(tab.oid, 'pg_authid') AS description, setting.setconfig AS rolconfig FROM pg_authid tab LEFT OUTER JOIN pg_db_role_setting setting ON (tab.oid=setting.setrole AND setting.setdatabase=0)
  40. WHERE rolcanlogin ORDER BY rolname
  41. 2012-05-18 13:55:41 EEST [4520]: [24-1] LOG: duration: 1.000 ms
  42. 2012-05-18 13:55:41 EEST [4520]: [25-1] LOG: statement: SELECT setting FROM pg_settings WHERE name IN ('autovacuum', 'track_counts')
  43. 2012-05-18 13:55:41 EEST [4520]: [26-1] LOG: duration: 1.000 ms
  44. 2012-05-18 13:55:41 EEST [4520]: [27-1] LOG: statement: SELECT version();
  45. 2012-05-18 13:55:41 EEST [4520]: [28-1] LOG: duration: 0.000 ms
  46. 2012-05-18 13:55:41 EEST [4520]: [29-1] LOG: statement: SELECT proname, pronargs, proargtypes[0] AS arg0, proargtypes[1] AS arg1, proargtypes[2] AS arg2
  47. FROM pg_proc
  48. JOIN pg_namespace n ON n.oid=pronamespace
  49. WHERE proname IN ('pg_tablespace_size', 'pg_file_read', 'pg_logfile_rotate', 'pg_postmaster_starttime', 'pg_terminate_backend', 'pg_reload_conf', 'pgstattuple', 'pgstatindex')
  50. AND nspname IN ('pg_catalog', 'public')

postgresql log for pgFouine

Comments powered by Disqus