Slow opening of Table -> Properties... -> Columns

From: Kieran McCusker <kieran(dot)mccusker(at)kwest(dot)info>
To: pgadmin-support(at)postgresql(dot)org
Subject: Slow opening of Table -> Properties... -> Columns
Date: 2009-05-11 07:40:36
Message-ID: 4A07D674.4010004@kwest.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi

Enabling logging revealed the following :-

2009-05-11 08:10:05 INFO : Setting logfile to:
C:\Users\mccuskk\Documents\pgadmin.log
2009-05-11 08:10:05 INFO : Setting loglevel to: &Debug (not
recommended for normal use)
2009-05-11 08:10:07 INFO : Displaying properties for Table events
2009-05-11 08:10:07 STATUS : Retrieving Table details...
2009-05-11 08:10:07 STATUS : Retrieving Table details... (0.00 secs)
2009-05-11 08:10:09 QUERY : Set query (kwest:5432): SELECT groname FROM
pg_group ORDER BY groname
2009-05-11 08:10:09 QUERY : Set query (kwest:5432): SELECT groname FROM
pg_group ORDER BY groname
2009-05-11 08:10:09 QUERY : Set query (kwest:5432): SELECT rolname FROM
pg_roles WHERE rolcanlogin ORDER BY 1
2009-05-11 08:10:09 QUERY : Set query (kwest:5432): SELECT oid, spcname
FROM pg_tablespace WHERE spcname <> 'pg_global' ORDER BY spcname
2009-05-11 08:10:09 QUERY : Set query (kwest:5432): SELECT c.oid,
c.relname , nspname
FROM pg_class c
JOIN pg_namespace n ON n.oid=c.relnamespace
WHERE relkind='r'
AND (n.nspname NOT LIKE E'pg\_%' AND n.nspname NOT in
('information_schema')) AND c.oid NOT IN (24996767::oid) ORDER BY
relnamespace, c.relname
2009-05-11 08:10:10 QUERY : Set query (kwest:5432): SELECT name,
setting FROM pg_settings WHERE name like '%vacuum%' ORDER BY name
2009-05-11 08:10:10 QUERY : Set query (kwest:5432): SELECT * FROM
pg_autovacuum WHERE vacrelid=24996767::oid
2009-05-11 08:10:17 QUERY : Set query (kwest:5432): SELECT
format_type(t.oid,NULL) AS typname, CASE WHEN typelem > 0 THEN typelem
ELSE t.oid END as elemoid, typlen, typtype, t.oid, nspname,
(SELECT COUNT(1) FROM pg_type t2 WHERE t2.typname = t.typname) >
1 AS isdup
FROM pg_type t
JOIN pg_namespace nsp ON typnamespace=nsp.oid
WHERE (NOT (typname = 'unknown' AND nspname = 'pg_catalog')) AND
typisdefined AND typtype IN ('b', 'c', 'd', 'e')AND typname NOT IN
(SELECT relname FROM pg_class WHERE relnamespace = typnamespace AND
relkind != 'c' UNION SELECT '_' || relname FROM pg_class WHERE
relnamespace = typnamespace AND relkind != 'c') AND nsp.nspname NOT
LIKE 'information_schema'
ORDER BY CASE WHEN typtype='d' THEN 0 ELSE 1 END, (t.typelem>0)::bool, 1

The last query is where the time went - Running it in a query window it
took 235 seconds.

Let me know if I can provide anything else

Cheers

Kieran

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2009-05-11 08:37:24 Re: pgadmin-support] Beta 3
Previous Message Ashesh Vashi 2009-05-11 06:31:31 Re: Beta 3