Beta 2 logging
От | Kieran McCusker |
---|---|
Тема | Beta 2 logging |
Дата | |
Msg-id | 49D38062.90303@kwest.info обсуждение исходный текст |
Ответы |
Re: Beta 2 logging
(Dave Page <dpage@pgadmin.org>)
|
Список | pgadmin-support |
<font face="Helvetica, Arial, sans-serif">Hi again<br /><br /> I was going to look at the SQL that produces the view or tablewhen you click on it in the UI as it seems a little sluggish in our (admittedly large 5000+ views and tables) database.Enabling logging I got the following (at least for views and tables). The query (I've marked in bold) appears tobe cut off mid-sentence....<br /><br /> Cheers<br /><br /> Kieran<br /><br /><br /></font><tt><b>2009-04-01 15:44:28 STATUS: Retrieving View details...<br /> 2009-04-01 15:44:28 QUERY : Set query (kwest:5432): SELECT att.*, def.*, pg_catalog.pg_get_expr(def.adbin,def.adrelid) AS defval, CASE WHEN att.attndims > 0 THEN 1 ELSE 0 END AS isarray, format_type(ty.oid,NULL)AS typname, tn.nspname as typnspname, et.typname as elemtypname,<br /> cl.relname, na.nspname,att.attstattarget, description, cs.relname AS sername, ns.nspname AS serschema,<br /> (SELECT count(1) FROMpg_type t2 WHERE t2.typname=ty.typname) > 1 AS isdup, indkey, inha.attrelid::regclass AS inhrelname,<br /> EXISTS(SELECT1 FROM pg_constraint WHERE conrelid=att.attrelid AND contype='f' AND att.attnum=ANY(conkey)) As isfk<br /> FROM pg_attribute att<br /> JOIN pg_type ty ON ty.oid=atttypid<br /> JOIN pg_namespace tn ON tn.oid=ty.typnamespace<br/> JOIN pg_class cl ON cl.oid=att.attrelid<br /> JOIN pg_namespace na ON na.oid=cl.relnamespace<br/> LEFT OUTER JOIN pg_type et ON et.oid=ty.typelem<br /> LEFT OUTER JOIN pg_attrdef def ON adrelid=att.attrelidAND adnum=att.attnum<br /> LEFT OUTER JOIN pg_description des ON des.objoid=att.attrelid AND des.objsubid=att.attnum<br/> L<br /></b>2009-04-01 15:44:29 QUERY : Set query (kwest:5432): SELECT rw.oid, rw.*, relname,CASE WHEN relkind = 'r' THEN TRUE ELSE FALSE END AS parentistable, nspname, description,<br /> pg_get_ruledef(rw.oid,true) AS definition<br /> FROM pg_rewrite rw<br /> JOIN pg_class cl ON cl.oid=rw.ev_class<br /> JOIN pg_namespace nsp ON nsp.oid=cl.relnamespace<br /> LEFT OUTER JOIN pg_description des ON des.objoid=rw.oid<br /> WHERE ev_class = 25967555<br /> ORDER BY rw.rulename<br /> 2009-04-01 15:44:29 STATUS : Retrieving View details... (0.72secs)<br /></tt><font face="Helvetica, Arial, sans-serif"><br /></font>
В списке pgadmin-support по дате отправления: