QUERY PLAN
Sort (cost=57.74..57.75 rows=1 width=504)
Sort Key: a.attnum
-> Nested Loop Left Join (cost=1.53..57.73 rows=1 width=504)
Join Filter: (ct.conrelid = c.oid)
-> Nested Loop Left Join (cost=1.53..41.83 rows=1 width=1472)
Join Filter: ((t.typndims > 0) AND (t.typbasetype > '0'::oid))
-> Nested Loop Left Join (cost=1.38..41.53 rows=1 width=1407)
Join Filter: ((((a.attndims > 0) OR (t.typcategory = 'A'::"char")) AND (t.typelem > '0'::oid) AND (t.typelem = tb.oid)) OR ((t.typbasetype > '0'::oid) AND (t.typbasetype = tb.oid)))
-> Nested Loop (cost=0.85..28.00 rows=1 width=1334)
-> Nested Loop Left Join (cost=0.70..27.80 rows=1 width=476)
-> Nested Loop (cost=0.55..27.60 rows=1 width=444)
-> Nested Loop (cost=0.27..9.38 rows=1 width=132)
Join Filter: (c.relnamespace = d.oid)
-> Index Scan using pg_class_relname_nsp_index on pg_class c (cost=0.27..8.29 rows=1 width=72)
Index Cond: (relname = 'catalog'::name)
-> Seq Scan on pg_namespace d (cost=0.00..1.07 rows=1 width=68)
Filter: (nspname = 'eservice'::name)
-> Index Scan using pg_attribute_relid_attnum_index on pg_attribute a (cost=0.28..18.16 rows=6 width=312)
Index Cond: ((attrelid = c.oid) AND (attnum > 0))
Filter: (NOT attisdropped)
-> Index Scan using pg_attrdef_adrelid_adnum_index on pg_attrdef ad (cost=0.15..0.19 rows=1 width=38)
Index Cond: ((a.attrelid = adrelid) AND (a.attnum = adnum))
-> Index Scan using pg_type_oid_index on pg_type t (cost=0.15..0.19 rows=1 width=862)
Index Cond: (oid = a.atttypid)
Filter: (typname <> ''::name)
-> Bitmap Heap Scan on pg_type tb (cost=0.53..4.55 rows=359 width=77)
Recheck Cond: ((t.typelem = oid) OR (t.typbasetype = oid))
-> BitmapOr (cost=0.53..0.53 rows=2 width=0)
-> Bitmap Index Scan on pg_type_oid_index (cost=0.00..0.18 rows=1 width=0)
Index Cond: (t.typelem = oid)
-> Bitmap Index Scan on pg_type_oid_index (cost=0.00..0.18 rows=1 width=0)
Index Cond: (t.typbasetype = oid)
-> Index Scan using pg_type_oid_index on pg_type td (cost=0.15..0.29 rows=1 width=73)
Index Cond: (tb.typelem = oid)
-> Seq Scan on pg_constraint ct (cost=0.00..1.02 rows=1 width=36)
Filter: (contype = 'p'::"char")
SubPlan 1
-> Seq Scan on pg_namespace (cost=0.00..1.07 rows=1 width=64)
Filter: (oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace))
SubPlan 2
-> Aggregate (cost=12.65..12.66 rows=1 width=32)
-> Bitmap Heap Scan on pg_enum (cost=4.18..12.64 rows=4 width=64)
Recheck Cond: (enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))
-> Bitmap Index Scan on pg_enum_typid_sortorder_index (cost=0.00..4.18 rows=4 width=0)
Index Cond: (enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))