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
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 |