explain.depesz.com

PostgreSQL's explain analyze made readable

Result: heaW

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 131.434 ↓ 0.0 0 1

HashAggregate (cost=23,005.54..23,071.62 rows=8 width=129) (actual time=131.434..131.434 rows=0 loops=1)

  • Group Key: pc0.pyid, pc0.pxcreatedatetime, cas.acquisitionsegment, pegadata.pr_read_from_stream('.CustomerDetail.SubAcquisitionSegment'::character varying, pc0.pzinskey, pc0.pzpvstream), pc0.derejectcodes, pc0.pystatuswork, pegadata.pr_read_decimal_from_stream('.CustomerDetail.
2. 0.001 131.432 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.70..23,004.78 rows=8 width=129) (actual time=131.432..131.432 rows=0 loops=1)

  • Join Filter: (((pc0.pxobjclass)::text = 'MDR-Data-AcquisitionSegments'::text) AND ((cas.acquisitioncode)::text = (pc0.customeracquisitionsegment)::text))
3. 131.431 131.431 ↓ 0.0 0 1

Index Scan using obfs_mdr_los_work_idx2 on obfs_mdr_los_work pc0 (cost=0.56..22,932.99 rows=8 width=138) (actual time=131.431..131.431 rows=0 loops=1)

  • Index Cond: ((pxobjclass)::text = 'MDR-Data-AcquisitionSegments'::text)
  • Filter: ((timestamp_tochar_immutable(date_trunc('day'::text, pxcreatedatetime), 'YYYYMMDD'::text) >= '2019-07-06 08:25:47.571'::text) AND (timestamp_tochar_immutable(date_trunc('day'::text, pxcreatedatetime), 'YYYYMMDD'::text) <= '2019-07-06 08:25:47.576'::text))
4. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.14..2.07 rows=27 width=21) (never executed)

5. 0.000 0.000 ↓ 0.0 0

Index Scan using pr_mdr_data_acquisitionsegment_idx1 on pr_mdr_data_acquisitionsegment cas (cost=0.14..1.94 rows=27 width=21) (never executed)

  • Index Cond: (((acquisitiontype)::text = 'Customer'::text) AND ((pxobjclass)::text = 'MDR-Data-AcquisitionSegments'::text))
Planning time : 0.633 ms