explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fX9T

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 708.413 ↓ 1.8 25 1

Limit (cost=30,506.38..30,506.41 rows=14 width=1,443) (actual time=708.396..708.413 rows=25 loops=1)

2. 5.981 708.400 ↓ 1.8 25 1

Sort (cost=30,506.38..30,506.41 rows=14 width=1,443) (actual time=708.394..708.400 rows=25 loops=1)

  • Sort Key: deliveryrequesteddate, carrier, shipper, identifierkeyvalues
  • Sort Method: top-N heapsort Memory: 81kB
3. 702.419 702.419 ↓ 239.9 3,358 1

Index Scan using trace_deliveryrequesteddate_senderduns_ontimestatus_idx on trace trace0_ (cost=0.56..30,506.11 rows=14 width=1,443) (actual time=40.375..702.419 rows=3,358 loops=1)

  • Index Cond: ((deliveryrequesteddate IS NOT NULL) AND (deliveryrequesteddate <= '2019-10-16 23:59:59'::timestamp without time zone) AND (deliveryrequesteddate >= '2019-09-25 00:00:00'::timestamp without time zone) AND (ontimestatus IS NOT NULL))
  • Filter: ((NOT errorflag) AND (previousruleresultid IS NULL) AND (eventmessagetype = ANY ('{LoadTender,BookingRequest}'::text[])) AND ((ontimestatus <> ALL ('{"No Data",OnTime}'::text[])) OR (ontimestatus IS NULL)) AND (processingmode = '2'::numeric) AND ((senderduns = ANY ('{BASF_AU01,BASF_AT01,BASF_PL01,BASF_KZ07,202108015,BASF_TR01,BASF_PE01,BASF_0050,BASF_DL01,899244198,BASF_BE05,BASF_DL07,BASF_CN0W,BASF_BR01,BASF_FR01,BASF_US01,315000554i,BASF_DE0E,BASF_EC01,BASF_SG02,BASF_DE0P,BASF_CA01,BASF_DE0M,BASF_CH01,BASF_MX01,315000554,370006132,BASF_VE02,"null",BASF_DE0S,BASF_DE0T,315000554ICO1,315000554ICO2,BASF_ES01,BASF_CL04,BASF_AE07,BASF_ZA01,343224259,BASF_AR01,BASF_UY01,BASF_CO04,BASF_IT01}'::text[])) OR (receiverduns = ANY ('{BASF_AU01,BASF_AT01,BASF_PL01,BASF_KZ07,202108015,BASF_TR01,BASF_PE01,BASF_0050,BASF_DL01,899244198,BASF_BE05,BASF_DL07,BASF_CN0W,BASF_BR01,BASF_FR01,BASF_US01,315000554i,BASF_DE0E,BASF_EC01,BASF_SG02,BASF_DE0P,BASF_CA01,BASF_DE0M,BASF_CH01,BASF_MX01,315000554,370006132,BASF_VE02,"null",BASF_DE0S,BASF_DE0T,315000554ICO1,315000554ICO2,BASF_ES01,BASF_CL04,BASF_AE07,BASF_ZA01,343224259,BASF_AR01,BASF_UY01,BASF_CO04,BASF_IT01}'::text[]))))
  • Rows Removed by Filter: 72,189
Planning time : 4.501 ms
Execution time : 708.464 ms