explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CDld

Settings
# exclusive inclusive rows x rows loops node
1. 7.529 51,818.580 ↑ 25.6 5 1

Gather (cost=1,001.12..750,825.87 rows=128 width=101) (actual time=4.439..51,818.580 rows=5 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=2621078 read=454770 written=15
  • I/O Timings: read=122973.592 write=0.975
2. 518.823 51,811.051 ↑ 26.5 2 3 / 3

Nested Loop (cost=1.11..749,813.07 rows=53 width=101) (actual time=17,270.137..51,811.051 rows=2 loops=3)

  • Buffers: shared hit=2621078 read=454770 written=15
  • I/O Timings: read=122973.592 write=0.975
3. 11,005.189 11,005.189 ↓ 3.3 344,334 3 / 3

Parallel Index Scan using extract_pxobj_1 on js_retail_sbs_work_si "REM" (cost=0.56..569,918.18 rows=104,565 width=47) (actual time=0.995..11,005.189 rows=344,334 loops=3)

  • Index Cond: ((pxobjclass)::text = 'JS-Retail-SBS-Work-SI-Remuneration'::text)
  • Filter: (totalamount >= 0.01)
  • Rows Removed by Filter: 1733
  • Buffers: shared hit=180083 read=266823 written=10
  • I/O Timings: read=30055.223 write=0.183
4. 40,287.039 40,287.039 ↓ 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.72 rows=1 width=63) (actual time=0.117..0.117 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=2440995 read=187947 written=5
  • I/O Timings: read=92918.369 write=0.791