explain.depesz.com

PostgreSQL's explain analyze made readable

Result: om9k

Settings
# exclusive inclusive rows x rows loops node
1. 24.499 63,408.615 ↑ 26.6 5 1

Gather (cost=1,001.12..417,775.85 rows=133 width=101) (actual time=63,394.077..63,408.615 rows=5 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=3129955 read=479068 written=554
  • I/O Timings: read=156659.862 write=7.044
2. 629.078 63,384.116 ↑ 27.5 2 3 / 3

Nested Loop (cost=1.11..416,762.55 rows=55 width=101) (actual time=63,374.391..63,384.116 rows=2 loops=3)

  • Buffers: shared hit=3129955 read=479068 written=554
  • I/O Timings: read=156659.862 write=7.044
3. 33,486.676 33,486.676 ↓ 3.2 344,334 3 / 3

Parallel Index Scan using sbs_renumbreak on js_retail_sbs_work_si "REM" (cost=0.56..234,132.39 rows=106,664 width=47) (actual time=1.143..33,486.676 rows=344,334 loops=3)

  • Index Cond: (((pxobjclass)::text = 'JS-Retail-SBS-Work-SI-Remuneration'::text) AND (totalamount >= 0.01))
  • Buffers: shared hit=673608 read=306473 written=408
  • I/O Timings: read=96307.877 write=4.090
4. 29,268.362 29,268.362 ↓ 0.0 0 1,033,001 / 3

Index Scan using js_retail_sbs_work_si_pk on js_retail_sbs_work_si "PC0" (cost=0.56..1.71 rows=1 width=63) (actual time=0.085..0.085 rows=0 loops=1,033,001)

  • Index Cond: ((pzinskey)::text = ("REM".pxcoverinskey)::text)
  • Filter: (((pxobjclass)::text ~~ 'JS-Retail-SBS-Work-SI%'::text) AND ((pyid)::text !~~ 'ECM%'::text) AND ((pystatuswork)::text = 'Resolved-Completed'::text) AND (to_char(date_trunc('day'::text, pxcreatedatetime), 'YYYYMMDD'::text) >= '20200508'::text) AND (to_char(date_trunc('day'::text, pxcreatedatetime), 'YYYYMMDD'::text) <= '20200514'::text))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=2456347 read=172595 written=146
  • I/O Timings: read=60351.985 write=2.954
Planning time : 7.528 ms
Execution time : 63,408.698 ms