explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hjKM

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.006 5,578.391 ↑ 1.0 10 1

Limit (cost=1,000.42..21,589.16 rows=10 width=4) (actual time=2,182.626..5,578.391 rows=10 loops=1)

  • Buffers: shared hit=29009 read=3, temp read=12370 written=277
2. 664.716 5,578.385 ↑ 20,092.1 10 1

Gather (cost=1,000.42..413,672,085.6 rows=200,921 width=4) (actual time=2,182.626..5,578.385 rows=10 loops=1)

  • Buffers: shared hit=29009 read=3, temp read=12370 written=277
3. 4,891.663 4,913.669 ↑ 11,959.6 7 3

Seq Scan on AO_7DEABF_SCHEDULE AO_7DEABF_SCHEDULE (cost=0.42..413,650,993.5 rows=83,717 width=4) (actual time=2,926.139..4,913.669 rows=7 loops=3)

  • Filter: (NOT (SubPlan 1))
  • Buffers: shared hit=29009 read=3, temp read=12370 written=277
4.          

SubPlan (forSeq Scan)

5. 2.408 22.006 ↑ 2.8 47,773 360

Materialize (cost=0.42..4,611.37 rows=132,000 width=6) (actual time=0.01..22.006 rows=47,773 loops=360)

  • Buffers: shared hit=29004, temp read=12370 written=277
6. 8.318 19.598 ↑ 2.8 46,464 224

Limit (cost=0.42..3,435.37 rows=132,000 width=6) (actual time=0.013..19.598 rows=46,464 loops=224)

  • Buffers: shared hit=29004
7. 11.280 11.280 ↑ 5.1 46,464 224

Index Only Scan using pk_jiraissue on jiraissue jiraissue (cost=0.42..6,223.67 rows=239,150 width=6) (actual time=0.013..11.28 rows=46,464 loops=224)

  • Buffers: shared hit=29004