explain.depesz.com

PostgreSQL's explain analyze made readable

Result: e5p4

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 161,006.641 ↑ 25.0 1 1

Limit (cost=110.61..209.99 rows=25 width=1,370) (actual time=156,099.363..161,006.641 rows=1 loops=1)

2. 161,004.468 161,006.638 ↑ 223,779.0 1 1

Index Scan using trace_deliveryrequesteddate_idx on trace shipment (cost=110.61..889,725.15 rows=223,779 width=1,370) (actual time=156,099.361..161,006.638 rows=1 loops=1)

  • Index Cond: ((deliveryrequesteddate >= '2019-06-09 00:00:00'::timestamp without time zone) AND (deliveryrequesteddate <= '2019-12-06 23:59:59'::timestamp without time zone))
  • Filter: ((identifierkeyvalues = '12345'::text) OR (carrierreferencenumber = '12345'::text) OR (hashed SubPlan 1))
  • Rows Removed by Filter: 496216
3.          

SubPlan (forIndex Scan)

4. 2.170 2.170 ↑ 24.0 1 1

Index Scan using "type_name_deliveryRequestedDate" on resultitem shipmentitem (cost=0.56..110.11 rows=24 width=16) (actual time=1.648..2.170 rows=1 loops=1)

  • Index Cond: ((type = ANY ('{poNumber,deliveryNoteNumber,salesOrderNumber}'::text[])) AND (name = '12345'::text) AND (deliveryrequesteddate >= '2019-06-09 00:00:00'::timestamp without time zone) AND (deliveryrequesteddate <= '2019-12-06 23:59:59'::timestamp without time zone))
Planning time : 4.980 ms
Execution time : 161,006.767 ms