pgAdmin enhancement request. - Mailing list pgadmin-support
| From | Yan, Shawn |
|---|---|
| Subject | pgAdmin enhancement request. |
| Date | |
| Msg-id | B53D7D9482FE95419DA1D8D8CA5B7FB1108DF15A85@MX10A.corp.emc.com Whole thread Raw |
| Responses |
Re: pgAdmin enhancement request.
|
| List | pgadmin-support |
<div class="WordSection1"><p class="MsoNormal">Hi pgAdmin team,<p class="MsoNormal"> <p class="MsoNormal">May I request
anenhancement request for pgAdmin tool? We are the support team for Greenplum product. It’s found when using pgAdmin
toolto connect Greenplum database, this tool would automatically query the Greenplum catalog tables, like ‘pg_class’.
Butthe query generated from pgAdmin tool have a very high cost. This high cost query would cause customer with resource
queuecontrol (max cost limit) unable to use pgAdmin tool.<p class="MsoNormal"> <p class="MsoNormal">One of pgAdmin
querylike below :<p class="MsoNormal">SELECT rel.oid, relname, rel.reltablespace AS spcoid, spcname,
pg_get_userbyid(relowner)AS relowner, relacl, relhasoids,<p class="MsoNormal">relhassubclass, reltuples, description,
conname,conkey,<p class="MsoNormal">EXISTS(select 1 FROM pg_trigger JOIN pg_proc pt ON pt.oid=tgfoid AND<p
class="MsoNormal"> pt.proname='logtrigger' JOIN<p class="MsoNormal"> pg_proc pc ON pc.pronamespace=pt.pronamespace<p
class="MsoNormal"> --AND pc.proname='slonyversion'<p class="MsoNormal"> WHERE tgrelid=rel.oid) AS isrepl,<p
class="MsoNormal">WHEREtgrelid=rel.oid) AS isrepl,<p class="MsoNormal">--(select count(*) FROM pg_trigger WHERE
tgrelid=rel.oid AND tgisconstraint = FALSE) AS triggercount,<p class="MsoNormal">
substring(array_to_string(rel.reloptions,',') from 'fillfactor=([0-9]*)') AS fillfactor, gpd.localoid, gpd.attrnums,<p
class="MsoNormal"> substring(array_to_string(rel.reloptions, ',') from 'appendonly=([a-z]*)') AS appendonly,<p
class="MsoNormal"> substring(array_to_string(rel.reloptions, ',') from 'compresslevel=([0-9]*)') AS compresslevel,<p
class="MsoNormal"> substring(array_to_string(rel.reloptions, ',') from 'compresstype=([a-z0-9]*)') AS compresstype,<p
class="MsoNormal"> substring(array_to_string(rel.reloptions, ',') from 'orientation=([a-z]*)') AS orientation,<p
class="MsoNormal"> substring(array_to_string(reloptions, ',') from 'blocksize=([0-9]*)') AS blocksize,<p
class="MsoNormal"> substring(array_to_string(rel.reloptions, ',') from 'compresstype=([a-z0-9]*)') AS compresstype,<p
class="MsoNormal"> substring(array_to_string(reloptions, ',') from 'blocksize=([0-9]*)') AS blocksize,<p
class="MsoNormal"> substring(array_to_string(reloptions, ',') from 'checksum=([a-z]*)') AS checksum,<p
class="MsoNormal"> rel.oid in (select parrelid from pg_partition) as ispartitioned<p class="MsoNormal"> FROM
pg_classrel<p class="MsoNormal"> LEFT OUTER JOIN pg_tablespace ta on ta.oid=rel.reltablespace<p
class="MsoNormal"> LEFT OUTER JOIN pg_description des ON (des.objoid=rel.oid AND des.objsubid=0)<p
class="MsoNormal"> LEFT OUTER JOIN pg_description des ON (des.objoid=rel.oid AND des.objsubid=0)<p
class="MsoNormal"> LEFT OUTER JOIN pg_constraint c ON c.conrelid=rel.oid AND c.contype='p'<p
class="MsoNormal"> LEFT OUTER JOIN gp_distribution_policy gpd ON gpd.localoid=rel.oid<p class="MsoNormal">
WHERErelkind IN ('r','s','t') AND relnamespace = 2200::oid AND rel.relstorage <> 'x'<p class="MsoNormal">
andrel.oid NOT IN (select parchildrelid from pg_partition_rule)ORDER BY relname;<p class="MsoNormal"> <p
class="MsoNormal"style="line-height:15.6pt"><span style="font-size:10.0pt;font-family:"Courier New";color:black">QUERY
PLAN </span><p class="MsoNormal"
style="line-height:15.6pt"><spanstyle="font-size:10.0pt;font-family:"Courier
New";color:black">--------------------------------------------------------------------------------------------------------------------------------------------------------------------</span><p
class="MsoNormal"style="line-height:15.6pt"><span style="font-size:10.0pt;font-family:"Courier New";color:black">Sort
(cost=1110150119.39..1110162681.63rows=5024898 width=358)</span><p class="MsoNormal" style="line-height:15.6pt"><span
style="font-size:10.0pt;font-family:"CourierNew";color:black"> Sort Key: rel.relname</span><p class="MsoNormal"
style="line-height:15.6pt"><spanstyle="font-size:10.0pt;font-family:"Courier New";color:black"> Rows out: 1294 rows
with2923 ms to end, start offset by 0.468 ms.</span><p class="MsoNormal" style="line-height:15.6pt"><span
style="font-size:10.0pt;font-family:"CourierNew";color:black"> Executor memory: 553K bytes.</span><p
class="MsoNormal"style="line-height:15.6pt"><span style="font-size:10.0pt;font-family:"Courier New";color:black">
Work_memused: 553K bytes.</span><p class="MsoNormal" style="line-height:15.6pt"><span
style="font-size:10.0pt;font-family:"CourierNew";color:black"> -> Hash Left Anti Semi Join
(cost=8220415.44..1109590831.59rows=5024898 width=358)</span><p class="MsoNormal" style="line-height:15.6pt"><span
style="font-size:10.0pt;font-family:"CourierNew";color:black"> Hash Cond: rel.oid = </span><span
style="font-size:10.0pt;font-family:"CourierNew";color:#009100">"NotIn_SUBQUERY"</span><span
style="font-size:10.0pt;font-family:"CourierNew";color:black">.parchildrelid</span><p class="MsoNormal"
style="line-height:15.6pt"><spanstyle="font-size:10.0pt;font-family:"Courier New";color:black"> Rows out: 1294
rowswith 203 ms to first row, 2919 ms to end, start offset by 0.546 ms.</span><p class="MsoNormal"
style="line-height:15.6pt"><spanstyle="font-size:10.0pt;font-family:"Courier New";color:black"> Executor
memory: 2K bytes.</span><p class="MsoNormal" style="line-height:15.6pt"><span
style="font-size:10.0pt;font-family:"CourierNew";color:black"> Work_mem used: 2K bytes.</span><p
class="MsoNormal"style="line-height:15.6pt"><span style="font-size:10.0pt;font-family:"Courier
New";color:black"> Work_mem wanted: 1731K bytes to lessen workfile I/O.</span><p class="MsoNormal"
style="line-height:15.6pt"><spanstyle="font-size:10.0pt;font-family:"Courier New";color:black"> Initial batches
1..2047:</span><pclass="MsoNormal" style="line-height:15.6pt"><span style="font-size:10.0pt;font-family:"Courier
New";color:black"> Read 503828107042K bytes from </span><span style="font-size:10.0pt;font-family:"Courier
New";color:#000091">outer</span><spanstyle="font-size:10.0pt;font-family:"Courier New";color:black"> workfile:
246129999Kavg x 2047 nonempty batches, 246129999K max.</span><p class="MsoNormal" style="line-height:15.6pt"><span
style="font-size:10.0pt;font-family:"CourierNew";color:black"> Hash chain length 1.0 avg, 2 max, using 73819 of
268515328buckets.</span><p class="MsoNormal" style="line-height:15.6pt"><span
style="font-size:10.0pt;font-family:"CourierNew";color:black"> -> Hash Left Join
(cost=90867.76..1666327.73rows=5024921 width=358)</span><p class="MsoNormal" style="line-height:15.6pt"><span
style="font-size:10.0pt;font-family:"CourierNew";color:black"> Hash Cond: rel.oid = des.objoid</span><p
class="MsoNormal"style="line-height:15.6pt"><span style="font-size:10.0pt;font-family:"Courier
New";color:black"> Rows out: 75114 rows with 81 ms to first row, 317 ms to end, start offset by 118
ms.</span><pclass="MsoNormal" style="line-height:15.6pt"><span style="font-size:10.0pt;font-family:"Courier
New";color:black"> Executor memory: 117K bytes.</span><p class="MsoNormal"
style="line-height:15.6pt"><spanstyle="font-size:10.0pt;font-family:"Courier New";color:black"> Work_mem
used: 117K bytes.</span><p class="MsoNormal" style="line-height:15.6pt"><span
style="font-size:10.0pt;font-family:"CourierNew";color:black"> Hash chain length 1.0 avg, 1 max, using
2234of 65539 buckets.</span><p class="MsoNormal" style="line-height:15.6pt"><span
style="font-size:10.0pt;font-family:"CourierNew";color:black"> -> Hash Left Join
(cost=88321.58..1639499.25rows=5024921 width=334)</span><p class="MsoNormal" style="line-height:15.6pt"><span
style="font-size:10.0pt;font-family:"CourierNew";color:black"> Hash Cond: rel.oid =
c.conrelid</span><pclass="MsoNormal" style="line-height:15.6pt"><span style="font-size:10.0pt;font-family:"Courier
New";color:black"> Rows out: 75114 rows with 80 ms to first row, 296 ms to end, start offset by 118
ms.</span><pclass="MsoNormal" style="line-height:15.6pt"><span style="font-size:10.0pt;font-family:"Courier
New";color:black"> -> Hash Left Join (cost=85504.62..1623556.67 rows=5024921
width=247)</span><pclass="MsoNormal" style="line-height:15.6pt"><span style="font-size:10.0pt;font-family:"Courier
New";color:black"> Hash Cond: rel.oid = gpd.localoid</span><p class="MsoNormal"
style="line-height:15.6pt"><spanstyle="font-size:10.0pt;font-family:"Courier
New";color:black"> Rows out: 75114 rows with 38 ms to first row, 236 ms to end, start offset
by118 ms.</span><p class="MsoNormal" style="line-height:15.6pt"><span style="font-size:10.0pt;font-family:"Courier
New";color:black"> Executor memory: 136K bytes.</span><p class="MsoNormal"
style="line-height:15.6pt"><spanstyle="font-size:10.0pt;font-family:"Courier
New";color:black"> Work_mem used: 136K bytes.</span><p class="MsoNormal"
style="line-height:15.6pt"><spanstyle="font-size:10.0pt;font-family:"Courier
New";color:black"> Work_mem wanted: 4107K bytes to lessen workfile I/O.</span><p
class="MsoNormal"style="line-height:15.6pt"><span style="font-size:10.0pt;font-family:"Courier
New";color:black"> Initial batch 0:</span><p class="MsoNormal"
style="line-height:15.6pt"><spanstyle="font-size:10.0pt;font-family:"Courier
New";color:black"> Wrote 2976K bytes to </span><span
style="font-size:10.0pt;font-family:"CourierNew";color:#000091">inner</span><span
style="font-size:10.0pt;font-family:"CourierNew";color:black"> workfile.</span><p class="MsoNormal"
style="line-height:15.6pt"><spanstyle="font-size:10.0pt;font-family:"Courier
New";color:black"> Wrote 6880K bytes to </span><span
style="font-size:10.0pt;font-family:"CourierNew";color:#000091">outer</span><span
style="font-size:10.0pt;font-family:"CourierNew";color:black"> workfile.</span><p class="MsoNormal"
style="line-height:15.6pt"><spanstyle="font-size:10.0pt;font-family:"Courier
New";color:black"> Initial batches 1..31:</span><p class="MsoNormal"
style="line-height:15.6pt"><spanstyle="font-size:10.0pt;font-family:"Courier
New";color:black"> Read 2976K bytes from </span><span
style="font-size:10.0pt;font-family:"CourierNew";color:#000091">inner</span><span
style="font-size:10.0pt;font-family:"CourierNew";color:black"> workfile: 96K avg x 31 nonempty batches, 96K
max.</span><pclass="MsoNormal" style="line-height:15.6pt"><span style="font-size:10.0pt;font-family:"Courier
New";color:black"> Read 7630029956K bytes from </span><span
style="font-size:10.0pt;font-family:"CourierNew";color:#000091">outer</span><span
style="font-size:10.0pt;font-family:"CourierNew";color:black"> workfile: 246129999K avg x 31 nonempty batches,
246129999Kmax.</span><p class="MsoNormal" style="line-height:15.6pt"><span style="font-size:10.0pt;font-family:"Courier
New";color:black"> Hash chain length 1.0 avg, 3 max, using 73462 of 2097248 buckets.</span><p
class="MsoNormal"style="line-height:15.6pt"><span style="font-size:10.0pt;font-family:"Courier
New";color:black"> -> Hash Left Join (cost=3.27..1149164.86 rows=5024921
width=218)</span><pclass="MsoNormal" style="line-height:15.6pt"><span style="font-size:10.0pt;font-family:"Courier
New";color:black"> Hash Cond: rel.reltablespace = ta.oid</span><p class="MsoNormal"
style="line-height:15.6pt"><spanstyle="font-size:10.0pt;font-family:"Courier New";color:black">
Rowsout: 75114 rows with 0.264 ms to first row, 112 ms to end, start offset by 118 ms.</span><p
class="MsoNormal"style="line-height:15.6pt"><span style="font-size:10.0pt;font-family:"Courier
New";color:black"> Executor memory: 1K bytes.</span><p class="MsoNormal"
style="line-height:15.6pt"><spanstyle="font-size:10.0pt;font-family:"Courier
New";color:black"> Work_mem used: 1K bytes.</span><p class="MsoNormal"
style="line-height:15.6pt"><spanstyle="font-size:10.0pt;font-family:"Courier
New";color:black"> Hash chain length 1.0 avg, 1 max, using 2 of 16417 buckets.</span><p
class="MsoNormal"style="line-height:15.6pt"><span style="font-size:10.0pt;font-family:"Courier
New";color:black"> -> Seq Scan on pg_class rel (cost=0.00..5433.94 rows=5024921
width=154)</span><pclass="MsoNormal" style="line-height:15.6pt"><span style="font-size:10.0pt;font-family:"Courier
New";color:black"> Filter: (relkind = ANY ('{r,s,t}'::</span><span
style="font-size:10.0pt;font-family:"CourierNew";color:#009100">"</span><span
style="font-size:10.0pt;font-family:"CourierNew";color:#910091">char</span><span
style="font-size:10.0pt;font-family:"CourierNew";color:#009100">"</span><span
style="font-size:10.0pt;font-family:"CourierNew";color:black">[])) AND relnamespace = 2200::oid AND relstorage <>
'x'::</span><spanstyle="font-size:10.0pt;font-family:"Courier New";color:#009100">"</span><span
style="font-size:10.0pt;font-family:"CourierNew";color:#910091">char</span><span
style="font-size:10.0pt;font-family:"CourierNew";color:#009100">"</span><span
style="font-size:10.0pt;font-family:"CourierNew";color:black"> AND oid IS NOT NULL</span><p class="MsoNormal"
style="line-height:15.6pt"><spanstyle="font-size:10.0pt;font-family:"Courier
New";color:black"> Rows out: 75114 rows with 0.133 ms to first row, 95 ms to end,
startoffset by 118 ms.</span><p class="MsoNormal" style="line-height:15.6pt"><span
style="font-size:10.0pt;font-family:"CourierNew";color:black"> -> Hash
(cost=1.02..1.02rows=2 width=68)</span><p class="MsoNormal" style="line-height:15.6pt"><span
style="font-size:10.0pt;font-family:"CourierNew";color:black"> Rows in: 2 rows
with0.038 ms to end, start offset by 118 ms.</span><p class="MsoNormal" style="line-height:15.6pt"><span
style="font-size:10.0pt;font-family:"CourierNew";color:black"> -> Seq Scan on
pg_tablespaceta (cost=0.00..1.02 rows=180 width=68)</span><p class="MsoNormal" style="line-height:15.6pt"><span
style="font-size:10.0pt;font-family:"CourierNew";color:black"> Rows out: 2
rowswith 0.033 ms to first row, 0.034 ms to end, start offset by 118 ms.</span><p class="MsoNormal"
style="line-height:15.6pt"><spanstyle="font-size:10.0pt;font-family:"Courier
New";color:black"> -> Hash (cost=890.10..890.10 rows=75210 width=29)</span><p
class="MsoNormal"style="line-height:15.6pt"><span style="font-size:10.0pt;font-family:"Courier
New";color:black"> Rows in: 75118 rows with 37 ms to end, start offset by 118
ms.</span><pclass="MsoNormal" style="line-height:15.6pt"><span style="font-size:10.0pt;font-family:"Courier
New";color:black"> -> Seq Scan on gp_distribution_policy gpd (cost=0.00..890.10
rows=6768900width=29)</span><p class="MsoNormal" style="line-height:15.6pt"><span
style="font-size:10.0pt;font-family:"CourierNew";color:black"> Rows out: 75118
rowswith 0.125 ms to first row, 19 ms to end, start offset by 118 ms.</span><p class="MsoNormal"
style="line-height:15.6pt"><spanstyle="font-size:10.0pt;font-family:"Courier New";color:black">
-> Hash (cost=2815.84..2815.84 rows=1 width=91)</span><p class="MsoNormal" style="line-height:15.6pt"><span
style="font-size:10.0pt;font-family:"CourierNew";color:black"> Rows in: 0 rows with 42 ms to
end,start offset by 156 ms.</span><p class="MsoNormal" style="line-height:15.6pt"><span
style="font-size:10.0pt;font-family:"CourierNew";color:black"> -> Seq Scan on
pg_constraintc (cost=0.00..2815.84 rows=90 width=91)</span><p class="MsoNormal" style="line-height:15.6pt"><span
style="font-size:10.0pt;font-family:"CourierNew";color:black"> Filter: contype =
'p'::</span><spanstyle="font-size:10.0pt;font-family:"Courier New";color:#009100">"</span><span
style="font-size:10.0pt;font-family:"CourierNew";color:#910091">char</span><span
style="font-size:10.0pt;font-family:"CourierNew";color:#009100">"</span><span
style="font-size:10.0pt;font-family:"CourierNew";color:black"></span><p class="MsoNormal"
style="line-height:15.6pt"><spanstyle="font-size:10.0pt;font-family:"Courier
New";color:black"> Rows out: 0 rows with 42 ms to end, start offset by 156 ms.</span><p
class="MsoNormal"style="line-height:15.6pt"><span style="font-size:10.0pt;font-family:"Courier
New";color:black"> -> Hash (cost=32.92..32.92 rows=2234 width=28)</span><p class="MsoNormal"
style="line-height:15.6pt"><spanstyle="font-size:10.0pt;font-family:"Courier New";color:black">
Rowsin: 2234 rows with 0.942 ms to end, start offset by 198 ms.</span><p class="MsoNormal"
style="line-height:15.6pt"><spanstyle="font-size:10.0pt;font-family:"Courier New";color:black">
-> Seq Scan on pg_description des (cost=0.00..32.92 rows=201060 width=28)</span><p class="MsoNormal"
style="line-height:15.6pt"><spanstyle="font-size:10.0pt;font-family:"Courier
New";color:black"> Filter: objsubid = 0</span><p class="MsoNormal"
style="line-height:15.6pt"><spanstyle="font-size:10.0pt;font-family:"Courier
New";color:black"> Rows out: 2234 rows with 0.041 ms to first row, 0.489 ms to end, start
offsetby 198 ms.</span><p class="MsoNormal" style="line-height:15.6pt"><span
style="font-size:10.0pt;font-family:"CourierNew";color:black"> -> Hash (cost=68287.68..68287.68
rows=6646320width=4)</span><p class="MsoNormal" style="line-height:15.6pt"><span
style="font-size:10.0pt;font-family:"CourierNew";color:black"> Rows in: 73820 rows with 116 ms to end,
startoffset by 1.468 ms.</span><p class="MsoNormal" style="line-height:15.6pt"><span
style="font-size:10.0pt;font-family:"CourierNew";color:black"> -> Subquery Scan </span><span
style="font-size:10.0pt;font-family:"CourierNew";color:#009100">"NotIn_SUBQUERY"</span><span
style="font-size:10.0pt;font-family:"CourierNew";color:black"> (cost=0.00..68287.68 rows=598168800 width=4)</span><p
class="MsoNormal"style="line-height:15.6pt"><span style="font-size:10.0pt;font-family:"Courier
New";color:black"> Rows out: 73820 rows with 0.029 ms to first row, 37 ms to end, start offset by
1.468ms.</span><p class="MsoNormal" style="line-height:15.6pt"><span style="font-size:10.0pt;font-family:"Courier
New";color:black"> -> Seq Scan on pg_partition_rule (cost=0.00..1824.48 rows=6646320
width=4)</span><pclass="MsoNormal" style="line-height:15.6pt"><span style="font-size:10.0pt;font-family:"Courier
New";color:black"> Rows out: 73820 rows with 0.027 ms to first row, 25 ms to end, start
offsetby 1.469 ms.</span><p class="MsoNormal" style="line-height:15.6pt"><span
style="font-size:10.0pt;font-family:"CourierNew";color:black"> SubPlan 2</span><p class="MsoNormal"
style="line-height:15.6pt"><spanstyle="font-size:10.0pt;font-family:"Courier New";color:black"> ->
Materialize</span><span style="font-size:10.0pt;font-family:"Courier New";color:#000091">for</span><span
style="font-size:10.0pt;font-family:"CourierNew";color:black"> deadlock safety (cost=134.00..1295.00 rows=116100
width=4)</span><pclass="MsoNormal" style="line-height:15.6pt"><span style="font-size:10.0pt;font-family:"Courier
New";color:black"> Rows out: 837855 rows with 0.454 ms to first row, 63 ms to end of 1294 scans, start
offsetby 2922 ms.</span><p class="MsoNormal" style="line-height:15.6pt"><span
style="font-size:10.0pt;font-family:"CourierNew";color:black"> -> Seq Scan on pg_partition
(cost=0.00..17.90rows=116100 width=4)</span><p class="MsoNormal" style="line-height:15.6pt"><span
style="font-size:10.0pt;font-family:"CourierNew";color:black"> Rows out: 1290 rows with 0.036 ms
tofirst row, 0.296 ms to end, start offset by 203 ms.</span><p class="MsoNormal" style="line-height:15.6pt"><span
style="font-size:10.0pt;font-family:"CourierNew";color:black"> SubPlan 1</span><p class="MsoNormal"
style="line-height:15.6pt"><spanstyle="font-size:10.0pt;font-family:"Courier New";color:black"> -> Hash
Join (cost=57.77..141.63 rows=354 width=0)</span><p class="MsoNormal" style="line-height:15.6pt"><span
style="font-size:10.0pt;font-family:"CourierNew";color:black"> Hash Cond: pt.oid =
pg_trigger.tgfoid</span><pclass="MsoNormal" style="line-height:15.6pt"><span
style="font-size:10.0pt;font-family:"CourierNew";color:black"> Rows out: 0 rows with 0.336 ms to first
row,150 ms to end of 1294 scans, start offset by 2922 ms.</span><p class="MsoNormal" style="line-height:15.6pt"><span
style="font-size:10.0pt;font-family:"CourierNew";color:black"> -> Hash Join (cost=55.59..138.64
rows=299width=4)</span><p class="MsoNormal" style="line-height:15.6pt"><span
style="font-size:10.0pt;font-family:"CourierNew";color:black"> Hash Cond: pt.pronamespace =
pc.pronamespace</span><pclass="MsoNormal" style="line-height:15.6pt"><span style="font-size:10.0pt;font-family:"Courier
New";color:black"> Rows out: 0 rows with 0 ms to end.</span><p class="MsoNormal"
style="line-height:15.6pt"><spanstyle="font-size:10.0pt;font-family:"Courier New";color:black">
-> Seq Scan on pg_proc pt (cost=0.00..54.25 rows=108 width=8)</span><p class="MsoNormal"
style="line-height:15.6pt"><spanstyle="font-size:10.0pt;font-family:"Courier
New";color:black"> Filter: proname = 'logtrigger'::name</span><p class="MsoNormal"
style="line-height:15.6pt"><spanstyle="font-size:10.0pt;font-family:"Courier
New";color:black"> Rows out: 0 rows with 0 ms to end.</span><p class="MsoNormal"
style="line-height:15.6pt"><spanstyle="font-size:10.0pt;font-family:"Courier New";color:black">
-> Hash (cost=54.25..54.25 rows=2 width=4)</span><p class="MsoNormal" style="line-height:15.6pt"><span
style="font-size:10.0pt;font-family:"CourierNew";color:black"> Rows in: 0 rows with 0 ms
toend.</span><p class="MsoNormal" style="line-height:15.6pt"><span style="font-size:10.0pt;font-family:"Courier
New";color:black"> -> Seq Scan on pg_proc pc (cost=0.00..54.25 rows=108
width=4)</span><pclass="MsoNormal" style="line-height:15.6pt"><span style="font-size:10.0pt;font-family:"Courier
New";color:black"> Filter: proname = 'slonyversion'::name</span><p class="MsoNormal"
style="line-height:15.6pt"><spanstyle="font-size:10.0pt;font-family:"Courier
New";color:black"> Rows out: 0 rows with 0 ms to end.</span><p class="MsoNormal"
style="line-height:15.6pt"><spanstyle="font-size:10.0pt;font-family:"Courier New";color:black"> ->
Hash (cost=1.05..1.05 rows=1 width=4)</span><p class="MsoNormal" style="line-height:15.6pt"><span
style="font-size:10.0pt;font-family:"CourierNew";color:black"> Rows in: 0 rows with 0.013 ms to
firstrow, 7.590 ms to end of 1294 scans, start offset by 2922 ms.</span><p class="MsoNormal"
style="line-height:15.6pt"><spanstyle="font-size:10.0pt;font-family:"Courier
New";color:black"> -> Seq Scan on pg_trigger (cost=0.00..1.05 rows=90 width=4)</span><p
class="MsoNormal"style="line-height:15.6pt"><span style="font-size:10.0pt;font-family:"Courier
New";color:black"> Filter: tgrelid = $0</span><p class="MsoNormal"
style="line-height:15.6pt"><spanstyle="font-size:10.0pt;font-family:"Courier
New";color:black"> Rows out: 0 rows with 0.008 ms to first row, 5.616 ms to end of 1294
scans,start offset by 2922 ms.</span><p class="MsoNormal" style="line-height:15.6pt"><span
style="font-size:10.0pt;font-family:"CourierNew";color:black">Slice statistics:</span><p class="MsoNormal"
style="line-height:15.6pt"><spanstyle="font-size:10.0pt;font-family:"Courier New";color:black"> (slice0) * Executor
memory:7340K bytes. Work_mem: 553K bytes max, 4107K bytes wanted.</span><p class="MsoNormal"
style="line-height:15.6pt"><spanstyle="font-size:10.0pt;font-family:"Courier New";color:black">Statement
statistics:</span><pclass="MsoNormal" style="line-height:15.6pt"><span style="font-size:10.0pt;font-family:"Courier
New";color:black"> Memory used: 128000K bytes</span><p class="MsoNormal" style="line-height:15.6pt"><span
style="font-size:10.0pt;font-family:"CourierNew";color:black"> Memory wanted: 38754K bytes</span><p class="MsoNormal"
style="line-height:15.6pt"><spanstyle="font-size:10.0pt;font-family:"Courier New";color:black">Total runtime: 2923.225
ms</span><pclass="MsoNormal" style="line-height:15.6pt"><span style="font-size:10.0pt;font-family:"Courier
New";color:black">(100rows)</span><p class="MsoNormal"> <p class="MsoNormal"> <p class="MsoNormal">Greenplum Dev team
hasconfirm this high cost is caused by correlated subquery. Using join instead of correlated subquery can avoid this
highcost issue. Please let us know if you can rewrite those query for catalog tables. Thank you.<p
class="MsoNormal">Environmentas below : <p class="MsoNormal">pgAdmin III 1.16.1 for windows.<p
class="MsoNormal">GreenplumDB 4.2.3.0 for Linux.<p class="MsoNormal"> <p class="MsoNormal"> <p class="MsoNormal"> <p
class="MsoNormal"> <pclass="MsoNormal" style="text-autospace:none"><span style="color:#244061">Regards,</span><b><span
style="font-size:12.0pt;color:#244061"></span></b><pclass="MsoNormal" style="text-autospace:none"><b><span
style="font-size:12.0pt;color:#244061">ShawnYan</span></b><p class="MsoNormal" style="text-autospace:none"><b><span
style="font-size:10.0pt;color:#244061">TechnicalSupport Engineer</span></b><p class="MsoNormal"
style="text-autospace:none"><spanstyle="color:#244061"> </span><p class="MsoNormal" style="text-autospace:none"><span
style="color:#1F497D">GlobalServices Customer Services </span><span style="color:#244061"> �C VTSG Greenplum</span><p
class="MsoNormal"style="text-autospace:none"><span style="color:#244061">Office Hours: Sunday - Thursday, 19:00 to
04:00hrs EST</span><p class="MsoNormal" style="text-autospace:none"><span
style="color:#244061">Phone :</span><spanlang="EN-AU" style="color:#244061"> +1 800-782-4362 ext 7631019
(Global)</span><p class="MsoNormal" style="text-autospace:none"><span lang="EN-AU"
style="color:#244061"> : </span><span lang="ZH-CN" style="font-family:"MS
Mincho";color:#244061">中文</span><spanlang="ZH-CN" style="font-family:"PMingLiU","serif";color:#244061">热线</span><span
lang="EN-AU"style="color:#244061"> 800-819-0009 (</span><span lang="ZH-CN" style="font-family:"MS
Mincho";color:#244061">分机</span><spanlang="EN-AU" style="color:#244061">7631019)</span><p class="MsoNormal"
style="text-autospace:none"><spanlang="EN-AU" style="color:#244061">
400-670-0009</span><pclass="MsoNormal" style="text-autospace:none"><span style="color:#244061">Email : <a
href="mailto:your.email@emc.com"><spanstyle="color:blue">shawn.yan@emc.com</span></a> </span><p class="MsoNormal"
style="text-autospace:none"><spanstyle="color:#244061"> </span><p class="MsoNormal"><span
style="font-size:9.0pt;font-family:"Tahoma","sans-serif";color:black">Toescalate your issue or to provide feedback on
yourGreenplum Support experience:</span><p class="MsoNormal"><span
style="font-size:9.0pt;font-family:"Tahoma","sans-serif";color:black">Pleaseemail my Manager </span><b><span
style="font-size:9.0pt;font-family:"Tahoma","sans-serif";color:#17375E">MarkChu </span></b><span
style="font-size:9.0pt;font-family:"Tahoma","sans-serif";color:black"> </span><span
style="font-size:9.0pt;font-family:"Tahoma","sans-serif";color:#17375E"><ahref="mailto:mark.chu@emc.com"><span
style="color:blue">mark.chu@emc.com</span></a></span><span
style="font-size:9.0pt;font-family:"Tahoma","sans-serif";color:black"></span><pclass="MsoNormal"><span
style="font-size:9.0pt;font-family:"Tahoma","sans-serif";color:black"> </span><pclass="MsoNormal"><span
style="font-size:9.0pt;font-family:"Tahoma","sans-serif";color:black">Outof Hours:</span><p class="MsoNormal"
style="margin-bottom:12.0pt"><spanlang="EN-IE" style="font-size:9.0pt;font-family:"Tahoma","sans-serif"">Via the
Greenplum ManagerOn Duty<br />United States +1 800 782 4362<br />Worldwide +1 508497 7901</span><p
class="MsoNormal"> </div>
pgadmin-support by date: