Hi dave good idea - did'nt know this feature :(
Am 09.11.2016 um 17:38 schrieb Dave Page:
Further suggestion: - Set the log level to debug. - Stop pgAdmin - Delete the log - Start pgAdmin, open the status dialogue and wait for a few minutes - Close pgAdmin and send the log
see log regards walter
INFO : 18:54:15: ############################################################## INFO : 18:54:15: # pgAdmin III Version 1.22.1 Startup INFO : 18:54:15: ############################################################## INFO : 18:54:15: Compiled with dynamically linked SSL support INFO : 18:54:15: Running a DEBUG build. INFO : 18:54:15: i18n path : /usr/share/pgadmin3/i18n INFO : 18:54:15: UI path : INFO : 18:54:15: Doc path : /usr/share/pgadmin3/docs INFO : 18:54:15: Branding path : /usr/share/pgadmin3/branding INFO : 18:54:15: Plugins path : /usr/share/pgadmin3/plugins.d INFO : 18:54:15: Settings INI : /usr/share/pgadmin3/settings.ini INFO : 18:54:15: PG pg_dump : /usr/bin/pg_dump INFO : 18:54:15: PG pg_dumpall : /usr/bin/pg_dumpall INFO : 18:54:15: PG pg_restore : /usr/bin/pg_restore INFO : 18:54:15: EDB pg_dump : INFO : 18:54:15: EDB pg_dumpall: INFO : 18:54:15: EDB pg_restore: INFO : 18:54:15: Greenplum pg_dump : INFO : 18:54:15: Greenplum pg_dumpall: INFO : 18:54:15: Greenplum pg_restore: INFO : 18:54:15: Using embedded XRC data. INFO : 18:54:16: PG Help : http://www.postgresql.org/docs/current/static/ INFO : 18:54:16: EDB Help : http://www.enterprisedb.com/docs/en/current/server/ INFO : 18:54:16: Greenplum Help: http://gpdb.docs.pivotal.io/ INFO : 18:54:16: Slony Help : http://www.slony.info/documentation/ INFO : 18:54:16: Using fontmetrics 9/17, 11 Point INFO : 18:54:16: Native Description 'Ubuntu 11' INFO : 18:54:16: Draw size of 'M': w=13, h=17, descent 3, external lead 0. INFO : 18:54:16: Draw size of 'g': w=9, h=17, descent 3, external lead 0. INFO : 18:54:16: Draw size of 'Mg': w=22, h=17, descent 3, external lead 0. INFO : 18:54:16: Loading plugin ini files from /usr/share/pgadmin3/plugins.d INFO : 18:54:16: Loading plugin utilities from /usr/share/pgadmin3/plugins.d/plugins.ini INFO : 18:54:16: Adding plugin utility: PSQL Console INFO : 18:54:16: Command: /usr/bin/x-terminal-emulator -e "$$PGBINDIR/psql" --host "$$HOSTNAME" --port $$PORT --username "$$USERNAME" "$$DATABASE" INFO : 18:54:16: Description: Open a PSQL console to the current database. INFO : 18:54:16: Database?: Yes INFO : 18:54:16: Set Password?: Yes INFO : 18:54:16: Reloading servers... INFO : 18:54:16: Loading previously registered servers INFO : 18:54:16: Loading servers registered on the local machine INFO : 18:54:16: Displaying properties for Servers Servers STATUS : 18:54:16: Hole Details zu Servern... STATUS : 18:54:16: Hole Details zu Servern... (0 msec) INFO : 18:54:19: Displaying properties for Server server:5432 STATUS : 18:54:19: Hole Details zum Server server... STATUS : 18:54:19: Hole Details zum Server server... (4 msec) INFO : 18:54:20: Attempting to create a connection object... INFO : 18:54:20: Using password file /home/walter/.pgpass STATUS : 18:54:20: Datenbankverbindung herstellen... INFO : 18:54:20: Opening connection with connection string: host='server' dbname='planet2' user='postgres' port=5432 application_name='pgAdmin III- Browser' QUERY : 18:54:20: Scalar query (server:5432): SELECT version(); QUERY : 18:54:20: Query result: PostgreSQL 9.4.6 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu 4.8.2-19ubuntu1) 4.8.2, 64-bit QUERY : 18:54:20: Set query (server:5432): SET DateStyle=ISO; SET client_min_messages=notice; SET bytea_output=escape; SELECT oid, pg_encoding_to_char(encoding) AS encoding, datlastsysoid FROM pg_database WHERE datname='planet2' INFO : 18:54:20: Setting client_encoding to 'UNICODE' QUERY : 18:54:20: Set query (server:5432): 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 QUERY : 18:54:20: Set query (server:5432): SELECT rolcreaterole, rolcreatedb FROM pg_roles WHERE rolname = current_user; STATUS : 18:54:20: Datenbankverbindung herstellen... (21 msec) STATUS : 18:54:20: Vorherige Umgebung wiederherstellen... INFO : 18:54:20: pgServer object initialised as required. INFO : 18:54:20: Adding child object to server server:5432 QUERY : 18:54:20: Set query (server:5432): SELECT db.oid, datname, db.dattablespace AS spcoid, spcname, datallowconn, 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, (SELECT array_agg(label) FROM pg_shseclabel sl1 WHERE sl1.objoid=db.oid) AS labels, (SELECT array_agg(provider) FROM pg_shseclabel sl2 WHERE sl2.objoid=db.oid) AS providers 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 AND descr.classoid='pg_database'::regclass) ORDER BY datname QUERY : 18:54:20: Set query (server:5432): SELECT ts.oid, spcname, pg_catalog.pg_tablespace_location(ts.oid) AS spclocation, spcoptions, pg_get_userbyid(spcowner) as spcuser, spcacl, pg_catalog.shobj_description(oid, 'pg_tablespace') AS description, (SELECT array_agg(label) FROM pg_shseclabel sl1 WHERE sl1.objoid=ts.oid) AS labels, (SELECT array_agg(provider) FROM pg_shseclabel sl2 WHERE sl2.objoid=ts.oid) AS providers FROM pg_tablespace ts ORDER BY spcname QUERY : 18:54:20: Scalar query (server:5432): SELECT cl.oid FROM pg_class cl JOIN pg_namespace ns ON ns.oid=relnamespace WHERE relname='pga_job' AND nspname='pgagent' INFO : 18:54:20: Query returned no tuples QUERY : 18:54:20: Scalar query (server:5432): SELECT has_table_privilege('pg_authid', 'SELECT') QUERY : 18:54:20: Query result: t QUERY : 18:54:20: Set query (server:5432): SELECT tab.oid, tab.*, pg_catalog.shobj_description(tab.oid, 'pg_authid') AS description, (SELECT array_agg(label) FROM pg_shseclabel sl1 WHERE sl1.objoid=tab.oid) AS labels, (SELECT array_agg(provider) FROM pg_shseclabel sl2 WHERE sl2.objoid=tab.oid) AS providers FROM pg_authid tab WHERE NOT rolcanlogin ORDER BY rolname QUERY : 18:54:20: Scalar query (server:5432): SELECT has_table_privilege('pg_authid', 'SELECT') QUERY : 18:54:20: Query result: t QUERY : 18:54:20: Set query (server:5432): SELECT tab.oid, tab.*, pg_catalog.shobj_description(tab.oid, 'pg_authid') AS description, (SELECT array_agg(label) FROM pg_shseclabel sl1 WHERE sl1.objoid=tab.oid) AS labels, (SELECT array_agg(provider) FROM pg_shseclabel sl2 WHERE sl2.objoid=tab.oid) AS providers FROM pg_authid tab WHERE rolcanlogin ORDER BY rolname QUERY : 18:54:20: Set query (server:5432): SELECT setting FROM pg_settings WHERE name IN ('autovacuum', 'track_counts') INFO : 18:54:20: Displaying properties for Databases Databases INFO : 18:54:20: Displaying properties for Database planet2 QUERY : 18:54:20: Scalar query (server:5432): SELECT proname FROM pg_proc WHERE proname='pg_get_viewdef' AND proargtypes[1]=16 QUERY : 18:54:20: Query result: pg_get_viewdef QUERY : 18:54:20: Scalar query (server:5432): SHOW search_path QUERY : 18:54:20: Query result: "$user",public QUERY : 18:54:20: Set query (server:5432): SELECT nspname, session_user=nspname AS isuser FROM pg_namespace QUERY : 18:54:20: Scalar query (server:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 0::OID AND defaclobjtype='r' INFO : 18:54:20: Query returned no tuples QUERY : 18:54:20: Scalar query (server:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 0::OID AND defaclobjtype='S' INFO : 18:54:20: Query returned no tuples QUERY : 18:54:20: Scalar query (server:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 0::OID AND defaclobjtype='f' INFO : 18:54:20: Query returned no tuples QUERY : 18:54:20: Scalar query (server:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 0::OID AND defaclobjtype='T' INFO : 18:54:20: Query returned no tuples INFO : 18:54:20: Adding child object to database planet2 QUERY : 18:54:20: Set query (server:5432): SELECT 2 AS nsptyp, nsp.nspname, nsp.oid, pg_get_userbyid(nspowner) AS namespaceowner, nspacl, description, FALSE as cancreate FROM pg_namespace nsp LEFT OUTER JOIN pg_description des ON (des.objoid=nsp.oid AND des.classoid='pg_namespace'::regclass) WHERE ((nspname = 'pg_catalog' AND EXISTS (SELECT 1 FROM pg_class WHERE relname = 'pg_class' AND relnamespace = nsp.oid LIMIT 1)) OR (nspname = 'pgagent' AND EXISTS (SELECT 1 FROM pg_class WHERE relname = 'pga_job' AND relnamespace = nsp.oid LIMIT 1)) OR (nspname = 'information_schema' AND EXISTS (SELECT 1 FROM pg_class WHERE relname = 'tables' AND relnamespace = nsp.oid LIMIT 1)) OR (nspname LIKE '_%' AND EXISTS (SELECT 1 FROM pg_proc WHERE proname='slonyversion' AND pronamespace = nsp.oid LIMIT 1)) ) AND nspname NOT LIKE E'pg\\_temp\\_%'AND nspname NOT LIKE E'pg\\_toast_temp\\_%' ORDER BY 1, nspname QUERY : 18:54:20: Scalar query (server:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 11635::oid AND defaclobjtype='r' INFO : 18:54:20: Query returned no tuples QUERY : 18:54:20: Scalar query (server:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 11635::oid AND defaclobjtype='S' INFO : 18:54:20: Query returned no tuples QUERY : 18:54:20: Scalar query (server:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 11635::oid AND defaclobjtype='f' INFO : 18:54:20: Query returned no tuples QUERY : 18:54:20: Scalar query (server:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 11635::oid AND defaclobjtype='T' INFO : 18:54:20: Query returned no tuples QUERY : 18:54:20: Scalar query (server:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 11::oid AND defaclobjtype='r' INFO : 18:54:20: Query returned no tuples QUERY : 18:54:20: Scalar query (server:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 11::oid AND defaclobjtype='S' INFO : 18:54:20: Query returned no tuples QUERY : 18:54:20: Scalar query (server:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 11::oid AND defaclobjtype='f' INFO : 18:54:20: Query returned no tuples QUERY : 18:54:20: Scalar query (server:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 11::oid AND defaclobjtype='T' INFO : 18:54:20: Query returned no tuples QUERY : 18:54:20: Set query (server:5432): SELECT e.oid, e.xmin, e.evtname AS name, REPLACE(e.evtevent, '_', ' ') AS eventname, pg_catalog.pg_get_userbyid(e.evtowner) AS eventowner, CASE e.evtenabled WHEN 'O' THEN 'enabled' WHEN 'R' THEN 'replica' WHEN 'A' THEN 'always' WHEN 'D' THEN 'disabled' END AS enabled, e.evtfoid AS eventfuncoid, e.evtfoid::regproc AS eventfunname, array_to_string(array(select quote_literal(x) from unnest(evttags) as t(x)), ', ') AS when, pg_catalog.obj_description(e.oid, 'pg_event_trigger') AS comment, p.prosrc AS source, p.pronamespace AS schemaoid, l.lanname AS language FROM pg_event_trigger e LEFT OUTER JOIN pg_proc p ON p.oid=e.evtfoid LEFT OUTER JOIN pg_language l ON l.oid=p.prolang WHERE 1=1 ORDER BY e.evtname QUERY : 18:54:20: Set query (server:5432): select x.oid, pg_get_userbyid(extowner) AS owner, x.extname, n.nspname, x.extrelocatable, x.extversion, e.comment FROM pg_extension x JOIN pg_namespace n on x.extnamespace=n.oid join pg_available_extensions() e(name, default_version, comment) ON x.extname=e.name ORDER BY x.extname QUERY : 18:54:20: Set query (server:5432): SELECT CASE WHEN nspname LIKE E'pg\\_temp\\_%' THEN 1 WHEN (nspname LIKE E'pg\\_%') THEN 0 ELSE 3 END AS nsptyp, nsp.nspname, nsp.oid, pg_get_userbyid(nspowner) AS namespaceowner, nspacl, description, has_schema_privilege(nsp.oid, 'CREATE') as cancreate, (SELECT array_agg(label) FROM pg_seclabels sl1 WHERE sl1.objoid=nsp.oid) AS labels, (SELECT array_agg(provider) FROM pg_seclabels sl2 WHERE sl2.objoid=nsp.oid) AS providers FROM pg_namespace nsp LEFT OUTER JOIN pg_description des ON (des.objoid=nsp.oid AND des.classoid='pg_namespace'::regclass) WHERE NOT ((nspname = 'pg_catalog' AND EXISTS (SELECT 1 FROM pg_class WHERE relname = 'pg_class' AND relnamespace = nsp.oid LIMIT 1)) OR (nspname = 'pgagent' AND EXISTS (SELECT 1 FROM pg_class WHERE relname = 'pga_job' AND relnamespace = nsp.oid LIMIT 1)) OR (nspname = 'information_schema' AND EXISTS (SELECT 1 FROM pg_class WHERE relname = 'tables' AND relnamespace = nsp.oid LIMIT 1)) OR (nspname LIKE '_%' AND EXISTS (SELECT 1 FROM pg_proc WHERE proname='slonyversion' AND pronamespace = nsp.oid LIMIT 1)) ) AND nspname NOT LIKE E'pg\\_temp\\_%'AND nspname NOT LIKE E'pg\\_toast_temp\\_%' ORDER BY 1, nspname QUERY : 18:54:20: Scalar query (server:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 1104534246::oid AND defaclobjtype='r' INFO : 18:54:20: Query returned no tuples QUERY : 18:54:20: Scalar query (server:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 1104534246::oid AND defaclobjtype='S' INFO : 18:54:20: Query returned no tuples QUERY : 18:54:20: Scalar query (server:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 1104534246::oid AND defaclobjtype='f' INFO : 18:54:20: Query returned no tuples QUERY : 18:54:20: Scalar query (server:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 1104534246::oid AND defaclobjtype='T' INFO : 18:54:20: Query returned no tuples QUERY : 18:54:20: Scalar query (server:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 328075373::oid AND defaclobjtype='r' INFO : 18:54:20: Query returned no tuples QUERY : 18:54:20: Scalar query (server:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 328075373::oid AND defaclobjtype='S' INFO : 18:54:20: Query returned no tuples QUERY : 18:54:20: Scalar query (server:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 328075373::oid AND defaclobjtype='f' INFO : 18:54:20: Query returned no tuples QUERY : 18:54:20: Scalar query (server:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 328075373::oid AND defaclobjtype='T' INFO : 18:54:20: Query returned no tuples QUERY : 18:54:20: Scalar query (server:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 328053574::oid AND defaclobjtype='r' INFO : 18:54:20: Query returned no tuples QUERY : 18:54:20: Scalar query (server:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 328053574::oid AND defaclobjtype='S' INFO : 18:54:20: Query returned no tuples QUERY : 18:54:20: Scalar query (server:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 328053574::oid AND defaclobjtype='f' INFO : 18:54:20: Query returned no tuples QUERY : 18:54:20: Scalar query (server:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 328053574::oid AND defaclobjtype='T' INFO : 18:54:20: Query returned no tuples QUERY : 18:54:20: Scalar query (server:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 2200::oid AND defaclobjtype='r' INFO : 18:54:20: Query returned no tuples QUERY : 18:54:20: Scalar query (server:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 2200::oid AND defaclobjtype='S' INFO : 18:54:20: Query returned no tuples QUERY : 18:54:20: Scalar query (server:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 2200::oid AND defaclobjtype='f' INFO : 18:54:20: Query returned no tuples QUERY : 18:54:20: Scalar query (server:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 2200::oid AND defaclobjtype='T' INFO : 18:54:20: Query returned no tuples QUERY : 18:54:20: Scalar query (server:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 1442582543::oid AND defaclobjtype='r' INFO : 18:54:20: Query returned no tuples QUERY : 18:54:20: Scalar query (server:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 1442582543::oid AND defaclobjtype='S' INFO : 18:54:20: Query returned no tuples QUERY : 18:54:20: Scalar query (server:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 1442582543::oid AND defaclobjtype='f' INFO : 18:54:20: Query returned no tuples QUERY : 18:54:20: Scalar query (server:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 1442582543::oid AND defaclobjtype='T' INFO : 18:54:20: Query returned no tuples QUERY : 18:54:20: Scalar query (server:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 24151::oid AND defaclobjtype='r' INFO : 18:54:20: Query returned no tuples QUERY : 18:54:20: Scalar query (server:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 24151::oid AND defaclobjtype='S' INFO : 18:54:20: Query returned no tuples QUERY : 18:54:20: Scalar query (server:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 24151::oid AND defaclobjtype='f' INFO : 18:54:20: Query returned no tuples QUERY : 18:54:20: Scalar query (server:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 24151::oid AND defaclobjtype='T' INFO : 18:54:20: Query returned no tuples QUERY : 18:54:20: Set query (server:5432): SELECT nsp.oid, substr(nspname, 2) as clustername, nspname, pg_get_userbyid(nspowner) AS namespaceowner, description FROM pg_namespace nsp LEFT OUTER JOIN pg_description des ON des.objoid=nsp.oid JOIN pg_proc pro ON pronamespace=nsp.oid AND proname = 'slonyversion' ORDER BY nspname QUERY : 18:54:20: Scalar query (server:5432): SELECT COUNT(*) FROM (SELECT tgargs from pg_trigger tr LEFT JOIN pg_depend dep ON dep.objid=tr.oid AND deptype = 'i' LEFT JOIN pg_constraint co ON refobjid = co.oid AND contype = 'f' WHERE tgisinternal AND co.oid IS NULL GROUP BY tgargs HAVING count(1) = 3) AS foo QUERY : 18:54:20: Query result: 0 QUERY : 18:54:20: Set query (server:5432): WITH configs AS (SELECT rolname, unnest(setconfig) AS config FROM pg_db_role_setting s LEFT JOIN pg_roles r ON r.oid=s.setrole WHERE s.setdatabase=24324) SELECT rolname, split_part(config, '=', 1) AS variable, replace(config, split_part(config, '=', 1) || '=', '') AS value FROM configs QUERY : 18:54:20: Set query (server:5432): 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') QUERY : 18:54:20: Scalar query (server:5432): SELECT count(*) FROM pg_attribute WHERE attrelid = 'pg_catalog.pg_proc'::regclass AND attname = 'proargdefaults' QUERY : 18:54:20: Query result: 1 INFO : 18:54:20: Displaying properties for Database planet2 STATUS : 18:54:20: Vorherige Umgebung wiederherstellen... (131 msec) INFO : 18:54:39: Displaying properties for Servers Servers STATUS : 18:54:39: Hole Details zu Servern... STATUS : 18:54:39: Hole Details zu Servern... (4 msec) INFO : 18:54:40: Displaying properties for Database planet2 STATUS : 18:54:40: Hole Details zur Datenbank planet2... STATUS : 18:54:41: Hole Details zur Datenbank planet2... (7 msec) INFO : 18:54:44: Opening connection with connection string: host='server' dbname='planet2' user='postgres' port=5432 application_name='pgAdmin III- Server-Status' QUERY : 18:54:44: Scalar query (server:5432): SELECT version(); QUERY : 18:54:44: Query result: PostgreSQL 9.4.6 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu 4.8.2-19ubuntu1) 4.8.2, 64-bit QUERY : 18:54:44: Set query (server:5432): SET DateStyle=ISO; SET client_min_messages=notice; SET bytea_output=escape; SELECT oid, pg_encoding_to_char(encoding) AS encoding, datlastsysoid FROM pg_database WHERE oid = 24324 INFO : 18:54:44: Setting client_encoding to 'UNICODE' QUERY : 18:54:44: Set query (server:5432): SELECT datname FROM pg_database WHERE datallowconn ORDER BY datname QUERY : 18:54:44: Set query (server:5432): 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') QUERY : 18:54:44: Scalar query (server:5432): SELECT count(*) FROM pg_attribute WHERE attrelid = 'pg_catalog.pg_proc'::regclass AND attname = 'proargdefaults' QUERY : 18:54:44: Query result: 1 QUERY : 18:54:44: Scalar query (server:5432): SHOW log_line_prefix QUERY : 18:54:44: Query result: %t QUERY : 18:54:44: Set query (server:5432): SELECT p.pid AS pid, application_name, datname, usename, CASE WHEN client_port=-1 THEN 'local pipe' WHEN length(client_hostname)>0 THEN client_hostname||':'||client_port ELSE textin(inet_out(client_addr))||':'||client_port END AS client, date_trunc('second', backend_start) AS backend_start, CASE WHEN state='active' THEN date_trunc('second', query_start)::text ELSE '' END AS query_start, date_trunc('second', xact_start) AS xact_start, state, date_trunc('second', state_change) AS state_change, backend_xid::text, backend_xmin::text, (SELECT min(l1.pid) FROM pg_locks l1 WHERE GRANTED AND (relation IN (SELECT relation FROM pg_locks l2 WHERE l2.pid=p.pid AND NOT granted) OR transactionid IN (SELECT transactionid FROM pg_locks l3 WHERE l3.pid=p.pid AND NOT granted))) AS blockedby, query AS query, CASE WHEN query_start IS NULL OR state<>'active' THEN false ELSE query_start < now() - '10 seconds'::interval END AS slowquery FROM pg_stat_activity p ORDER BY 1 ASC QUERY : 18:54:44: Set query (server:5432): SELECT pg_stat_get_backend_pid(svrid) AS pid, (SELECT datname FROM pg_database WHERE oid = pgl.database) AS dbname, coalesce(pgc.relname, pgl.relation::text) AS class, pg_get_userbyid(pg_stat_get_backend_userid(svrid)) as user, pgl.virtualxid::text, pgl.virtualtransaction::text AS transaction, pgl.mode, pgl.granted, date_trunc('second', pg_stat_get_backend_activity_start(svrid)) AS query_start, pg_stat_get_backend_activity(svrid) AS query FROM pg_stat_get_backend_idset() svrid, pg_locks pgl LEFT JOIN pg_class pgc ON pgl.relation=pgc.oid WHERE pgl.pid = pg_stat_get_backend_pid(svrid) ORDER BY 1 ASC QUERY : 18:54:45: Set query (server:5432): SELECT transaction::text, gid, prepared, owner, database FROM pg_prepared_xacts ORDER BY 2 ASC QUERY : 18:54:45: Scalar query (server:5432): SHOW log_directory QUERY : 18:54:45: Query result: pg_log QUERY : 18:54:45: Set query (server:5432): SELECT filename, filetime FROM pg_logdir_ls() AS A(filetime timestamp, filename text) ORDER BY filetime DESC QUERY : 18:54:45: Set query (server:5432): SELECT filetime, filename, pg_file_length(filename) AS len FROM pg_logdir_ls() AS A(filetime timestamp, filename text) WHERE filetime = '2016-11-09 00:00:00'::timestamp QUERY : 18:54:45: Set query (server:5432): SELECT pg_file_read('pg_log/postgresql-2016-11-09_000000.log', 0, 50000) QUERY : 18:54:45: Set query (server:5432): SELECT pg_file_read('pg_log/postgresql-2016-11-09_000000.log', 50000, 50000) QUERY : 18:54:45: Set query (server:5432): SELECT pg_file_read('pg_log/postgresql-2016-11-09_000000.log', 100000, 50000) QUERY : 18:54:45: Set query (server:5432): SELECT pg_file_read('pg_log/postgresql-2016-11-09_000000.log', 150000, 50000) QUERY : 18:54:45: Set query (server:5432): SELECT p.pid AS pid, application_name, datname, usename, CASE WHEN client_port=-1 THEN 'local pipe' WHEN length(client_hostname)>0 THEN client_hostname||':'||client_port ELSE textin(inet_out(client_addr))||':'||client_port END AS client, date_trunc('second', backend_start) AS backend_start, CASE WHEN state='active' THEN date_trunc('second', query_start)::text ELSE '' END AS query_start, date_trunc('second', xact_start) AS xact_start, state, date_trunc('second', state_change) AS state_change, backend_xid::text, backend_xmin::text, (SELECT min(l1.pid) FROM pg_locks l1 WHERE GRANTED AND (relation IN (SELECT relation FROM pg_locks l2 WHERE l2.pid=p.pid AND NOT granted) OR transactionid IN (SELECT transactionid FROM pg_locks l3 WHERE l3.pid=p.pid AND NOT granted))) AS blockedby, query AS query, CASE WHEN query_start IS NULL OR state<>'active' THEN false ELSE query_start < now() - '10 seconds'::interval END AS slowquery FROM pg_stat_activity p ORDER BY 1 ASC QUERY : 18:54:45: Set query (server:5432): SELECT pg_stat_get_backend_pid(svrid) AS pid, (SELECT datname FROM pg_database WHERE oid = pgl.database) AS dbname, coalesce(pgc.relname, pgl.relation::text) AS class, pg_get_userbyid(pg_stat_get_backend_userid(svrid)) as user, pgl.virtualxid::text, pgl.virtualtransaction::text AS transaction, pgl.mode, pgl.granted, date_trunc('second', pg_stat_get_backend_activity_start(svrid)) AS query_start, pg_stat_get_backend_activity(svrid) AS query FROM pg_stat_get_backend_idset() svrid, pg_locks pgl LEFT JOIN pg_class pgc ON pgl.relation=pgc.oid WHERE pgl.pid = pg_stat_get_backend_pid(svrid) ORDER BY 1 ASC QUERY : 18:54:45: Set query (server:5432): SELECT transaction::text, gid, prepared, owner, database FROM pg_prepared_xacts ORDER BY 2 ASC QUERY : 18:54:45: Set query (server:5432): SELECT pg_file_length('pg_log/postgresql-2016-11-09_000000.log') AS len QUERY : 18:54:45: Scalar query (server:5432): SHOW log_directory QUERY : 18:54:45: Query result: pg_log QUERY : 18:54:45: Set query (server:5432): SELECT filename, filetime FROM pg_logdir_ls() AS A(filetime timestamp, filename text) ORDER BY filetime DESC QUERY : 18:54:45: Set query (server:5432): SELECT p.pid AS pid, application_name, datname, usename, CASE WHEN client_port=-1 THEN 'local pipe' WHEN length(client_hostname)>0 THEN client_hostname||':'||client_port ELSE textin(inet_out(client_addr))||':'||client_port END AS client, date_trunc('second', backend_start) AS backend_start, CASE WHEN state='active' THEN date_trunc('second', query_start)::text ELSE '' END AS query_start, date_trunc('second', xact_start) AS xact_start, state, date_trunc('second', state_change) AS state_change, backend_xid::text, backend_xmin::text, (SELECT min(l1.pid) FROM pg_locks l1 WHERE GRANTED AND (relation IN (SELECT relation FROM pg_locks l2 WHERE l2.pid=p.pid AND NOT granted) OR transactionid IN (SELECT transactionid FROM pg_locks l3 WHERE l3.pid=p.pid AND NOT granted))) AS blockedby, query AS query, CASE WHEN query_start IS NULL OR state<>'active' THEN false ELSE query_start < now() - '10 seconds'::interval END AS slowquery FROM pg_stat_activity p ORDER BY 1 ASC QUERY : 18:54:45: Set query (server:5432): SELECT pg_stat_get_backend_pid(svrid) AS pid, (SELECT datname FROM pg_database WHERE oid = pgl.database) AS dbname, coalesce(pgc.relname, pgl.relation::text) AS class, pg_get_userbyid(pg_stat_get_backend_userid(svrid)) as user, pgl.virtualxid::text, pgl.virtualtransaction::text AS transaction, pgl.mode, pgl.granted, date_trunc('second', pg_stat_get_backend_activity_start(svrid)) AS query_start, pg_stat_get_backend_activity(svrid) AS query FROM pg_stat_get_backend_idset() svrid, pg_locks pgl LEFT JOIN pg_class pgc ON pgl.relation=pgc.oid WHERE pgl.pid = pg_stat_get_backend_pid(svrid) ORDER BY 1 ASC QUERY : 18:54:45: Set query (server:5432): SELECT transaction::text, gid, prepared, owner, database FROM pg_prepared_xacts ORDER BY 2 ASC QUERY : 18:54:45: Set query (server:5432): SELECT pg_file_length('pg_log/postgresql-2016-11-09_000000.log') AS len QUERY : 18:54:45: Scalar query (server:5432): SHOW log_directory QUERY : 18:54:45: Query result: pg_log QUERY : 18:54:45: Set query (server:5432): SELECT filename, filetime FROM pg_logdir_ls() AS A(filetime timestamp, filename text) ORDER BY filetime DESC QUERY : 18:54:45: Set query (server:5432): SELECT p.pid AS pid, application_name, datname, usename, CASE WHEN client_port=-1 THEN 'local pipe' WHEN length(client_hostname)>0 THEN client_hostname||':'||client_port ELSE textin(inet_out(client_addr))||':'||client_port END AS client, date_trunc('second', backend_start) AS backend_start, CASE WHEN state='active' THEN date_trunc('second', query_start)::text ELSE '' END AS query_start, date_trunc('second', xact_start) AS xact_start, state, date_trunc('second', state_change) AS state_change, backend_xid::text, backend_xmin::text, (SELECT min(l1.pid) FROM pg_locks l1 WHERE GRANTED AND (relation IN (SELECT relation FROM pg_locks l2 WHERE l2.pid=p.pid AND NOT granted) OR transactionid IN (SELECT transactionid FROM pg_locks l3 WHERE l3.pid=p.pid AND NOT granted))) AS blockedby, query AS query, CASE WHEN query_start IS NULL OR state<>'active' THEN false ELSE query_start < now() - '10 seconds'::interval END AS slowquery FROM pg_stat_activity p ORDER BY 1 ASC QUERY : 18:54:45: Set query (server:5432): SELECT pg_stat_get_backend_pid(svrid) AS pid, (SELECT datname FROM pg_database WHERE oid = pgl.database) AS dbname, coalesce(pgc.relname, pgl.relation::text) AS class, pg_get_userbyid(pg_stat_get_backend_userid(svrid)) as user, pgl.virtualxid::text, pgl.virtualtransaction::text AS transaction, pgl.mode, pgl.granted, date_trunc('second', pg_stat_get_backend_activity_start(svrid)) AS query_start, pg_stat_get_backend_activity(svrid) AS query FROM pg_stat_get_backend_idset() svrid, pg_locks pgl LEFT JOIN pg_class pgc ON pgl.relation=pgc.oid WHERE pgl.pid = pg_stat_get_backend_pid(svrid) ORDER BY 1 ASC QUERY : 18:54:45: Set query (server:5432): SELECT transaction::text, gid, prepared, owner, database FROM pg_prepared_xacts ORDER BY 2 ASC QUERY : 18:54:45: Set query (server:5432): SELECT pg_file_length('pg_log/postgresql-2016-11-09_000000.log') AS len QUERY : 18:54:45: Scalar query (server:5432): SHOW log_directory QUERY : 18:54:45: Query result: pg_log QUERY : 18:54:45: Set query (server:5432): SELECT filename, filetime FROM pg_logdir_ls() AS A(filetime timestamp, filename text) ORDER BY filetime DESC QUERY : 18:54:45: Set query (server:5432): SELECT p.pid AS pid, application_name, datname, usename, CASE WHEN client_port=-1 THEN 'local pipe' WHEN length(client_hostname)>0 THEN client_hostname||':'||client_port ELSE textin(inet_out(client_addr))||':'||client_port END AS client, date_trunc('second', backend_start) AS backend_start, CASE WHEN state='active' THEN date_trunc('second', query_start)::text ELSE '' END AS query_start, date_trunc('second', xact_start) AS xact_start, state, date_trunc('second', state_change) AS state_change, backend_xid::text, backend_xmin::text, (SELECT min(l1.pid) FROM pg_locks l1 WHERE GRANTED AND (relation IN (SELECT relation FROM pg_locks l2 WHERE l2.pid=p.pid AND NOT granted) OR transactionid IN (SELECT transactionid FROM pg_locks l3 WHERE l3.pid=p.pid AND NOT granted))) AS blockedby, query AS query, CASE WHEN query_start IS NULL OR state<>'active' THEN false ELSE query_start < now() - '10 seconds'::interval END AS slowquery FROM pg_stat_activity p ORDER BY 1 ASC QUERY : 18:54:45: Set query (server:5432): SELECT pg_stat_get_backend_pid(svrid) AS pid, (SELECT datname FROM pg_database WHERE oid = pgl.database) AS dbname, coalesce(pgc.relname, pgl.relation::text) AS class, pg_get_userbyid(pg_stat_get_backend_userid(svrid)) as user, pgl.virtualxid::text, pgl.virtualtransaction::text AS transaction, pgl.mode, pgl.granted, date_trunc('second', pg_stat_get_backend_activity_start(svrid)) AS query_start, pg_stat_get_backend_activity(svrid) AS query FROM pg_stat_get_backend_idset() svrid, pg_locks pgl LEFT JOIN pg_class pgc ON pgl.relation=pgc.oid WHERE pgl.pid = pg_stat_get_backend_pid(svrid) ORDER BY 1 ASC QUERY : 18:54:45: Set query (server:5432): SELECT transaction::text, gid, prepared, owner, database FROM pg_prepared_xacts ORDER BY 2 ASC QUERY : 18:54:45: Set query (server:5432): SELECT pg_file_length('pg_log/postgresql-2016-11-09_000000.log') AS len QUERY : 18:54:45: Scalar query (server:5432): SHOW log_directory QUERY : 18:54:45: Query result: pg_log QUERY : 18:54:45: Set query (server:5432): SELECT filename, filetime FROM pg_logdir_ls() AS A(filetime timestamp, filename text) ORDER BY filetime DESC QUERY : 18:54:54: Set query (server:5432): SELECT p.pid AS pid, application_name, datname, usename, CASE WHEN client_port=-1 THEN 'local pipe' WHEN length(client_hostname)>0 THEN client_hostname||':'||client_port ELSE textin(inet_out(client_addr))||':'||client_port END AS client, date_trunc('second', backend_start) AS backend_start, CASE WHEN state='active' THEN date_trunc('second', query_start)::text ELSE '' END AS query_start, date_trunc('second', xact_start) AS xact_start, state, date_trunc('second', state_change) AS state_change, backend_xid::text, backend_xmin::text, (SELECT min(l1.pid) FROM pg_locks l1 WHERE GRANTED AND (relation IN (SELECT relation FROM pg_locks l2 WHERE l2.pid=p.pid AND NOT granted) OR transactionid IN (SELECT transactionid FROM pg_locks l3 WHERE l3.pid=p.pid AND NOT granted))) AS blockedby, query AS query, CASE WHEN query_start IS NULL OR state<>'active' THEN false ELSE query_start < now() - '10 seconds'::interval END AS slowquery FROM pg_stat_activity p ORDER BY 1 ASC QUERY : 18:54:55: Set query (server:5432): SELECT pg_stat_get_backend_pid(svrid) AS pid, (SELECT datname FROM pg_database WHERE oid = pgl.database) AS dbname, coalesce(pgc.relname, pgl.relation::text) AS class, pg_get_userbyid(pg_stat_get_backend_userid(svrid)) as user, pgl.virtualxid::text, pgl.virtualtransaction::text AS transaction, pgl.mode, pgl.granted, date_trunc('second', pg_stat_get_backend_activity_start(svrid)) AS query_start, pg_stat_get_backend_activity(svrid) AS query FROM pg_stat_get_backend_idset() svrid, pg_locks pgl LEFT JOIN pg_class pgc ON pgl.relation=pgc.oid WHERE pgl.pid = pg_stat_get_backend_pid(svrid) ORDER BY 1 ASC QUERY : 18:54:55: Set query (server:5432): SELECT transaction::text, gid, prepared, owner, database FROM pg_prepared_xacts ORDER BY 2 ASC QUERY : 18:54:55: Set query (server:5432): SELECT pg_file_length('pg_log/postgresql-2016-11-09_000000.log') AS len QUERY : 18:54:55: Scalar query (server:5432): SHOW log_directory QUERY : 18:54:55: Query result: pg_log QUERY : 18:54:55: Set query (server:5432): SELECT filename, filetime FROM pg_logdir_ls() AS A(filetime timestamp, filename text) ORDER BY filetime DESC QUERY : 18:55:04: Set query (server:5432): SELECT p.pid AS pid, application_name, datname, usename, CASE WHEN client_port=-1 THEN 'local pipe' WHEN length(client_hostname)>0 THEN client_hostname||':'||client_port ELSE textin(inet_out(client_addr))||':'||client_port END AS client, date_trunc('second', backend_start) AS backend_start, CASE WHEN state='active' THEN date_trunc('second', query_start)::text ELSE '' END AS query_start, date_trunc('second', xact_start) AS xact_start, state, date_trunc('second', state_change) AS state_change, backend_xid::text, backend_xmin::text, (SELECT min(l1.pid) FROM pg_locks l1 WHERE GRANTED AND (relation IN (SELECT relation FROM pg_locks l2 WHERE l2.pid=p.pid AND NOT granted) OR transactionid IN (SELECT transactionid FROM pg_locks l3 WHERE l3.pid=p.pid AND NOT granted))) AS blockedby, query AS query, CASE WHEN query_start IS NULL OR state<>'active' THEN false ELSE query_start < now() - '10 seconds'::interval END AS slowquery FROM pg_stat_activity p ORDER BY 1 ASC QUERY : 18:55:05: Set query (server:5432): SELECT pg_stat_get_backend_pid(svrid) AS pid, (SELECT datname FROM pg_database WHERE oid = pgl.database) AS dbname, coalesce(pgc.relname, pgl.relation::text) AS class, pg_get_userbyid(pg_stat_get_backend_userid(svrid)) as user, pgl.virtualxid::text, pgl.virtualtransaction::text AS transaction, pgl.mode, pgl.granted, date_trunc('second', pg_stat_get_backend_activity_start(svrid)) AS query_start, pg_stat_get_backend_activity(svrid) AS query FROM pg_stat_get_backend_idset() svrid, pg_locks pgl LEFT JOIN pg_class pgc ON pgl.relation=pgc.oid WHERE pgl.pid = pg_stat_get_backend_pid(svrid) ORDER BY 1 ASC QUERY : 18:55:05: Set query (server:5432): SELECT transaction::text, gid, prepared, owner, database FROM pg_prepared_xacts ORDER BY 2 ASC QUERY : 18:55:05: Set query (server:5432): SELECT pg_file_length('pg_log/postgresql-2016-11-09_000000.log') AS len QUERY : 18:55:05: Scalar query (server:5432): SHOW log_directory QUERY : 18:55:05: Query result: pg_log QUERY : 18:55:05: Set query (server:5432): SELECT filename, filetime FROM pg_logdir_ls() AS A(filetime timestamp, filename text) ORDER BY filetime DESC QUERY : 18:55:14: Set query (server:5432): SELECT p.pid AS pid, application_name, datname, usename, CASE WHEN client_port=-1 THEN 'local pipe' WHEN length(client_hostname)>0 THEN client_hostname||':'||client_port ELSE textin(inet_out(client_addr))||':'||client_port END AS client, date_trunc('second', backend_start) AS backend_start, CASE WHEN state='active' THEN date_trunc('second', query_start)::text ELSE '' END AS query_start, date_trunc('second', xact_start) AS xact_start, state, date_trunc('second', state_change) AS state_change, backend_xid::text, backend_xmin::text, (SELECT min(l1.pid) FROM pg_locks l1 WHERE GRANTED AND (relation IN (SELECT relation FROM pg_locks l2 WHERE l2.pid=p.pid AND NOT granted) OR transactionid IN (SELECT transactionid FROM pg_locks l3 WHERE l3.pid=p.pid AND NOT granted))) AS blockedby, query AS query, CASE WHEN query_start IS NULL OR state<>'active' THEN false ELSE query_start < now() - '10 seconds'::interval END AS slowquery FROM pg_stat_activity p ORDER BY 1 ASC QUERY : 18:55:15: Set query (server:5432): SELECT pg_stat_get_backend_pid(svrid) AS pid, (SELECT datname FROM pg_database WHERE oid = pgl.database) AS dbname, coalesce(pgc.relname, pgl.relation::text) AS class, pg_get_userbyid(pg_stat_get_backend_userid(svrid)) as user, pgl.virtualxid::text, pgl.virtualtransaction::text AS transaction, pgl.mode, pgl.granted, date_trunc('second', pg_stat_get_backend_activity_start(svrid)) AS query_start, pg_stat_get_backend_activity(svrid) AS query FROM pg_stat_get_backend_idset() svrid, pg_locks pgl LEFT JOIN pg_class pgc ON pgl.relation=pgc.oid WHERE pgl.pid = pg_stat_get_backend_pid(svrid) ORDER BY 1 ASC QUERY : 18:55:15: Set query (server:5432): SELECT transaction::text, gid, prepared, owner, database FROM pg_prepared_xacts ORDER BY 2 ASC QUERY : 18:55:15: Set query (server:5432): SELECT pg_file_length('pg_log/postgresql-2016-11-09_000000.log') AS len QUERY : 18:55:15: Scalar query (server:5432): SHOW log_directory QUERY : 18:55:15: Query result: pg_log QUERY : 18:55:15: Set query (server:5432): SELECT filename, filetime FROM pg_logdir_ls() AS A(filetime timestamp, filename text) ORDER BY filetime DESC QUERY : 18:55:24: Set query (server:5432): SELECT p.pid AS pid, application_name, datname, usename, CASE WHEN client_port=-1 THEN 'local pipe' WHEN length(client_hostname)>0 THEN client_hostname||':'||client_port ELSE textin(inet_out(client_addr))||':'||client_port END AS client, date_trunc('second', backend_start) AS backend_start, CASE WHEN state='active' THEN date_trunc('second', query_start)::text ELSE '' END AS query_start, date_trunc('second', xact_start) AS xact_start, state, date_trunc('second', state_change) AS state_change, backend_xid::text, backend_xmin::text, (SELECT min(l1.pid) FROM pg_locks l1 WHERE GRANTED AND (relation IN (SELECT relation FROM pg_locks l2 WHERE l2.pid=p.pid AND NOT granted) OR transactionid IN (SELECT transactionid FROM pg_locks l3 WHERE l3.pid=p.pid AND NOT granted))) AS blockedby, query AS query, CASE WHEN query_start IS NULL OR state<>'active' THEN false ELSE query_start < now() - '10 seconds'::interval END AS slowquery FROM pg_stat_activity p ORDER BY 1 ASC QUERY : 18:55:25: Set query (server:5432): SELECT pg_stat_get_backend_pid(svrid) AS pid, (SELECT datname FROM pg_database WHERE oid = pgl.database) AS dbname, coalesce(pgc.relname, pgl.relation::text) AS class, pg_get_userbyid(pg_stat_get_backend_userid(svrid)) as user, pgl.virtualxid::text, pgl.virtualtransaction::text AS transaction, pgl.mode, pgl.granted, date_trunc('second', pg_stat_get_backend_activity_start(svrid)) AS query_start, pg_stat_get_backend_activity(svrid) AS query FROM pg_stat_get_backend_idset() svrid, pg_locks pgl LEFT JOIN pg_class pgc ON pgl.relation=pgc.oid WHERE pgl.pid = pg_stat_get_backend_pid(svrid) ORDER BY 1 ASC QUERY : 18:55:25: Set query (server:5432): SELECT transaction::text, gid, prepared, owner, database FROM pg_prepared_xacts ORDER BY 2 ASC QUERY : 18:55:25: Set query (server:5432): SELECT pg_file_length('pg_log/postgresql-2016-11-09_000000.log') AS len QUERY : 18:55:25: Scalar query (server:5432): SHOW log_directory QUERY : 18:55:25: Query result: pg_log QUERY : 18:55:25: Set query (server:5432): SELECT filename, filetime FROM pg_logdir_ls() AS A(filetime timestamp, filename text) ORDER BY filetime DESC QUERY : 18:55:34: Set query (server:5432): SELECT p.pid AS pid, application_name, datname, usename, CASE WHEN client_port=-1 THEN 'local pipe' WHEN length(client_hostname)>0 THEN client_hostname||':'||client_port ELSE textin(inet_out(client_addr))||':'||client_port END AS client, date_trunc('second', backend_start) AS backend_start, CASE WHEN state='active' THEN date_trunc('second', query_start)::text ELSE '' END AS query_start, date_trunc('second', xact_start) AS xact_start, state, date_trunc('second', state_change) AS state_change, backend_xid::text, backend_xmin::text, (SELECT min(l1.pid) FROM pg_locks l1 WHERE GRANTED AND (relation IN (SELECT relation FROM pg_locks l2 WHERE l2.pid=p.pid AND NOT granted) OR transactionid IN (SELECT transactionid FROM pg_locks l3 WHERE l3.pid=p.pid AND NOT granted))) AS blockedby, query AS query, CASE WHEN query_start IS NULL OR state<>'active' THEN false ELSE query_start < now() - '10 seconds'::interval END AS slowquery FROM pg_stat_activity p ORDER BY 1 ASC QUERY : 18:55:35: Set query (server:5432): SELECT pg_stat_get_backend_pid(svrid) AS pid, (SELECT datname FROM pg_database WHERE oid = pgl.database) AS dbname, coalesce(pgc.relname, pgl.relation::text) AS class, pg_get_userbyid(pg_stat_get_backend_userid(svrid)) as user, pgl.virtualxid::text, pgl.virtualtransaction::text AS transaction, pgl.mode, pgl.granted, date_trunc('second', pg_stat_get_backend_activity_start(svrid)) AS query_start, pg_stat_get_backend_activity(svrid) AS query FROM pg_stat_get_backend_idset() svrid, pg_locks pgl LEFT JOIN pg_class pgc ON pgl.relation=pgc.oid WHERE pgl.pid = pg_stat_get_backend_pid(svrid) ORDER BY 1 ASC QUERY : 18:55:35: Set query (server:5432): SELECT transaction::text, gid, prepared, owner, database FROM pg_prepared_xacts ORDER BY 2 ASC QUERY : 18:55:35: Set query (server:5432): SELECT pg_file_length('pg_log/postgresql-2016-11-09_000000.log') AS len QUERY : 18:55:35: Scalar query (server:5432): SHOW log_directory QUERY : 18:55:35: Query result: pg_log QUERY : 18:55:35: Set query (server:5432): SELECT filename, filetime FROM pg_logdir_ls() AS A(filetime timestamp, filename text) ORDER BY filetime DESC QUERY : 18:55:44: Set query (server:5432): SELECT p.pid AS pid, application_name, datname, usename, CASE WHEN client_port=-1 THEN 'local pipe' WHEN length(client_hostname)>0 THEN client_hostname||':'||client_port ELSE textin(inet_out(client_addr))||':'||client_port END AS client, date_trunc('second', backend_start) AS backend_start, CASE WHEN state='active' THEN date_trunc('second', query_start)::text ELSE '' END AS query_start, date_trunc('second', xact_start) AS xact_start, state, date_trunc('second', state_change) AS state_change, backend_xid::text, backend_xmin::text, (SELECT min(l1.pid) FROM pg_locks l1 WHERE GRANTED AND (relation IN (SELECT relation FROM pg_locks l2 WHERE l2.pid=p.pid AND NOT granted) OR transactionid IN (SELECT transactionid FROM pg_locks l3 WHERE l3.pid=p.pid AND NOT granted))) AS blockedby, query AS query, CASE WHEN query_start IS NULL OR state<>'active' THEN false ELSE query_start < now() - '10 seconds'::interval END AS slowquery FROM pg_stat_activity p ORDER BY 1 ASC QUERY : 18:55:45: Set query (server:5432): SELECT pg_stat_get_backend_pid(svrid) AS pid, (SELECT datname FROM pg_database WHERE oid = pgl.database) AS dbname, coalesce(pgc.relname, pgl.relation::text) AS class, pg_get_userbyid(pg_stat_get_backend_userid(svrid)) as user, pgl.virtualxid::text, pgl.virtualtransaction::text AS transaction, pgl.mode, pgl.granted, date_trunc('second', pg_stat_get_backend_activity_start(svrid)) AS query_start, pg_stat_get_backend_activity(svrid) AS query FROM pg_stat_get_backend_idset() svrid, pg_locks pgl LEFT JOIN pg_class pgc ON pgl.relation=pgc.oid WHERE pgl.pid = pg_stat_get_backend_pid(svrid) ORDER BY 1 ASC QUERY : 18:55:45: Set query (server:5432): SELECT transaction::text, gid, prepared, owner, database FROM pg_prepared_xacts ORDER BY 2 ASC QUERY : 18:55:45: Set query (server:5432): SELECT pg_file_length('pg_log/postgresql-2016-11-09_000000.log') AS len QUERY : 18:55:45: Scalar query (server:5432): SHOW log_directory QUERY : 18:55:45: Query result: pg_log QUERY : 18:55:45: Set query (server:5432): SELECT filename, filetime FROM pg_logdir_ls() AS A(filetime timestamp, filename text) ORDER BY filetime DESC QUERY : 18:55:54: Set query (server:5432): SELECT p.pid AS pid, application_name, datname, usename, CASE WHEN client_port=-1 THEN 'local pipe' WHEN length(client_hostname)>0 THEN client_hostname||':'||client_port ELSE textin(inet_out(client_addr))||':'||client_port END AS client, date_trunc('second', backend_start) AS backend_start, CASE WHEN state='active' THEN date_trunc('second', query_start)::text ELSE '' END AS query_start, date_trunc('second', xact_start) AS xact_start, state, date_trunc('second', state_change) AS state_change, backend_xid::text, backend_xmin::text, (SELECT min(l1.pid) FROM pg_locks l1 WHERE GRANTED AND (relation IN (SELECT relation FROM pg_locks l2 WHERE l2.pid=p.pid AND NOT granted) OR transactionid IN (SELECT transactionid FROM pg_locks l3 WHERE l3.pid=p.pid AND NOT granted))) AS blockedby, query AS query, CASE WHEN query_start IS NULL OR state<>'active' THEN false ELSE query_start < now() - '10 seconds'::interval END AS slowquery FROM pg_stat_activity p ORDER BY 1 ASC QUERY : 18:55:55: Set query (server:5432): SELECT pg_stat_get_backend_pid(svrid) AS pid, (SELECT datname FROM pg_database WHERE oid = pgl.database) AS dbname, coalesce(pgc.relname, pgl.relation::text) AS class, pg_get_userbyid(pg_stat_get_backend_userid(svrid)) as user, pgl.virtualxid::text, pgl.virtualtransaction::text AS transaction, pgl.mode, pgl.granted, date_trunc('second', pg_stat_get_backend_activity_start(svrid)) AS query_start, pg_stat_get_backend_activity(svrid) AS query FROM pg_stat_get_backend_idset() svrid, pg_locks pgl LEFT JOIN pg_class pgc ON pgl.relation=pgc.oid WHERE pgl.pid = pg_stat_get_backend_pid(svrid) ORDER BY 1 ASC QUERY : 18:55:55: Set query (server:5432): SELECT transaction::text, gid, prepared, owner, database FROM pg_prepared_xacts ORDER BY 2 ASC QUERY : 18:55:55: Set query (server:5432): SELECT pg_file_length('pg_log/postgresql-2016-11-09_000000.log') AS len QUERY : 18:55:55: Scalar query (server:5432): SHOW log_directory QUERY : 18:55:55: Query result: pg_log QUERY : 18:55:55: Set query (server:5432): SELECT filename, filetime FROM pg_logdir_ls() AS A(filetime timestamp, filename text) ORDER BY filetime DESC QUERY : 18:56:04: Set query (server:5432): SELECT p.pid AS pid, application_name, datname, usename, CASE WHEN client_port=-1 THEN 'local pipe' WHEN length(client_hostname)>0 THEN client_hostname||':'||client_port ELSE textin(inet_out(client_addr))||':'||client_port END AS client, date_trunc('second', backend_start) AS backend_start, CASE WHEN state='active' THEN date_trunc('second', query_start)::text ELSE '' END AS query_start, date_trunc('second', xact_start) AS xact_start, state, date_trunc('second', state_change) AS state_change, backend_xid::text, backend_xmin::text, (SELECT min(l1.pid) FROM pg_locks l1 WHERE GRANTED AND (relation IN (SELECT relation FROM pg_locks l2 WHERE l2.pid=p.pid AND NOT granted) OR transactionid IN (SELECT transactionid FROM pg_locks l3 WHERE l3.pid=p.pid AND NOT granted))) AS blockedby, query AS query, CASE WHEN query_start IS NULL OR state<>'active' THEN false ELSE query_start < now() - '10 seconds'::interval END AS slowquery FROM pg_stat_activity p ORDER BY 1 ASC QUERY : 18:56:05: Set query (server:5432): SELECT pg_stat_get_backend_pid(svrid) AS pid, (SELECT datname FROM pg_database WHERE oid = pgl.database) AS dbname, coalesce(pgc.relname, pgl.relation::text) AS class, pg_get_userbyid(pg_stat_get_backend_userid(svrid)) as user, pgl.virtualxid::text, pgl.virtualtransaction::text AS transaction, pgl.mode, pgl.granted, date_trunc('second', pg_stat_get_backend_activity_start(svrid)) AS query_start, pg_stat_get_backend_activity(svrid) AS query FROM pg_stat_get_backend_idset() svrid, pg_locks pgl LEFT JOIN pg_class pgc ON pgl.relation=pgc.oid WHERE pgl.pid = pg_stat_get_backend_pid(svrid) ORDER BY 1 ASC QUERY : 18:56:05: Set query (server:5432): SELECT transaction::text, gid, prepared, owner, database FROM pg_prepared_xacts ORDER BY 2 ASC QUERY : 18:56:05: Set query (server:5432): SELECT pg_file_length('pg_log/postgresql-2016-11-09_000000.log') AS len QUERY : 18:56:05: Scalar query (server:5432): SHOW log_directory QUERY : 18:56:05: Query result: pg_log QUERY : 18:56:05: Set query (server:5432): SELECT filename, filetime FROM pg_logdir_ls() AS A(filetime timestamp, filename text) ORDER BY filetime DESC QUERY : 18:56:14: Set query (server:5432): SELECT p.pid AS pid, application_name, datname, usename, CASE WHEN client_port=-1 THEN 'local pipe' WHEN length(client_hostname)>0 THEN client_hostname||':'||client_port ELSE textin(inet_out(client_addr))||':'||client_port END AS client, date_trunc('second', backend_start) AS backend_start, CASE WHEN state='active' THEN date_trunc('second', query_start)::text ELSE '' END AS query_start, date_trunc('second', xact_start) AS xact_start, state, date_trunc('second', state_change) AS state_change, backend_xid::text, backend_xmin::text, (SELECT min(l1.pid) FROM pg_locks l1 WHERE GRANTED AND (relation IN (SELECT relation FROM pg_locks l2 WHERE l2.pid=p.pid AND NOT granted) OR transactionid IN (SELECT transactionid FROM pg_locks l3 WHERE l3.pid=p.pid AND NOT granted))) AS blockedby, query AS query, CASE WHEN query_start IS NULL OR state<>'active' THEN false ELSE query_start < now() - '10 seconds'::interval END AS slowquery FROM pg_stat_activity p ORDER BY 1 ASC QUERY : 18:56:15: Set query (server:5432): SELECT pg_stat_get_backend_pid(svrid) AS pid, (SELECT datname FROM pg_database WHERE oid = pgl.database) AS dbname, coalesce(pgc.relname, pgl.relation::text) AS class, pg_get_userbyid(pg_stat_get_backend_userid(svrid)) as user, pgl.virtualxid::text, pgl.virtualtransaction::text AS transaction, pgl.mode, pgl.granted, date_trunc('second', pg_stat_get_backend_activity_start(svrid)) AS query_start, pg_stat_get_backend_activity(svrid) AS query FROM pg_stat_get_backend_idset() svrid, pg_locks pgl LEFT JOIN pg_class pgc ON pgl.relation=pgc.oid WHERE pgl.pid = pg_stat_get_backend_pid(svrid) ORDER BY 1 ASC QUERY : 18:56:15: Set query (server:5432): SELECT transaction::text, gid, prepared, owner, database FROM pg_prepared_xacts ORDER BY 2 ASC QUERY : 18:56:15: Set query (server:5432): SELECT pg_file_length('pg_log/postgresql-2016-11-09_000000.log') AS len QUERY : 18:56:15: Scalar query (server:5432): SHOW log_directory QUERY : 18:56:15: Query result: pg_log QUERY : 18:56:15: Set query (server:5432): SELECT filename, filetime FROM pg_logdir_ls() AS A(filetime timestamp, filename text) ORDER BY filetime DESC INFO : 18:56:24: Storing listed servers for later... INFO : 18:56:24: Stored 1 servers.
-- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
