- 2012-05-18 13:55:39 EEST [6168]: [1-1] LOG: database system was shut down at 2012-05-18 13:55:36 EEST
- 2012-05-18 13:55:39 EEST [4256]: [1-1] LOG: database system is ready to accept connections
- 2012-05-18 13:55:39 EEST [6420]: [1-1] LOG: autovacuum launcher started
- 2012-05-18 13:55:41 EEST [4520]: [1-1] LOG: statement: SELECT version();
- 2012-05-18 13:55:41 EEST [4520]: [2-1] LOG: duration: 2.000 ms
- 2012-05-18 13:55:41 EEST [4520]: [3-1] LOG: statement: SET DateStyle=ISO;
- SET bytea_output=escape;
- SELECT oid, pg_encoding_to_char(encoding) AS encoding, datlastsysoid
- FROM pg_database WHERE datname='postgres'
- 2012-05-18 13:55:41 EEST [4520]: [4-1] LOG: duration: 5.000 ms
- 2012-05-18 13:55:41 EEST [4520]: [5-1] LOG: statement: set client_encoding to 'UNICODE'
- 2012-05-18 13:55:41 EEST [4520]: [6-1] LOG: duration: 0.000 ms
- 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
- FROM pg_user WHERE usename=current_user
- 2012-05-18 13:55:41 EEST [4520]: [8-1] LOG: duration: 3.000 ms
- 2012-05-18 13:55:41 EEST [4520]: [9-1] LOG: statement: SELECT rolcreaterole, rolcreatedb FROM pg_roles WHERE rolname = current_user;
- 2012-05-18 13:55:41 EEST [4520]: [10-1] LOG: duration: 1.000 ms
- 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,
- current_setting('default_tablespace') AS default_tablespace,
- descr.description
- , db.datconnlimit as connectionlimit, db.datcollate as collate, db.datctype as ctype FROM pg_database db
- LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
- LEFT OUTER JOIN pg_shdescription descr ON db.oid=descr.objoid
- ORDER BY datname
- 2012-05-18 13:55:41 EEST [4520]: [12-1] LOG: duration: 6.000 ms
- 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
- ORDER BY spcname
- 2012-05-18 13:55:41 EEST [4520]: [14-1] LOG: duration: 2.000 ms
- 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
- WHERE relname='pga_job' AND nspname='pgagent'
- 2012-05-18 13:55:41 EEST [4520]: [16-1] LOG: duration: 1.000 ms
- 2012-05-18 13:55:41 EEST [4520]: [17-1] LOG: statement: SELECT has_table_privilege('pg_authid', 'SELECT')
- 2012-05-18 13:55:41 EEST [4520]: [18-1] LOG: duration: 1.000 ms
- 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)
- WHERE NOT rolcanlogin ORDER BY rolname
- 2012-05-18 13:55:41 EEST [4520]: [20-1] LOG: duration: 1.000 ms
- 2012-05-18 13:55:41 EEST [4520]: [21-1] LOG: statement: SELECT has_table_privilege('pg_authid', 'SELECT')
- 2012-05-18 13:55:41 EEST [4520]: [22-1] LOG: duration: 0.000 ms
- 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)
- WHERE rolcanlogin ORDER BY rolname
- 2012-05-18 13:55:41 EEST [4520]: [24-1] LOG: duration: 1.000 ms
- 2012-05-18 13:55:41 EEST [4520]: [25-1] LOG: statement: SELECT setting FROM pg_settings WHERE name IN ('autovacuum', 'track_counts')
- 2012-05-18 13:55:41 EEST [4520]: [26-1] LOG: duration: 1.000 ms
- 2012-05-18 13:55:41 EEST [4520]: [27-1] LOG: statement: SELECT version();
- 2012-05-18 13:55:41 EEST [4520]: [28-1] LOG: duration: 0.000 ms
- 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
- FROM pg_proc
- JOIN pg_namespace n ON n.oid=pronamespace
- WHERE proname IN ('pg_tablespace_size', 'pg_file_read', 'pg_logfile_rotate', 'pg_postmaster_starttime', 'pg_terminate_backend', 'pg_reload_conf', 'pgstattuple', 'pgstatindex')
- AND nspname IN ('pg_catalog', 'public')
postgresql log for pgFouine