explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LiQb : 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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 104.859 254.638 ↓ 199.7 48,921 1

Sort (cost=14,649.30..14,649.91 rows=245 width=709) (actual time=235.529..254.638 rows=48,921 loops=1)

  • Sort Key: f.seq
  • Sort Method: external merge Disk: 34584kB
2. 73.844 149.779 ↓ 199.7 48,921 1

Merge Join (cost=0.83..14,639.58 rows=245 width=709) (actual time=0.022..149.779 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
3. 32.156 60.863 ↓ 1.0 48,921 1

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

  • Group Key: rule_runner_results2.key
4. 28.707 28.707 ↓ 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.012..28.707 rows=48,931 loops=1)

  • Filter: (seq > 200)
  • Rows Removed by Filter: 200
5. 15.072 15.072 ↑ 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..15.072 rows=49,131 loops=1)

Planning time : 0.334 ms
Execution time : 265.837 ms