explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OPF9

Settings
# exclusive inclusive rows x rows loops node
1. 0.423 20.530 ↓ 4.0 4 1

Nested Loop Left Join (cost=5.64..16.89 rows=1 width=260) (actual time=19.552..20.530 rows=4 loops=1)

  • Join Filter: ("inner".oid = "outer".reltablespace)
2. 0.374 20.035 ↓ 4.0 4 1

Nested Loop Left Join (cost=5.64..15.84 rows=1 width=200) (actual time=19.313..20.035 rows=4 loops=1)

  • Join Filter: ("inner".oid = "outer".relnamespace)
3. 0.049 19.481 ↓ 4.0 4 1

Nested Loop (cost=5.64..14.71 rows=1 width=140) (actual time=18.983..19.481 rows=4 loops=1)

4. 0.339 19.212 ↓ 4.0 4 1

Hash Join (cost=5.64..8.82 rows=1 width=72) (actual time=18.876..19.212 rows=4 loops=1)

  • Hash Cond: ("outer".indrelid = "inner".oid)
5. 0.296 0.296 ↓ 1.0 80 1

Seq Scan on pg_index x (cost=0.00..2.78 rows=78 width=8) (actual time=0.037..0.296 rows=80 loops=1)

6. 0.113 18.577 ↑ 1.0 1 1

Hash (cost=5.63..5.63 rows=1 width=72) (actual time=18.577..18.577 rows=1 loops=1)

7. 18.464 18.464 ↑ 1.0 1 1

Index Scan using pg_class_relname_nsp_index on pg_class c (cost=0.00..5.63 rows=1 width=72) (actual time=18.391..18.464 rows=1 loops=1)

  • Index Cond: (relname = 'pg_constraint'::name)
  • Filter: (relkind = 'r'::"char")
8. 0.220 0.220 ↑ 1.0 1 4

Index Scan using pg_class_oid_index on pg_class i (cost=0.00..5.88 rows=1 width=72) (actual time=0.051..0.055 rows=1 loops=4)

  • Index Cond: (i.oid = "outer".indexrelid)
  • Filter: (relkind = 'i'::"char")
9. 0.180 0.180 ↑ 1.0 6 4

Seq Scan on pg_namespace n (cost=0.00..1.06 rows=6 width=68) (actual time=0.014..0.045 rows=6 loops=4)

10. 0.072 0.072 ↑ 1.0 2 4

Seq Scan on pg_tablespace t (cost=0.00..1.02 rows=2 width=68) (actual time=0.010..0.018 rows=2 loops=4)

Total runtime : 65.294 ms