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