explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fFPL

Settings
# exclusive inclusive rows x rows loops node
1. 9.799 51,239.587 ↑ 27.0 5 1

Gather (cost=1,001.12..637,379.73 rows=135 width=101) (actual time=1.859..51,239.587 rows=5 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=2497067 read=720679 written=286
  • I/O Timings: read=112926.135 write=3.353
2. 461.582 51,229.788 ↑ 28.0 2 3 / 3

Nested Loop (cost=1.11..636,366.23 rows=56 width=101) (actual time=34,151.515..51,229.788 rows=2 loops=3)

  • Buffers: shared hit=2497067 read=720679 written=286
  • I/O Timings: read=112926.135 write=3.353
3. 17,367.840 17,367.840 ↓ 3.2 344,334 3 / 3

Parallel Index Scan using pc_work_idx26e769 on js_retail_sbs_work_si "REM" (cost=0.56..451,198.27 rows=108,618 width=47) (actual time=2,082.954..17,367.840 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=113153 read=475651 written=258
  • I/O Timings: read=41251.789 write=2.925
4. 33,400.366 33,400.366 ↓ 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.70 rows=1 width=63) (actual time=0.097..0.097 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=2383914 read=245028 written=28
  • I/O Timings: read=71674.346 write=0.428