explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YT81

Settings
# exclusive inclusive rows x rows loops node
1. 9.821 10.952 ↓ 9.3 130 1

Nested Loop (cost=19.62..40.91 rows=14 width=288) (actual time=0.882..10.952 rows=130 loops=1)

2. 0.103 1.131 ↓ 9.3 130 1

Hash Join (cost=19.62..39.5 rows=14 width=200) (actual time=0.389..1.131 rows=130 loops=1)

3. 0.105 1.013 ↓ 9.3 130 1

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

4. 0.157 0.518 ↓ 3.7 130 1

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

5. 0.070 0.070 ↑ 1.0 161 1

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

6. 0.044 0.291 ↓ 1.0 90 1

Hash (cost=17.11..17.11 rows=88 width=72) (actual time=0.291..0.291 rows=90 loops=1)

7. 0.247 0.247 ↓ 1.0 90 1

Seq Scan on pg_class c (cost=0..17.11 rows=88 width=72) (actual time=0.021..0.247 rows=90 loops=1)

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

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

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

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

10. 0.009 0.009 ↓ 2.0 12 1

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

11. 0.000 0.000 ↑ 1.0 2 130

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

12. 0.004 0.004 ↑ 1.0 2 1

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

Planning time : 6.496 ms
Execution time : 11.18 ms