explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6u5M

Settings
# exclusive inclusive rows x rows loops node
1. 6.999 8.215 ↓ 9.3 130 1

Nested Loop Left Join (cost=19.62..40.91 rows=14 width=288) (actual time=0.444..8.215 rows=130 loops=1)

  • Join Filter: (t.oid = i.reltablespace)
  • Rows Removed by Join Filter: 242
2. 0.111 1.216 ↓ 9.3 130 1

Hash Left Join (cost=19.62..39.50 rows=14 width=200) (actual time=0.358..1.216 rows=130 loops=1)

  • Hash Cond: (c.relnamespace = n.oid)
3. 0.075 1.089 ↓ 9.3 130 1

Nested Loop (cost=18.49..38.31 rows=14 width=140) (actual time=0.331..1.089 rows=130 loops=1)

4. 0.156 0.494 ↓ 3.7 130 1

Hash Join (cost=18.21..24.25 rows=35 width=72) (actual time=0.315..0.494 rows=130 loops=1)

  • Hash Cond: (x.indrelid = c.oid)
5. 0.056 0.056 ↑ 1.0 161 1

Seq Scan on pg_index x (cost=0.00..5.61 rows=161 width=8) (actual time=0.009..0.056 rows=161 loops=1)

6. 0.062 0.282 ↓ 1.0 91 1

Hash (cost=17.11..17.11 rows=88 width=72) (actual time=0.282..0.282 rows=91 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
7. 0.220 0.220 ↓ 1.0 91 1

Seq Scan on pg_class c (cost=0.00..17.11 rows=88 width=72) (actual time=0.012..0.220 rows=91 loops=1)

  • Filter: (relkind = ANY ('{r,m}'::"char"[]))
  • Rows Removed by Filter: 320
8. 0.520 0.520 ↑ 1.0 1 130

Index Scan using pg_class_oid_index on pg_class i (cost=0.27..0.40 rows=1 width=72) (actual time=0.004..0.004 rows=1 loops=130)

  • Index Cond: (oid = x.indexrelid)
  • Filter: (relkind = 'i'::"char")
9. 0.006 0.016 ↓ 2.0 12 1

Hash (cost=1.06..1.06 rows=6 width=68) (actual time=0.016..0.016 rows=12 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
10. 0.010 0.010 ↓ 2.0 12 1

Seq Scan on pg_namespace n (cost=0.00..1.06 rows=6 width=68) (actual time=0.006..0.010 rows=12 loops=1)

11. 0.000 0.000 ↑ 1.0 2 130

Materialize (cost=0.00..1.03 rows=2 width=68) (actual time=0.000..0.000 rows=2 loops=130)

12. 0.005 0.005 ↑ 1.0 2 1

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

Planning time : 0.782 ms
Execution time : 8.323 ms