Re: Large number of rows in pg_type and slow gui (pgadmin) refresh - Mailing list pgadmin-support
| From | Robert Klaus |
|---|---|
| Subject | Re: Large number of rows in pg_type and slow gui (pgadmin) refresh |
| Date | |
| Msg-id | 003501cdecf4$47ae6800$d70b3800$@com Whole thread Raw |
| In response to | Large number of rows in pg_type and slow gui (pgadmin) refresh ("Robert Klaus" <rklaus@nexgenwireless.com>) |
| Responses |
Re: Large number of rows in pg_type and slow gui
(pgadmin) refresh
|
| List | pgadmin-support |
I omitted the schemas that have most of the database objects, but the calls to pg_type do not seem to exclude this schema(user_maps). If I have time I'll try to to figure out where in the system catalog that list the number of objects by schema. Not familiarwith this databases's system catalog yet. 2013-01-07 10:14:00 INFO : ############################################################## 2013-01-07 10:14:00 INFO : # pgAdmin III Version 1.16.1 Startup 2013-01-07 10:14:00 INFO : ############################################################## 2013-01-07 10:14:00 INFO : Compiled with dynamically linked SSL support 2013-01-07 10:14:00 INFO : Running a RELEASE build. 2013-01-07 10:14:00 INFO : i18n path : C:\Program Files (x86)\pgAdmin III\1.16\i18n 2013-01-07 10:14:00 INFO : UI path : 2013-01-07 10:14:00 INFO : Doc path : C:\Program Files (x86)\pgAdmin III\1.16\Docs 2013-01-07 10:14:00 INFO : Branding path : 2013-01-07 10:14:00 INFO : Plugins path : C:\Program Files (x86)\pgAdmin III\1.16\plugins.d 2013-01-07 10:14:00 INFO : Settings INI : C:\Program Files (x86)\pgAdmin III\1.16\settings.ini 2013-01-07 10:14:00 INFO : PG pg_dump : C:\Program Files\PostgreSQL\9.2\bin\pg_dump.exe 2013-01-07 10:14:00 INFO : PG pg_dumpall : C:\Program Files\PostgreSQL\9.2\bin\pg_dumpall.exe 2013-01-07 10:14:00 INFO : PG pg_restore : C:\Program Files\PostgreSQL\9.2\bin\pg_restore.exe 2013-01-07 10:14:00 INFO : EDB pg_dump : 2013-01-07 10:14:00 INFO : EDB pg_dumpall: 2013-01-07 10:14:00 INFO : EDB pg_restore: 2013-01-07 10:14:00 INFO : Greenplum pg_dump : 2013-01-07 10:14:00 INFO : Greenplum pg_dumpall: 2013-01-07 10:14:00 INFO : Greenplum pg_restore: 2013-01-07 10:14:00 INFO : Using embedded XRC data. 2013-01-07 10:14:00 INFO : PG Help : http://www.postgresql.org/docs/current/static/ 2013-01-07 10:14:00 INFO : EDB Help : http://www.enterprisedb.com/docs/en/current/server/ 2013-01-07 10:14:00 INFO : Greenplum Help: http://www.greenplum.com/docs/3300/ 2013-01-07 10:14:00 INFO : Slony Help : http://www.slony.info/documentation/ 2013-01-07 10:14:02 INFO : EDB libpq functions are not available. 2013-01-07 10:14:02 INFO : Using fontmetrics 6/13, 8 Point 2013-01-07 10:14:02 INFO : Native Description '0;-11;0;0;0;400;0;0;0;0;0;0;0;0;MS Shell Dlg 2' 2013-01-07 10:14:02 INFO : Draw size of 'M': w=9, h=13, descent 2, external lead 0. 2013-01-07 10:14:02 INFO : Draw size of 'g': w=7, h=13, descent 2, external lead 0. 2013-01-07 10:14:02 INFO : Draw size of 'Mg': w=15, h=13, descent 2, external lead 0. 2013-01-07 10:14:02 INFO : Loading plugin ini files from C:\Program Files (x86)\pgAdmin III\1.16\plugins.d 2013-01-07 10:14:02 INFO : Loading plugin utilities from C:\Program Files (x86)\pgAdmin III\1.16\plugins.d\plugins.ini 2013-01-07 10:14:02 INFO : Adding plugin utility: PSQL Console 2013-01-07 10:14:02 INFO : Command: "$$PGBINDIR\psql.exe" --host "$$HOSTNAME" --port $$PORT --username "$$USERNAME""$$DATABASE" 2013-01-07 10:14:02 INFO : Description: Open a PSQL console to the current database. 2013-01-07 10:14:02 INFO : Database?: Yes 2013-01-07 10:14:02 INFO : Set Password?: Yes 2013-01-07 10:14:02 INFO : Reloading servers... 2013-01-07 10:14:02 INFO : Loading previously registered servers 2013-01-07 10:14:02 INFO : Loading servers registered on the local machine 2013-01-07 10:14:02 INFO : Displaying properties for Servers Servers 2013-01-07 10:14:02 STATUS : Retrieving details on servers... 2013-01-07 10:14:02 STATUS : Retrieving details on servers... (0.00 secs) 2013-01-07 10:14:02 INFO : Displaying properties for Servers Servers 2013-01-07 10:14:02 STATUS : Retrieving details on servers... 2013-01-07 10:14:02 STATUS : Retrieving details on servers... (0.00 secs) 2013-01-07 10:14:04 INFO : Displaying properties for Server 10.4.0.121:5432 2013-01-07 10:14:04 STATUS : Retrieving details on server 10.4.0.121... 2013-01-07 10:14:04 STATUS : Retrieving details on server 10.4.0.121... (0.00 secs) 2013-01-07 10:14:04 INFO : Attempting to create a connection object... 2013-01-07 10:14:04 INFO : Using password file C:\Users\Klaus\AppData\Roaming\postgresql\pgpass.conf 2013-01-07 10:14:04 STATUS : Connecting to database... 2013-01-07 10:14:04 INFO : Opening connection with connection string: host='10.4.0.121' dbname='postgres' user='samsung'port=5432 sslcompression=0 application_name='pgAdmin III - Browser' 2013-01-07 10:14:04 QUERY : Scalar query (10.4.0.121:5432): SELECT version(); 2013-01-07 10:14:04 QUERY : Query result: PostgreSQL 8.4.9 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.620110731 (Red Hat 4.4.6-3), 64-bit 2013-01-07 10:14:04 QUERY : Set query (10.4.0.121:5432): SET DateStyle=ISO; SET client_min_messages=notice; SELECT oid, pg_encoding_to_char(encoding) AS encoding, datlastsysoid FROM pg_database WHERE datname='postgres' 2013-01-07 10:14:04 INFO : Setting client_encoding to 'UNICODE' 2013-01-07 10:14:04 QUERY : Set query (10.4.0.121: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 confloadedsinceFROM pg_user WHERE usename=current_user 2013-01-07 10:14:04 QUERY : Set query (10.4.0.121:5432): SELECT rolcreaterole, rolcreatedb FROM pg_roles WHERE rolname =current_user; 2013-01-07 10:14:04 STATUS : Connecting to database... (0.31 secs) 2013-01-07 10:14:04 STATUS : Restoring previous environment... 2013-01-07 10:14:04 INFO : pgServer object initialised as required. 2013-01-07 10:14:04 INFO : Adding child object to server 10.4.0.121:5432 2013-01-07 10:14:04 QUERY : Set query (10.4.0.121: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 FROM pg_database db LEFT OUTER JOINpg_tablespace ta ON db.dattablespace=ta.OID LEFT OUTER JOIN pg_shdescription descr ON db.oid=descr.objoidORDER BY datname 2013-01-07 10:14:04 QUERY : Set query (10.4.0.121:5432): SELECT ts.oid, spcname, spclocation, pg_get_userbyid(spcowner)as spcuser, spcacl, pg_catalog.shobj_description(oid, 'pg_tablespace') AS description FROM pg_tablespacetsORDER BY spcname 2013-01-07 10:14:04 QUERY : Scalar query (10.4.0.121:5432): SELECT cl.oid FROM pg_class cl JOIN pg_namespace ns ON ns.oid=relnamespaceWHERErelname='pga_job' AND nspname='pgagent' 2013-01-07 10:14:04 INFO : Query returned no tuples 2013-01-07 10:14:04 QUERY : Scalar query (10.4.0.121:5432): SELECT has_table_privilege('pg_authid', 'SELECT') 2013-01-07 10:14:04 QUERY : Query result: t 2013-01-07 10:14:04 QUERY : Set query (10.4.0.121:5432): SELECT oid, *, pg_catalog.shobj_description(oid, 'pg_authid') ASdescription FROM pg_authid WHERE NOT rolcanlogin ORDER BY rolname 2013-01-07 10:14:04 QUERY : Scalar query (10.4.0.121:5432): SELECT has_table_privilege('pg_authid', 'SELECT') 2013-01-07 10:14:04 QUERY : Query result: t 2013-01-07 10:14:05 QUERY : Set query (10.4.0.121:5432): SELECT oid, *, pg_catalog.shobj_description(oid, 'pg_authid') ASdescription FROM pg_authid WHERE rolcanlogin ORDER BY rolname 2013-01-07 10:14:05 QUERY : Set query (10.4.0.121:5432): SELECT setting FROM pg_settings WHERE name IN ('autovacuum', 'track_counts') 2013-01-07 10:14:05 INFO : Displaying properties for Databases Databases 2013-01-07 10:14:05 INFO : Displaying properties for Database sam_usa_gis 2013-01-07 10:14:05 INFO : Opening connection with connection string: host='10.4.0.121' dbname='sam_usa_gis' user='samsung'port=5432 sslcompression=0 application_name='pgAdmin III - Browser' 2013-01-07 10:14:05 QUERY : Scalar query (10.4.0.121:5432): SELECT version(); 2013-01-07 10:14:05 QUERY : Query result: PostgreSQL 8.4.9 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.620110731 (Red Hat 4.4.6-3), 64-bit 2013-01-07 10:14:05 QUERY : Set query (10.4.0.121:5432): SET DateStyle=ISO; SET client_min_messages=notice; SELECT oid, pg_encoding_to_char(encoding) AS encoding, datlastsysoid FROM pg_database WHERE oid = 553541 2013-01-07 10:14:05 INFO : Setting client_encoding to 'UNICODE' 2013-01-07 10:14:05 QUERY : Scalar query (10.4.0.121:5432): SELECT proname FROM pg_proc WHERE proname='pg_get_viewdef' ANDproargtypes[1]=16 2013-01-07 10:14:05 QUERY : Query result: pg_get_viewdef 2013-01-07 10:14:05 QUERY : Scalar query (10.4.0.121:5432): SHOW search_path 2013-01-07 10:14:05 QUERY : Query result: "$user",public,geo,dw 2013-01-07 10:14:05 QUERY : Set query (10.4.0.121:5432): SELECT nspname, session_user=nspname AS isuser FROM pg_namespace 2013-01-07 10:14:05 INFO : Adding child object to database sam_usa_gis 2013-01-07 10:14:05 QUERY : Set query (10.4.0.121: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 OUTERJOIN pg_description des ON des.objoid=nsp.oidWHERE ((nspname = 'pg_catalog' AND EXISTS (SELECT 1 FROM pg_class WHERErelname = '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 LIMIT1)) OR (nspname LIKE '_%' AND EXISTS (SELECT 1 FROM pg_proc WHERE proname='slonyversion' AND pronamespace = nsp.oid LIMIT 1)) ) AND nspname IN ('evdo','geo','lte','public','sm_om','toolkit','voice','information_schema','pg_catalog') ORDER BY 1, nspname 2013-01-07 10:14:05 QUERY : Set query (10.4.0.121:5432): SELECT ca.oid, ca.*, format_type(st.oid,NULL) AS srctyp, format_type(tt.oid,tt.typtypmod)AS trgtyp, ns.nspname AS srcnspname, nt.nspname AS trgnspname,proname, np.nspname AS pronspname,description FROM pg_cast ca JOIN pg_type st ON st.oid=castsource JOIN pg_namespace ns ON ns.oid=st.typnamespaceJOIN pg_type tt ON tt.oid=casttarget JOIN pg_namespace nt ON nt.oid=tt.typnamespace LEFT JOIN pg_procpr ON pr.oid=castfunc LEFT JOIN pg_namespace np ON np.oid=pr.pronamespace LEFT OUTER JOIN pg_description des ON des.objoid=ca.oidAND des.objsubid=0ORDER BY st.typname, tt.typname 2013-01-07 10:14:05 QUERY : Set query (10.4.0.121:5432): SELECT fdw.oid, fdwname, fdwvalidator, fdwacl, vp.proname as fdwval,description, array_to_string(fdwoptions, ',') AS fdwoptions, pg_get_userbyid(fdwowner) as fdwowner FROM pg_foreign_data_wrapperfdw LEFT OUTER JOIN pg_proc vp on vp.oid=fdwvalidator LEFT OUTER JOIN pg_description des ON des.objoid=fdw.oidAND des.objsubid=0 ORDER BY fdwname 2013-01-07 10:14:05 QUERY : Set query (10.4.0.121:5432): SELECT lan.oid, lanname, lanpltrusted, lanacl, hp.proname as lanproc,vp.proname as lanval, description, pg_get_userbyid(lan.lanowner) as languageowner FROM pg_language lan JOIN pg_prochp on hp.oid=lanplcallfoid LEFT OUTER JOIN pg_proc vp on vp.oid=lanvalidator LEFT OUTER JOIN pg_description des ONdes.objoid=lan.oid AND des.objsubid=0WHERE lanispl IS TRUEORDER BY lanname 2013-01-07 10:14:05 QUERY : Set query (10.4.0.121: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 cancreateFROM pg_namespace nsp LEFT OUTER JOIN pg_description des ON des.objoid=nsp.oidWHERE 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 LIMIT1)) OR (nspname LIKE '_%' AND EXISTS (SELECT 1 FROM pg_proc WHERE proname='slonyversion' AND pronamespace = nsp.oid LIMIT 1)) ) AND nspname IN ('evdo','geo','lte','public','sm_om','toolkit','voice','information_schema','pg_catalog') ORDER BY 1, nspname 2013-01-07 10:14:05 QUERY : Set query (10.4.0.121: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.oidJOIN pg_proc pro ON pronamespace=nsp.oid AND proname = 'slonyversion'ORDER BY nspname 2013-01-07 10:14:05 QUERY : Scalar query (10.4.0.121: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 tgisconstraint AND co.oid IS NULL GROUP BY tgargs HAVING count(1) = 3) AS foo 2013-01-07 10:14:06 QUERY : Query result: 0 2013-01-07 10:14:06 QUERY : Set query (10.4.0.121:5432): SELECT '' AS rolname, split_part(config, '=', 1) AS variable, replace(config,split_part(config, '=', 1) || '=', '') AS value FROM ( SELECT ( SELECT datconfig[i] FROM pg_database WHERE oid=553541 ) AS config FROM generate_series(array_lower((SELECTdatconfig FROM pg_database WHERE oid=553541),1), array_upper((SELECT datconfig FROM pg_databaseWHERE oid=553541),1)) AS i ) configs 2013-01-07 10:14:06 INFO : Displaying properties for Schemas Schemas 2013-01-07 10:14:06 INFO : Displaying properties for Schema public 2013-01-07 10:14:06 INFO : Adding child object to schema public 2013-01-07 10:14:06 QUERY : Set query (10.4.0.121:5432): SELECT oid, format_type(oid, typtypmod) AS typname FROM pg_type 2013-01-07 10:14:25 QUERY : Set query (10.4.0.121:5432): SELECT aggfnoid::oid, proname AS aggname, pg_get_userbyid(proowner)AS aggowner, aggtransfn, aggfinalfn, proargtypes, aggtranstype, proacl, CASE WHEN (tt.typlen = -1 AND tt.typelem != 0) THEN (SELECT at.typname FROMpg_type at WHERE at.oid = tt.typelem) || '[]' ELSE tt.typname END as transname, prorettype AS aggfinaltype, CASE WHEN(tf.typlen = -1 AND tf.typelem != 0) THEN (SELECT at.typname FROM pg_type at WHERE at.oid = tf.typelem) || '[]' ELSEtf.typname END as finalname, agginitval, description, oprname, opn.nspname as oprnsp FROM pg_aggregate ag LEFT OUTERJOIN pg_operator op ON op.oid=aggsortop LEFT OUTER JOIN pg_namespace opn ON opn.oid=op.oprnamespace JOIN pg_proc prON pr.oid = ag.aggfnoid JOIN pg_type tt on tt.oid=aggtranstype JOIN pg_type tf on tf.oid=prorettype LEFT OUTER JOIN pg_descriptiondes ON des.objoid=aggfnoid::oidWHERE pronamespace = 2200::oidORDER BY aggname 2013-01-07 10:14:25 QUERY : Set query (10.4.0.121:5432): SELECT co.oid, co.*, pg_encoding_to_char(conforencoding) as forencoding,pg_get_userbyid(conowner) as owner,pg_encoding_to_char(contoencoding) as toencoding, proname, nspname, descriptionFROM pg_conversion co JOIN pg_proc pr ON pr.oid=conproc JOIN pg_namespace na ON na.oid=pr.pronamespace LEFT OUTERJOIN pg_description des ON des.objoid=co.oid AND des.objsubid=0WHERE connamespace = 2200::oidORDER BY conname 2013-01-07 10:14:25 QUERY : Set query (10.4.0.121:5432): SELECT d.oid, d.typname as domname, d.typbasetype, format_type(b.oid,NULL)as basetype, pg_get_userbyid(d.typowner) as domainowner, d.typlen, d.typtypmod, d.typnotnull,d.typdefault, d.typndims, d.typdelim, bn.nspname as basensp, description, (SELECT COUNT(1) FROM pg_typet2 WHERE t2.typname=d.typname) > 1 AS domisdup, (SELECT COUNT(1) FROM pg_type t3 WHERE t3.typname=b.typname)> 1 AS baseisdup FROM pg_type d JOIN pg_type b ON b.oid = d.typbasetype JOIN pg_namespace bn ON bn.oid=b.typnamespaceLEFT OUTER JOIN pg_description des ON des.objoid=d.oidWHERE d.typtype = 'd' AND d.typnamespace = 2200::oidORDERBY d.typname 2013-01-07 10:14:25 QUERY : Set query (10.4.0.121:5432): SELECT cfg.oid, cfg.cfgname, pg_get_userbyid(cfg.cfgowner) as cfgowner,cfg.cfgparser, parser.prsname as parsername, description FROM pg_ts_config cfg LEFT OUTER JOIN pg_ts_parser parserON parser.oid=cfg.cfgparser LEFT OUTER JOIN pg_description des ON des.objoid=cfg.oidWHERE cfg.cfgnamespace = 2200::oidORDERBY cfg.cfgname 2013-01-07 10:14:25 QUERY : Set query (10.4.0.121:5432): SELECT dict.oid, dict.dictname, pg_get_userbyid(dict.dictowner)as dictowner, t.tmplname, dict.dictinitoption, description FROM pg_ts_dict dict LEFT OUTERJOIN pg_ts_template t ON t.oid=dict.dicttemplate LEFT OUTER JOIN pg_description des ON des.objoid=dict.oidWHERE dict.dictnamespace= 2200::oidORDER BY dict.dictname 2013-01-07 10:14:25 QUERY : Set query (10.4.0.121:5432): SELECT prs.oid, prs.prsname, prs.prsstart, prs.prstoken, prs.prsend,prs.prslextype, prs.prsheadline, description FROM pg_ts_parser prs LEFT OUTER JOIN pg_description des ON des.objoid=prs.oidWHEREprs.prsnamespace = 2200::oidORDER BY prs.prsname 2013-01-07 10:14:25 QUERY : Set query (10.4.0.121:5432): SELECT tmpl.oid, tmpl.tmplname, tmpl.tmplinit, tmpl.tmpllexize,description FROM pg_ts_template tmpl LEFT OUTER JOIN pg_description des ON des.objoid=tmpl.oidWHERE tmpl.tmplnamespace= 2200::oidORDER BY tmpl.tmplname 2013-01-07 10:14:25 QUERY : Set query (10.4.0.121: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=pronamespaceWHERE 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') 2013-01-07 10:14:25 QUERY : Scalar query (10.4.0.121:5432): SELECT count(*) FROM pg_attribute WHERE attrelid = 'pg_catalog.pg_proc'::regclassAND attname = 'proargdefaults' 2013-01-07 10:14:25 QUERY : Query result: 1 2013-01-07 10:14:25 QUERY : Set query (10.4.0.121:5432): SELECT pr.oid, pr.xmin, pr.*, format_type(TYP.oid, NULL) AS typname,typns.nspname AS typnsp, lanname, proargnames, pg_get_expr(proargdefaults, 'pg_catalog.pg_class'::regclass) AS proargdefaultvals,pronargdefaults, proconfig, pg_get_userbyid(proowner) as funcowner, description FROM pg_proc prJOIN pg_type typ ON typ.oid=prorettype JOIN pg_namespace typns ON typns.oid=typ.typnamespace JOIN pg_language lng ON lng.oid=prolangLEFT OUTER JOIN pg_description des ON des.objoid=pr.oidWHERE proisagg = FALSE AND pronamespace = 2200::oid AND typname <> 'trigger'ORDER BY proname 2013-01-07 10:14:26 QUERY : Set query (10.4.0.121:5432): SELECT oid, format_type(oid, NULL) AS typname FROM pg_type 2013-01-07 10:14:38 QUERY : Set query (10.4.0.121:5432): SELECT op.oid, op.oprname, pg_get_userbyid(op.oprowner) as opowner,op.oprkind, op.oprcanhash, op.oprcanmerge, op.oprleft, op.oprright, lt.typname as lefttype, rt.typname as righttype,et.typname as resulttype, co.oprname as compop, ne.oprname as negop, op.oprcode as operproc, op.oprjoinas joinproc, op.oprrest as restrproc, description FROM pg_operator op LEFT OUTER JOIN pg_type lt ON lt.oid=op.oprleftLEFT OUTER JOIN pg_type rt ON rt.oid=op.oprright JOIN pg_type et on et.oid=op.oprresult LEFT OUTER JOINpg_operator co ON co.oid=op.oprcom LEFT OUTER JOIN pg_operator ne ON ne.oid=op.oprnegate LEFT OUTER JOIN pg_descriptiondes ON des.objoid=op.oidWHERE op.oprnamespace = 2200::oidORDER BY op.oprname 2013-01-07 10:14:38 QUERY : Set query (10.4.0.121:5432): SELECT op.oid, op.*, pg_get_userbyid(op.opcowner) as opowner, it.typnameas intypename, dt.typname as keytypename, amname, opfname FROM pg_opclass op JOIN pg_opfamily opf ON op.opcfamily=opf.oidJOIN pg_am am ON am.oid=opf.opfmethod JOIN pg_type it ON it.oid=opcintype LEFT OUTER JOIN pg_type dtON dt.oid=opckeytypeWHERE opcnamespace = 2200::oidORDER BY opcname 2013-01-07 10:14:38 QUERY : Set query (10.4.0.121:5432): SELECT opf.oid, opf.*, pg_get_userbyid(opf.opfowner) as opowner,amname FROM pg_opfamily opf JOIN pg_am am ON am.oid=opf.opfmethodWHERE opfnamespace = 2200::oidORDER BY opfname 2013-01-07 10:14:38 QUERY : Set query (10.4.0.121:5432): SELECT cl.oid, relname, pg_get_userbyid(relowner) AS seqowner,relacl, description FROM pg_class cl LEFT OUTER JOIN pg_description des ON des.objoid=cl.oidWHERE relkind = 'S'AND relnamespace = 2200::oidORDER BY relname 2013-01-07 10:14:38 QUERY : Set query (10.4.0.121:5432): SELECT rel.oid, rel.relname, rel.reltablespace AS spcoid, spc.spcname,pg_get_userbyid(rel.relowner) AS relowner, rel.relacl, rel.relhasoids, rel.relhassubclass, rel.reltuples, des.description,con.conname, con.conkey, EXISTS(select 1 FROM pg_trigger JOIN pg_proc pt ON pt.oid=tgfoidAND pt.proname='logtrigger' JOIN pg_proc pc ON pc.pronamespace=pt.pronamespace AND pc.proname='slonyversion' WHERE tgrelid=rel.oid) AS isrepl, (select count(*) FROM pg_trigger WHERE tgrelid=rel.oid AND tgisconstraint = FALSE) AS triggercount , substring(array_to_string(rel.reloptions, ',') FROM 'fillfactor=([0-9]*)') AS fillfactor , substring(array_to_string(rel.reloptions, ',') FROM 'autovacuum_enabled=([a-z|0-9]*)') AS autovacuum_enabled , substring(array_to_string(rel.reloptions, ',') FROM 'autovacuum_vacuum_threshold=([0-9]*)') AS autovacuum_vacuum_threshold , substring(array_to_string(rel.reloptions, ',') FROM 'autovacuum_vacuum_scale_factor=([0-9]*[.][0-9]*)') AS autovacuum_vacuum_scale_factor , substring(array_to_string(rel.reloptions, ',') FROM 'autovacuum_analyze_threshold=([0-9]*)') AS autovacuum_analyze_threshold , substring(array_to_string(rel.reloptions, ',') FROM 'autovacuum_analyze_scale_factor=([0-9]*[.][0-9]*)') AS autovacuum_analyze_scale_factor , substring(array_to_string(rel.reloptions, ',') FROM 'autovacuum_vacuum_cost_delay=([0-9]*)') AS autovacuum_vacuum_cost_delay , substring(array_to_string(rel.reloptions, ',') FROM 'autovacuum_vacuum_cost_limit=([0-9]*)') AS autovacuum_vacuum_cost_limit , substring(array_to_string(rel.reloptions, ',') FROM 'autovacuum_freeze_min_age=([0-9]*)') AS autovacuum_freeze_min_age , substring(array_to_string(rel.reloptions, ',') FROM 'autovacuum_freeze_max_age=([0-9]*)') AS autovacuum_freeze_max_age , substring(array_to_string(rel.reloptions, ',') FROM 'autovacuum_freeze_table_age=([0-9]*)') AS autovacuum_freeze_table_age , substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_enabled=([a-z|0-9]*)') AS toast_autovacuum_enabled , substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_vacuum_threshold=([0-9]*)') AS toast_autovacuum_vacuum_threshold , substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_vacuum_scale_factor=([0-9]*[.][0-9]*)') AS toast_autovacuum_vacuum_scale_factor , substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_analyze_threshold=([0-9]*)') AS toast_autovacuum_analyze_threshold , substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_analyze_scale_factor=([0-9]*[.][0-9]*)') AS toast_autovacuum_analyze_scale_factor , substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_vacuum_cost_delay=([0-9]*)') AS toast_autovacuum_vacuum_cost_delay , substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_vacuum_cost_limit=([0-9]*)') AS toast_autovacuum_vacuum_cost_limit , substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_freeze_min_age=([0-9]*)') AS toast_autovacuum_freeze_min_age , substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_freeze_max_age=([0-9]*)') AS toast_autovacuum_freeze_max_age , substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_freeze_table_age=([0-9]*)') AS toast_autovacuum_freeze_table_age , rel.reloptions AS reloptions, tst.reloptions AS toast_reloptions , (CASE WHEN rel.reltoastrelid = 0 THEN false ELSE true END) AS hastoasttable FROM pg_class rel LEFT OUTER JOIN pg_tablespacespc on spc.oid=rel.reltablespace LEFT OUTER JOIN pg_description des ON (des.objoid=rel.oid AND des.objsubid=0)LEFT OUTER JOIN pg_constraint con ON con.conrelid=rel.oid AND con.contype='p' LEFT OUTER JOIN pg_class tstON tst.oid = rel.reltoastrelidWHERE rel.relkind IN ('r','s','t') AND rel.relnamespace = 2200::oidORDER BY rel.relname 2013-01-07 10:14:38 QUERY : Set query (10.4.0.121:5432): SELECT pr.oid, pr.xmin, pr.*, format_type(TYP.oid, NULL) AS typname,typns.nspname AS typnsp, lanname, proargnames, pg_get_expr(proargdefaults, 'pg_catalog.pg_class'::regclass) AS proargdefaultvals,pronargdefaults, proconfig, pg_get_userbyid(proowner) as funcowner, description FROM pg_proc prJOIN pg_type typ ON typ.oid=prorettype JOIN pg_namespace typns ON typns.oid=typ.typnamespace JOIN pg_language lng ON lng.oid=prolangLEFT OUTER JOIN pg_description des ON des.objoid=pr.oidWHERE proisagg = FALSE AND pronamespace = 2200::oid AND typname = 'trigger' AND lanname != 'edbspl'ORDER BY proname 2013-01-07 10:14:38 QUERY : Set query (10.4.0.121:5432): SELECT oid, format_type(oid, NULL) AS typname FROM pg_type 2013-01-07 10:14:50 QUERY : Set query (10.4.0.121:5432): SELECT t.oid, t.*, format_type(t.oid, null) AS alias, pg_get_userbyid(t.typowner) as typeowner, e.typname as element, description, ct.oid AS taboid FROM pg_type t LEFT OUTER JOIN pg_type e ON e.oid=t.typelem LEFT OUTER JOIN pg_class ct ONct.oid=t.typrelid AND ct.relkind <> 'c' LEFT OUTER JOIN pg_description des ON des.objoid=t.oidWHERE t.typtype != 'd' ANDt.typname NOT LIKE E'\\_%' AND t.typnamespace = 2200::oidORDER BY t.typname 2013-01-07 10:14:50 QUERY : Set query (10.4.0.121:5432): SELECT c.oid, c.xmin, c.relname, pg_get_userbyid(c.relowner) ASviewowner, c.relacl, description, pg_get_viewdef(c.oid, true) AS definition FROM pg_class c LEFT OUTER JOIN pg_descriptiondes ON (des.objoid=c.oid and des.objsubid=0)WHERE ((c.relhasrules AND (EXISTS ( SELECT r.rulenameFROM pg_rewrite r WHERE ((r.ev_class = c.oid) AND (bpchar(r.ev_type) = '1'::bpchar)) )))OR (c.relkind = 'v'::char)) AND relnamespace = 2200::oidORDER BY relname 2013-01-07 10:14:50 QUERY : Set query (10.4.0.121: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=pronamespaceWHERE 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') 2013-01-07 10:14:50 QUERY : Scalar query (10.4.0.121:5432): SELECT count(*) FROM pg_attribute WHERE attrelid = 'pg_catalog.pg_proc'::regclassAND attname = 'proargdefaults' 2013-01-07 10:14:50 QUERY : Query result: 1 2013-01-07 10:14:50 INFO : Displaying properties for Schema public 2013-01-07 10:14:50 STATUS : Restoring previous environment... (45.84 secs) 2013-01-07 10:14:58 INFO : Displaying properties for Schema toolkit 2013-01-07 10:14:58 STATUS : Retrieving details on schema toolkit... 2013-01-07 10:14:58 INFO : Adding child object to schema toolkit 2013-01-07 10:14:58 QUERY : Set query (10.4.0.121:5432): SELECT oid, format_type(oid, typtypmod) AS typname FROM pg_type 2013-01-07 10:15:10 QUERY : Set query (10.4.0.121:5432): SELECT aggfnoid::oid, proname AS aggname, pg_get_userbyid(proowner)AS aggowner, aggtransfn, aggfinalfn, proargtypes, aggtranstype, proacl, CASE WHEN (tt.typlen = -1 AND tt.typelem != 0) THEN (SELECT at.typname FROMpg_type at WHERE at.oid = tt.typelem) || '[]' ELSE tt.typname END as transname, prorettype AS aggfinaltype, CASE WHEN(tf.typlen = -1 AND tf.typelem != 0) THEN (SELECT at.typname FROM pg_type at WHERE at.oid = tf.typelem) || '[]' ELSEtf.typname END as finalname, agginitval, description, oprname, opn.nspname as oprnsp FROM pg_aggregate ag LEFT OUTERJOIN pg_operator op ON op.oid=aggsortop LEFT OUTER JOIN pg_namespace opn ON opn.oid=op.oprnamespace JOIN pg_proc prON pr.oid = ag.aggfnoid JOIN pg_type tt on tt.oid=aggtranstype JOIN pg_type tf on tf.oid=prorettype LEFT OUTER JOIN pg_descriptiondes ON des.objoid=aggfnoid::oidWHERE pronamespace = 1047743::oidORDER BY aggname 2013-01-07 10:15:10 QUERY : Set query (10.4.0.121:5432): SELECT co.oid, co.*, pg_encoding_to_char(conforencoding) as forencoding,pg_get_userbyid(conowner) as owner,pg_encoding_to_char(contoencoding) as toencoding, proname, nspname, descriptionFROM pg_conversion co JOIN pg_proc pr ON pr.oid=conproc JOIN pg_namespace na ON na.oid=pr.pronamespace LEFT OUTERJOIN pg_description des ON des.objoid=co.oid AND des.objsubid=0WHERE connamespace = 1047743::oidORDER BY conname 2013-01-07 10:15:10 QUERY : Set query (10.4.0.121:5432): SELECT d.oid, d.typname as domname, d.typbasetype, format_type(b.oid,NULL)as basetype, pg_get_userbyid(d.typowner) as domainowner, d.typlen, d.typtypmod, d.typnotnull,d.typdefault, d.typndims, d.typdelim, bn.nspname as basensp, description, (SELECT COUNT(1) FROM pg_typet2 WHERE t2.typname=d.typname) > 1 AS domisdup, (SELECT COUNT(1) FROM pg_type t3 WHERE t3.typname=b.typname)> 1 AS baseisdup FROM pg_type d JOIN pg_type b ON b.oid = d.typbasetype JOIN pg_namespace bn ON bn.oid=b.typnamespaceLEFT OUTER JOIN pg_description des ON des.objoid=d.oidWHERE d.typtype = 'd' AND d.typnamespace = 1047743::oidORDERBY d.typname 2013-01-07 10:15:10 QUERY : Set query (10.4.0.121:5432): SELECT cfg.oid, cfg.cfgname, pg_get_userbyid(cfg.cfgowner) as cfgowner,cfg.cfgparser, parser.prsname as parsername, description FROM pg_ts_config cfg LEFT OUTER JOIN pg_ts_parser parserON parser.oid=cfg.cfgparser LEFT OUTER JOIN pg_description des ON des.objoid=cfg.oidWHERE cfg.cfgnamespace = 1047743::oidORDERBY cfg.cfgname 2013-01-07 10:15:10 QUERY : Set query (10.4.0.121:5432): SELECT dict.oid, dict.dictname, pg_get_userbyid(dict.dictowner)as dictowner, t.tmplname, dict.dictinitoption, description FROM pg_ts_dict dict LEFT OUTERJOIN pg_ts_template t ON t.oid=dict.dicttemplate LEFT OUTER JOIN pg_description des ON des.objoid=dict.oidWHERE dict.dictnamespace= 1047743::oidORDER BY dict.dictname 2013-01-07 10:15:10 QUERY : Set query (10.4.0.121:5432): SELECT prs.oid, prs.prsname, prs.prsstart, prs.prstoken, prs.prsend,prs.prslextype, prs.prsheadline, description FROM pg_ts_parser prs LEFT OUTER JOIN pg_description des ON des.objoid=prs.oidWHEREprs.prsnamespace = 1047743::oidORDER BY prs.prsname 2013-01-07 10:15:10 QUERY : Set query (10.4.0.121:5432): SELECT tmpl.oid, tmpl.tmplname, tmpl.tmplinit, tmpl.tmpllexize,description FROM pg_ts_template tmpl LEFT OUTER JOIN pg_description des ON des.objoid=tmpl.oidWHERE tmpl.tmplnamespace= 1047743::oidORDER BY tmpl.tmplname 2013-01-07 10:15:10 QUERY : Set query (10.4.0.121:5432): SELECT pr.oid, pr.xmin, pr.*, format_type(TYP.oid, NULL) AS typname,typns.nspname AS typnsp, lanname, proargnames, pg_get_expr(proargdefaults, 'pg_catalog.pg_class'::regclass) AS proargdefaultvals,pronargdefaults, proconfig, pg_get_userbyid(proowner) as funcowner, description FROM pg_proc prJOIN pg_type typ ON typ.oid=prorettype JOIN pg_namespace typns ON typns.oid=typ.typnamespace JOIN pg_language lng ON lng.oid=prolangLEFT OUTER JOIN pg_description des ON des.objoid=pr.oidWHERE proisagg = FALSE AND pronamespace = 1047743::oid AND typname <> 'trigger'ORDER BY proname 2013-01-07 10:15:13 QUERY : Set query (10.4.0.121:5432): SELECT oid, format_type(oid, NULL) AS typname FROM pg_type 2013-01-07 10:15:25 QUERY : Set query (10.4.0.121:5432): SELECT op.oid, op.oprname, pg_get_userbyid(op.oprowner) as opowner,op.oprkind, op.oprcanhash, op.oprcanmerge, op.oprleft, op.oprright, lt.typname as lefttype, rt.typname as righttype,et.typname as resulttype, co.oprname as compop, ne.oprname as negop, op.oprcode as operproc, op.oprjoinas joinproc, op.oprrest as restrproc, description FROM pg_operator op LEFT OUTER JOIN pg_type lt ON lt.oid=op.oprleftLEFT OUTER JOIN pg_type rt ON rt.oid=op.oprright JOIN pg_type et on et.oid=op.oprresult LEFT OUTER JOINpg_operator co ON co.oid=op.oprcom LEFT OUTER JOIN pg_operator ne ON ne.oid=op.oprnegate LEFT OUTER JOIN pg_descriptiondes ON des.objoid=op.oidWHERE op.oprnamespace = 1047743::oidORDER BY op.oprname 2013-01-07 10:15:25 QUERY : Set query (10.4.0.121:5432): SELECT op.oid, op.*, pg_get_userbyid(op.opcowner) as opowner, it.typnameas intypename, dt.typname as keytypename, amname, opfname FROM pg_opclass op JOIN pg_opfamily opf ON op.opcfamily=opf.oidJOIN pg_am am ON am.oid=opf.opfmethod JOIN pg_type it ON it.oid=opcintype LEFT OUTER JOIN pg_type dtON dt.oid=opckeytypeWHERE opcnamespace = 1047743::oidORDER BY opcname 2013-01-07 10:15:25 QUERY : Set query (10.4.0.121:5432): SELECT opf.oid, opf.*, pg_get_userbyid(opf.opfowner) as opowner,amname FROM pg_opfamily opf JOIN pg_am am ON am.oid=opf.opfmethodWHERE opfnamespace = 1047743::oidORDER BY opfname 2013-01-07 10:15:25 QUERY : Set query (10.4.0.121:5432): SELECT cl.oid, relname, pg_get_userbyid(relowner) AS seqowner,relacl, description FROM pg_class cl LEFT OUTER JOIN pg_description des ON des.objoid=cl.oidWHERE relkind = 'S'AND relnamespace = 1047743::oidORDER BY relname 2013-01-07 10:15:25 QUERY : Set query (10.4.0.121:5432): SELECT rel.oid, rel.relname, rel.reltablespace AS spcoid, spc.spcname,pg_get_userbyid(rel.relowner) AS relowner, rel.relacl, rel.relhasoids, rel.relhassubclass, rel.reltuples, des.description,con.conname, con.conkey, EXISTS(select 1 FROM pg_trigger JOIN pg_proc pt ON pt.oid=tgfoidAND pt.proname='logtrigger' JOIN pg_proc pc ON pc.pronamespace=pt.pronamespace AND pc.proname='slonyversion' WHERE tgrelid=rel.oid) AS isrepl, (select count(*) FROM pg_trigger WHERE tgrelid=rel.oid AND tgisconstraint = FALSE) AS triggercount , substring(array_to_string(rel.reloptions, ',') FROM 'fillfactor=([0-9]*)') AS fillfactor , substring(array_to_string(rel.reloptions, ',') FROM 'autovacuum_enabled=([a-z|0-9]*)') AS autovacuum_enabled , substring(array_to_string(rel.reloptions, ',') FROM 'autovacuum_vacuum_threshold=([0-9]*)') AS autovacuum_vacuum_threshold , substring(array_to_string(rel.reloptions, ',') FROM 'autovacuum_vacuum_scale_factor=([0-9]*[.][0-9]*)') AS autovacuum_vacuum_scale_factor , substring(array_to_string(rel.reloptions, ',') FROM 'autovacuum_analyze_threshold=([0-9]*)') AS autovacuum_analyze_threshold , substring(array_to_string(rel.reloptions, ',') FROM 'autovacuum_analyze_scale_factor=([0-9]*[.][0-9]*)') AS autovacuum_analyze_scale_factor , substring(array_to_string(rel.reloptions, ',') FROM 'autovacuum_vacuum_cost_delay=([0-9]*)') AS autovacuum_vacuum_cost_delay , substring(array_to_string(rel.reloptions, ',') FROM 'autovacuum_vacuum_cost_limit=([0-9]*)') AS autovacuum_vacuum_cost_limit , substring(array_to_string(rel.reloptions, ',') FROM 'autovacuum_freeze_min_age=([0-9]*)') AS autovacuum_freeze_min_age , substring(array_to_string(rel.reloptions, ',') FROM 'autovacuum_freeze_max_age=([0-9]*)') AS autovacuum_freeze_max_age , substring(array_to_string(rel.reloptions, ',') FROM 'autovacuum_freeze_table_age=([0-9]*)') AS autovacuum_freeze_table_age , substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_enabled=([a-z|0-9]*)') AS toast_autovacuum_enabled , substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_vacuum_threshold=([0-9]*)') AS toast_autovacuum_vacuum_threshold , substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_vacuum_scale_factor=([0-9]*[.][0-9]*)') AS toast_autovacuum_vacuum_scale_factor , substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_analyze_threshold=([0-9]*)') AS toast_autovacuum_analyze_threshold , substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_analyze_scale_factor=([0-9]*[.][0-9]*)') AS toast_autovacuum_analyze_scale_factor , substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_vacuum_cost_delay=([0-9]*)') AS toast_autovacuum_vacuum_cost_delay , substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_vacuum_cost_limit=([0-9]*)') AS toast_autovacuum_vacuum_cost_limit , substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_freeze_min_age=([0-9]*)') AS toast_autovacuum_freeze_min_age , substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_freeze_max_age=([0-9]*)') AS toast_autovacuum_freeze_max_age , substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_freeze_table_age=([0-9]*)') AS toast_autovacuum_freeze_table_age , rel.reloptions AS reloptions, tst.reloptions AS toast_reloptions , (CASE WHEN rel.reltoastrelid = 0 THEN false ELSE true END) AS hastoasttable FROM pg_class rel LEFT OUTER JOIN pg_tablespacespc on spc.oid=rel.reltablespace LEFT OUTER JOIN pg_description des ON (des.objoid=rel.oid AND des.objsubid=0)LEFT OUTER JOIN pg_constraint con ON con.conrelid=rel.oid AND con.contype='p' LEFT OUTER JOIN pg_class tstON tst.oid = rel.reltoastrelidWHERE rel.relkind IN ('r','s','t') AND rel.relnamespace = 1047743::oidORDER BY rel.relname 2013-01-07 10:15:25 QUERY : Set query (10.4.0.121:5432): SELECT pr.oid, pr.xmin, pr.*, format_type(TYP.oid, NULL) AS typname,typns.nspname AS typnsp, lanname, proargnames, pg_get_expr(proargdefaults, 'pg_catalog.pg_class'::regclass) AS proargdefaultvals,pronargdefaults, proconfig, pg_get_userbyid(proowner) as funcowner, description FROM pg_proc prJOIN pg_type typ ON typ.oid=prorettype JOIN pg_namespace typns ON typns.oid=typ.typnamespace JOIN pg_language lng ON lng.oid=prolangLEFT OUTER JOIN pg_description des ON des.objoid=pr.oidWHERE proisagg = FALSE AND pronamespace = 1047743::oid AND typname = 'trigger' AND lanname != 'edbspl'ORDER BY proname 2013-01-07 10:15:25 QUERY : Set query (10.4.0.121:5432): SELECT oid, format_type(oid, NULL) AS typname FROM pg_type 2013-01-07 10:15:38 QUERY : Set query (10.4.0.121:5432): SELECT t.oid, t.*, format_type(t.oid, null) AS alias, pg_get_userbyid(t.typowner) as typeowner, e.typname as element, description, ct.oid AS taboid FROM pg_type t LEFT OUTER JOIN pg_type e ON e.oid=t.typelem LEFT OUTER JOIN pg_class ct ONct.oid=t.typrelid AND ct.relkind <> 'c' LEFT OUTER JOIN pg_description des ON des.objoid=t.oidWHERE t.typtype != 'd' ANDt.typname NOT LIKE E'\\_%' AND t.typnamespace = 1047743::oidORDER BY t.typname 2013-01-07 10:15:38 QUERY : Set query (10.4.0.121:5432): SELECT c.oid, c.xmin, c.relname, pg_get_userbyid(c.relowner) ASviewowner, c.relacl, description, pg_get_viewdef(c.oid, true) AS definition FROM pg_class c LEFT OUTER JOIN pg_descriptiondes ON (des.objoid=c.oid and des.objsubid=0)WHERE ((c.relhasrules AND (EXISTS ( SELECT r.rulenameFROM pg_rewrite r WHERE ((r.ev_class = c.oid) AND (bpchar(r.ev_type) = '1'::bpchar)) )))OR (c.relkind = 'v'::char)) AND relnamespace = 1047743::oidORDER BY relname 2013-01-07 10:15:40 STATUS : Retrieving details on schema toolkit... (41.62 secs) 2013-01-07 10:16:00 INFO : Setting logfile to: C:\Users\Klaus\Documents\pgadmin.log 2013-01-07 10:16:00 INFO : Setting loglevel to: &Errors only -----Original Message----- From: Robert Klaus [mailto:rklaus@nexgenwireless.com] Sent: Sunday, January 06, 2013 3:39 PM To: 'Guillaume Lelarge' Cc: 'pgadmin-support@postgresql.org' Subject: RE: [pgadmin-support] Large number of rows in pg_type and slow gui (pgadmin) refresh Thank you! I think this is exactly what we need. Just get a list of all namespaces in the server except for the onethat we don't want to appear and put them in a string of schemanames . . . 'public','evdo','lte','voice', ... etc -----Original Message----- From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Guillaume Lelarge Sent: Sunday, January 06, 2013 11:49 AM To: Robert Klaus Cc: pgadmin-support@postgresql.org Subject: Re: [pgadmin-support] Large number of rows in pg_type and slow gui (pgadmin) refresh On Sun, 2013-01-06 at 11:27 -0600, Robert Klaus wrote: > Get all schemas, except some of them. One schema will have 90+% of the database objects. > You can already do that without having a custom pgAdmin. > If we could eliminate that schema fewer rows would be returned by the underlying queries, allowing us to continue usingpgAdmin. > > I've only been working with this company (and postgresql) for 90 days so if there is a better way (other than rewritingthe application that creates all those tables and views) please let me know how to proceed. > Get into the properties of your database, select the Definition tab, add your schema name in the "Schema restriction" textbox(make sure you put single quotes around it), and click OK. Disconnect, reconnect... should work. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
pgadmin-support by date: