explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UPby

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.84..29.35 rows=1 width=288) (actual rows= loops=)

  • Join Filter: (pkc.connamespace = npkc.oid)
2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.84..28.17 rows=1 width=199) (actual rows= loops=)

  • Join Filter: ((pkc.oid = d2.refobjid) AND (pkc.conrelid = con.confrelid))
3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.84..27.13 rows=1 width=139) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.55..18.81 rows=1 width=139) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.27..10.49 rows=1 width=139) (actual rows= loops=)

  • Join Filter: (con.connamespace = ncon.oid)
6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.27..9.36 rows=1 width=79) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on pg_constraint con (cost=0.00..1.02 rows=1 width=83) (actual rows= loops=)

  • Filter: (contype = 'f'::"char")
8. 0.000 0.000 ↓ 0.0

Index Scan using pg_class_oid_index on pg_class c (cost=0.27..8.32 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (oid = con.conrelid)
  • Filter: (pg_has_role(relowner, 'USAGE'::text) OR has_table_privilege(oid, 'INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER'::text) OR has_any_column_privilege(oid, 'INSERT, UPDATE, REFERENCES'::text))
9. 0.000 0.000 ↓ 0.0

Seq Scan on pg_namespace ncon (cost=0.00..1.06 rows=6 width=68) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Index Scan using pg_depend_depender_index on pg_depend d1 (cost=0.28..8.31 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((classid = '2606'::oid) AND (objid = con.oid))
  • Filter: ((refclassid = '1259'::oid) AND (refobjsubid = 0))
11. 0.000 0.000 ↓ 0.0

Index Scan using pg_depend_depender_index on pg_depend d2 (cost=0.28..8.31 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((classid = '1259'::oid) AND (objid = d1.refobjid) AND (objsubid = 0))
  • Filter: ((refclassid = '2606'::oid) AND (deptype = 'i'::"char"))
12. 0.000 0.000 ↓ 0.0

Seq Scan on pg_constraint pkc (cost=0.00..1.02 rows=1 width=76) (actual rows= loops=)

  • Filter: (contype = ANY ('{p,u}'::"char"[]))
13. 0.000 0.000 ↓ 0.0

Seq Scan on pg_namespace npkc (cost=0.00..1.06 rows=6 width=68) (actual rows= loops=)