explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RY8N

Settings
# exclusive inclusive rows x rows loops node
1. 9.418 25,924.606 ↑ 1.7 3,059 1

HashAggregate (cost=80,860.68..82,223.08 rows=5,240 width=72) (actual time=25,923.880..25,924.606 rows=3,059 loops=1)

  • Group Key: "PC0".pyid, "CAS".acquisitionsegment, pegadata.pr_read_from_stream('.CustomerDetail.
2. 21,649.004 25,915.188 ↑ 1.7 3,059 1

Nested Loop Left Join (cost=1.25..80,808.28 rows=5,240 width=72) (actual time=42.390..25,915.188 rows=3,059 loops=1)

  • Join Filter: ((("PC0".pxobjclass)::text = 'MDR-LOS-Work-CC'::text) AND (("CAS".acquisitioncode)::text = ("PC0".customeracquisitionsegment)::text))
  • Rows Removed by Join Filter: 3059
3. 7.495 4,266.184 ↑ 1.7 3,059 1

Nested Loop (cost=1.11..79,406.21 rows=5,240 width=81) (actual time=35.637..4,266.184 rows=3,059 loops=1)

4. 3,888.550 3,888.550 ↑ 1.7 3,059 1

Index Scan using obfs_mdr_los_work_idx2 on obfs_mdr_los_work "PC0" (cost=0.56..75,329.21 rows=5,240 width=77) (actual time=35.595..3,888.550 rows=3,059 loops=1)

  • Index Cond: ((pxobjclass)::text = 'MDR-LOS-Work-CC'::text)
  • Filter: ((timestamp_tochar_immutable(date_trunc('day'::text, decisiondate), 'YYYYMMDD'::text) >= '20181019'::text) AND (timestamp_tochar_immutable(date_trunc('day'::text, decisiondate), 'YYYYMMDD'::text) <= '20181020'::text))
  • Rows Removed by Filter: 1090692
5. 370.139 370.139 ↑ 1.0 1 3,059

Index Scan using insindexedkey_76398 on pr_index_work_consumptiveloan "Index_Work_ConsumptiveLoan" (cost=0.56..0.77 rows=1 width=27) (actual time=0.120..0.121 rows=1 loops=3,059)

  • Index Cond: ((pxinsindexedkey)::text = ("PC0".pzinskey)::text)
  • Filter: (((pxobjclass)::text = 'Index-Work-ConsumptiveLoan'::text) AND ((pxindexpurpose)::text = 'Index_Work_ConsumptiveLoan'::text))
6. 0.000 0.000 ↑ 1.0 1 3,059

Materialize (cost=0.14..0.36 rows=1 width=21) (actual time=0.000..0.000 rows=1 loops=3,059)

7. 0.007 0.007 ↑ 1.0 1 1

Index Scan using pr_mdr_data_acquisitionsegment_idx1 on pr_mdr_data_acquisitionsegment "CAS" (cost=0.14..0.36 rows=1 width=21) (actual time=0.007..0.007 rows=1 loops=1)

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