Unique  (cost=1.06..1.10 rows=1 width=594) (actual time=7.00..7.00 rows=2 loops=1)
   ->  Sort  (cost=1.06..1.07 rows=1 width=594) (actual time=7.00..7.00 rows=2 loops=1)
         Sort Key: c.relname, a.attnum, n.nspname, n2.nspname, c2.relname, t.tgconstrname, ic.relname, t.tgdeferrable, t.tginitdeferred, t.tgnargs, t.tgargs, p1.proname, p2.proname
         ->  Merge Join  (cost=1.03..1.05 rows=1 width=594) (actual time=5.00..6.00 rows=2 loops=1)
               Merge Cond: ("outer".tgconstrrelid = "inner".tgconstrrelid)
               Join Filter: (("outer".indrelid = "inner".tgrelid) AND ("inner".tgfoid = "outer".oid))
               ->  Nested Loop  (cost=0.00..85.31 rows=1 width=510) (actual time=4.00..6.00 rows=12 loops=1)
                     Join Filter: ("inner".relnamespace = "outer".oid)
                     ->  Nested Loop  (cost=0.00..63.49 rows=4 width=438) (actual time=3.00..4.00 rows=48 loops=1)
                           ->  Nested Loop  (cost=0.00..62.41 rows=1 width=370) (actual time=3.00..3.00 rows=12 loops=1)
                                 Join Filter: (("inner".tgconstrrelid = "outer".oid) AND ("outer".relnamespace = "inner".oid))
                                 ->  Index Scan using pg_class_oid_index on pg_class c2  (cost=0.00..15.67 rows=1 width=72) (actual time=1.00..1.00 rows=1 loops=1)
                                       Filter: (relname = 'users'::name)
                                 ->  Materialize  (cost=46.67..46.67 rows=4 width=298) (actual time=2.00..2.00 rows=48 loops=1)
                                       ->  Nested Loop  (cost=0.00..46.67 rows=4 width=298) (actual time=1.00..2.00 rows=48 loops=1)
                                             ->  Nested Loop  (cost=0.00..45.59 rows=1 width=230) (actual time=1.00..1.00 rows=12 loops=1)
                                                   Join Filter: ("inner".tgfoid = "outer".oid)
                                                   ->  Index Scan using pg_proc_proname_args_nsp_index on pg_proc p2  (cost=0.00..5.97 rows=1 width=68) (actual time=0.00..0.00 rows=5 loops=1)
                                                         Index Cond: ((proname > = 'RI'::name) AND (proname < 'RJ'::name))
                                                         Filter: (proname ~~ 'RI _FKey_%_del'::text)
                                                   ->  Materialize  (cost=39.54..39.54 rows=7 width=162) (actual time=0.20..0.20 rows=36 loops=5)
                                                         ->  Nested Loop  (cost=0.00..39.54 rows=7 width=162) (actual time=1.00..1.00 rows=36 loops=1)
                                                               ->  Index Scan using pg_proc_proname_args_nsp_index on pg_proc p1  (cost=0.00..5.97 rows=1 width=68) (actual time=0.00..0.00 rows=6 loops=1)
                                                                     Index Cond: ((proname >= 'RI'::name) AND (proname < 'RJ'::name))
                                                                     Filter: (proname ~~ 'RI_FKey_%_upd'::text)
                                                               ->  Materialize (cost=33.50..33.50 rows=7 width=94) (actual time=0.17..0.17 rows=6 loops=6)
                                                                     ->  Nested Loop  (cost=0.00..33.50 rows=7 width=94) (actual time=1.00..1.00 rows=6 loops=1)
                                                                           Join Filter: ("outer".oid = "inner".attrelid)
                                                                           ->  Merge Join  (cost=0.00..15.13 rows=1 width=88) (actual time=0.00..0.00 rows=6 loops=1)
                                                                                 Merge Cond: ("outer".indrelid = "inner".tgrelid)
                                                                                 ->  Nested Loop  (cost=0.00..58.89 rows=9 width=76) (actual time=0.00..0.00 rows=15 loops=1)
                                                                                       ->  Index Scan using pg_index_indrelid_index on pg_index i  (cost=0.00..9.80 rows=9 width=8) (actual time=0.00..0.00 rows=15 loops=1)
                                                                                             Filter: indisprimary
                                                                                       ->  Index Scan using pg_class_oid_index on pg_class ic  (cost=0.00..5.44 rows=1 width=68) (actual time=0.00..0.00 rows=1 loops=15)
                                                                                             Index Cond: ("outer".indexrelid = ic.oid)
                                                                                 ->  Index Scan using pg_trigger_tgrelid_tgname_index on pg_trigger t1  (cost=0.00..5.27 rows=1 width=12) (actual time=0.00..0.00 rows=6 loops=1)
                                                                                       Filter: tgisconstraint
                                                                           ->  Index Scan using pg_attribute_relid_attnum_index on pg_attribute a  (cost=0.00..18.29 rows=7 width=6) (actual time=0.00..0.00 rows=1 loops=6)
                                                                                 Index Cond: (a.attrelid = "outer".indexrelid)
                                             ->  Seq Scan on pg_namespace n2  (cost=0.00..1.04 rows=4 width=68) (actual time=0.00..0.00 rows=4 loops=12)
                           ->  Seq Scan on pg_namespace n  (cost=0.00..1.04 rows=4 width=68) (actual time=0.08..0.08 rows=4 loops=12)
                     ->  Index Scan using pg_class_oid_index on pg_class c  (cost=0.00..5.44 rows=1 width=72) (actual time=0.02..0.04 rows=1 loops=48)
                           Index Cond: ("outer".indrelid = c.oid)
               ->  Sort  (cost=1.03..1.03 rows=1 width=84) (actual time=0.00..0.00 rows=39 loops=1)
                     Sort Key: t.tgconstrrelid
                     ->  Seq Scan on pg_trigger t  (cost=0.00..1.02 rows=1 width=84) (actual time=0.00..0.00 rows=6 loops=1)
                           Filter: tgisconstraint
 Total runtime: 9.00 msec
(48 rows)