explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1hL9p

Settings
# exclusive inclusive rows x rows loops node
1. 0.021 40.340 ↓ 2.0 2 1

Nested Loop (cost=0.86..12,645.58 rows=1 width=101) (actual time=0.581..40.340 rows=2 loops=1)

2. 39.791 39.791 ↑ 2.3 33 1

Index Scan using worksipystatuswork on js_retail_sbs_work_si "PC0" (cost=0.43..12,460.70 rows=75 width=62) (actual time=0.055..39.791 rows=33 loops=1)

  • Index Cond: ((pystatuswork)::text = 'Resolved-Completed'::text)
  • Filter: (((pxobjclass)::text ~~ 'JS-Retail-SBS-Work-SI%'::text) AND ((pyid)::text !~~ 'ECM%'::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: 13359
3. 0.528 0.528 ↓ 0.0 0 33

Index Scan using js_retail_pxcoverinskey on js_retail_sbs_work_si "REM" (cost=0.43..2.46 rows=1 width=46) (actual time=0.016..0.016 rows=0 loops=33)

  • Index Cond: ((pxcoverinskey)::text = ("PC0".pzinskey)::text)
  • Filter: ((totalamount >= 0.01) AND ((pxobjclass)::text = 'JS-Retail-SBS-Work-SI-Remuneration'::text))
  • Rows Removed by Filter: 0