explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BnPX : Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: plan #X7OV; plan #4qTb; plan #oZWp; plan #Vm5S; plan #Xoct; plan #bxGg; plan #DmE2; plan #pXI7; plan #FDqQM; plan #LiQb

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 70.508 142.357 ↓ 199.7 48,921 1

Merge Join (cost=0.83..14,639.58 rows=245 width=709) (actual time=0.024..142.357 rows=48,921 loops=1)

  • Merge Cond: ((rule_runner_results2.key)::text = (f.key)::text)
  • Join Filter: (f.ver = (max(rule_runner_results2.ver)))
  • Rows Removed by Join Filter: 10
2. 30.844 58.184 ↓ 1.0 48,921 1

GroupAggregate (cost=0.41..7,075.20 rows=48,910 width=23) (actual time=0.017..58.184 rows=48,921 loops=1)

  • Group Key: rule_runner_results2.key
3. 27.340 27.340 ↓ 1.0 48,931 1

Index Scan using rule_runner_results2_pkey on rule_runner_results2 (cost=0.41..6,341.49 rows=48,921 width=23) (actual time=0.013..27.340 rows=48,931 loops=1)

  • Filter: (seq > 200)
  • Rows Removed by Filter: 200
4. 13.665 13.665 ↑ 1.0 49,131 1

Index Scan using rule_runner_results2_pkey on rule_runner_results2 f (cost=0.41..6,218.67 rows=49,131 width=713) (actual time=0.002..13.665 rows=49,131 loops=1)

Planning time : 0.261 ms
Execution time : 145.134 ms