explain.depesz.com

PostgreSQL's explain analyze made readable

Result: M4yP6

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 17.614 ↑ 1.0 1 1

Aggregate (cost=1,961.34..1,961.35 rows=1 width=8) (actual time=17.614..17.614 rows=1 loops=1)

2. 0.002 17.610 ↓ 0.0 0 1

Nested Loop (cost=17.56..1,947.59 rows=5,500 width=0) (actual time=17.610..17.610 rows=0 loops=1)

3. 9.385 17.608 ↓ 0.0 0 1

Hash Join (cost=17.56..1,840.56 rows=500 width=4) (actual time=17.608..17.608 rows=0 loops=1)

  • Hash Cond: (r.b = s.b)
4. 8.144 8.144 ↑ 1.0 100,000 1

Seq Scan on r (cost=0.00..1,443.00 rows=100,000 width=4) (actual time=0.010..8.144 rows=100,000 loops=1)

5. 0.003 0.079 ↑ 5.0 1 1

Hash (cost=17.50..17.50 rows=5 width=8) (actual time=0.079..0.079 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
6. 0.076 0.076 ↑ 5.0 1 1

Seq Scan on s (cost=0.00..17.50 rows=5 width=8) (actual time=0.012..0.076 rows=1 loops=1)

  • Filter: (c = 1)
  • Rows Removed by Filter: 999
7. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..38.30 rows=11 width=4) (never executed)

8. 0.000 0.000 ↓ 0.0 0

Seq Scan on t (cost=0.00..38.25 rows=11 width=4) (never executed)

  • Filter: (c = 1)
Planning time : 0.278 ms
Execution time : 17.669 ms