explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5Gi7

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 824.346 ↑ 2.5 2 1

Aggregate (cost=251,759.21..251,759.33 rows=5 width=17) (actual time=721.692..824.346 rows=2 loops=1)

  • Buffers: shared hit=222,240
2. 0.027 824.341 ↑ 1.7 6 1

Sort (cost=251,759.21..251,759.23 rows=10 width=17) (actual time=721.688..824.341 rows=6 loops=1)

  • Sort Key: accrual_report_master.contractee_company_type
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=222,240
3. 111.797 824.314 ↑ 1.7 6 1

Gather (cost=251,757.99..251,759.04 rows=10 width=17) (actual time=721.593..824.314 rows=6 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=222,237
4. 10.173 712.517 ↑ 2.5 2 3 / 3

Aggregate (cost=250,757.99..250,758.04 rows=5 width=17) (actual time=712.516..712.517 rows=2 loops=3)

  • Buffers: shared hit=222,237
5. 702.344 702.344 ↑ 1.2 53,686 3 / 3

Seq Scan on accrual_report_master accrual_report_master (cost=0..250,431.4 rows=65,317 width=9) (actual time=683.237..702.344 rows=53,686 loops=3)

  • Filter: (accrual_report_master.lumpsum_cd IS NOT NULL)
  • Buffers: shared hit=222,237
Planning time : 0.209 ms
Execution time : 824.446 ms