explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ppm6 : Optimization for: plan #fh1o

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 6.849 47.960 ↓ 1,497.0 1,497 1

Hash Join (cost=2,932.52..4,122.45 rows=1 width=89) (actual time=30.794..47.960 rows=1,497 loops=1)

  • Hash Cond: (((block_history.key)::text = (b.key)::text) AND ((max(block_history.seq)) = b.seq))
2. 24.870 28.592 ↑ 1.0 41,764 1

HashAggregate (cost=1,464.51..1,897.21 rows=43,270 width=17) (actual time=18.239..28.592 rows=41,764 loops=1)

  • Group Key: block_history.key
3. 3.722 3.722 ↑ 1.1 44,254 1

Seq Scan on block_history (cost=0.00..1,230.67 rows=46,767 width=17) (actual time=0.034..3.722 rows=44,254 loops=1)

4. 0.674 12.519 ↓ 9.1 2,126 1

Hash (cost=1,464.51..1,464.51 rows=234 width=93) (actual time=12.519..12.519 rows=2,126 loops=1)

  • Buckets: 4096 (originally 1024) Batches: 1 (originally 1) Memory Usage: 304kB
5. 11.845 11.845 ↓ 9.1 2,126 1

Seq Scan on block_history b (cost=0.00..1,464.51 rows=234 width=93) (actual time=0.114..11.845 rows=2,126 loops=1)

  • Filter: ((value ->> 'blocked'::text) = 'false'::text)
  • Rows Removed by Filter: 42128
Planning time : 0.231 ms
Execution time : 48.833 ms