explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gtRw : Pt un Penal, from Costel with Love

Settings
# exclusive inclusive rows x rows loops node
1. 0.495 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.554 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.269 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. 19.212 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.000 0.000 ↓ 0.0

Seq Scan on pg_index x (cost=0.00..2.78 rows=78 width=8) (actual rows= loops=)

  • (actual time=0.037..0.296 rows=80 loops=1)
6. 0.000 0.000 ↓ 0.0

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

  • (actual time=18.577..18.577 rows=1 loops=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")
7. 0.000 0.000 ↓ 0.0

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

  • (actual time=0.051..0.055 rows=1 loops=4)
  • Index Cond: (i.oid = "outer".indexrelid)
  • Filter: (relkind = 'i'::"char")
8. 0.000 0.000 ↓ 0.0

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

  • (actual time=0.014..0.045 rows=6 loops=4)
9. 0.000 0.000 ↓ 0.0

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

  • (actual time=0.010..0.018 rows=2 loops=4)
Total runtime : 65.294 ms