explain.depesz.com

PostgreSQL's explain analyze made readable

Result: E2BC

Settings
# exclusive inclusive rows x rows loops node
1. 0.552 22.242 ↑ 1.0 1 1

Aggregate (cost=2,574.28..2,574.29 rows=1 width=8) (actual time=22.242..22.242 rows=1 loops=1)

2. 2.333 21.690 ↑ 5.8 7,647 1

Nested Loop (cost=18.00..2,464.28 rows=44,000 width=0) (actual time=0.179..21.690 rows=7,647 loops=1)

3. 10.502 19.357 ↓ 1.9 7,647 1

Hash Join (cost=18.00..1,876.00 rows=4,000 width=4) (actual time=0.167..19.357 rows=7,647 loops=1)

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

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

5. 0.009 0.135 ↑ 1.0 40 1

Hash (cost=17.50..17.50 rows=40 width=8) (actual time=0.135..0.135 rows=40 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
6. 0.126 0.126 ↑ 1.0 40 1

Seq Scan on s (cost=0.00..17.50 rows=40 width=8) (actual time=0.118..0.126 rows=40 loops=1)

  • Filter: (c = 48)
  • Rows Removed by Filter: 960
7. 0.000 0.000 ↑ 11.0 1 7,647

Materialize (cost=0.00..38.30 rows=11 width=4) (actual time=0.000..0.000 rows=1 loops=7,647)

8. 0.010 0.010 ↑ 11.0 1 1

Seq Scan on t (cost=0.00..38.25 rows=11 width=4) (actual time=0.009..0.010 rows=1 loops=1)

  • Filter: (c = 48)
  • Rows Removed by Filter: 49
Planning time : 0.198 ms
Execution time : 22.295 ms