explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5nhm

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 112.537 ↑ 1.0 25 1

Limit (cost=11,786.32..11,786.38 rows=25 width=1,458) (actual time=112.520..112.537 rows=25 loops=1)

2. 5.719 112.524 ↑ 1.1 25 1

Sort (cost=11,786.32..11,786.39 rows=28 width=1,458) (actual time=112.518..112.524 rows=25 loops=1)

  • Sort Key: trace0_.deliveryrequesteddate, trace0_.carrier, trace0_.shipper, trace0_.identifierkeyvalues
  • Sort Method: top-N heapsort Memory: 82kB
3. 2.735 106.805 ↓ 116.5 3,262 1

Hash Join (cost=126.85..11,785.65 rows=28 width=1,458) (actual time=4.657..106.805 rows=3,262 loops=1)

  • Hash Cond: (trace0_.ruleid = rule1_.uuid)
4. 103.767 103.767 ↓ 16.7 3,262 1

Index Scan using trace_deliveryrequesteddate_idx on trace trace0_ (cost=0.43..11,658.72 rows=195 width=1,458) (actual time=4.346..103.767 rows=3,262 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))
  • Filter: ((NOT errorflag) AND (ontimestatus IS NOT NULL) AND (previousruleresultid IS NULL) AND ((ontimestatus <> ALL ('{"No Data",OnTime}'::text[])) OR (ontimestatus IS NULL)) AND (ontimestatus <> ''::text) 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: 74,551
5. 0.035 0.303 ↓ 1.0 97 1

Hash (cost=125.21..125.21 rows=96 width=16) (actual time=0.303..0.303 rows=97 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 13kB
6. 0.268 0.268 ↓ 1.0 97 1

Seq Scan on rule rule1_ (cost=0.00..125.21 rows=96 width=16) (actual time=0.007..0.268 rows=97 loops=1)

  • Filter: ((eventmessagetype)::text = ANY ('{LoadTender,BookingRequest}'::text[]))
  • Rows Removed by Filter: 562
Planning time : 5.893 ms
Execution time : 112.635 ms