explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YNq

Settings
# exclusive inclusive rows x rows loops node
1. 0.019 200,420.836 ↓ 3.0 3 1

GroupAggregate (cost=45.23..45.25 rows=1 width=15) (actual time=200,420.819..200,420.836 rows=3 loops=1)

  • Group Key: trace0_.ontimestatus
2. 0.139 200,420.817 ↓ 36.0 36 1

Sort (cost=45.23..45.23 rows=1 width=23) (actual time=200,420.809..200,420.817 rows=36 loops=1)

  • Sort Key: trace0_.ontimestatus
  • Sort Method: quicksort Memory: 27kB
3. 5.888 200,420.678 ↓ 36.0 36 1

Nested Loop Semi Join (cost=19.84..45.22 rows=1 width=23) (actual time=220.814..200,420.678 rows=36 loops=1)

4. 36.044 176,952.936 ↓ 1,922.0 1,922 1

Nested Loop Semi Join (cost=10.39..31.72 rows=1 width=39) (actual time=76.141..176,952.936 rows=1,922 loops=1)

5. 22.916 4,338.072 ↓ 13,306.0 13,306 1

Nested Loop (cost=0.84..18.13 rows=1 width=23) (actual time=9.767..4,338.072 rows=13,306 loops=1)

6. 4,261.932 4,261.932 ↓ 13,306.0 13,306 1

Index Scan using trace_deliveryrequesteddate_senderduns_ontimestatus_idx on trace trace0_ (cost=0.56..8.69 rows=1 width=39) (actual time=9.757..4,261.932 rows=13,306 loops=1)

  • Index Cond: ((deliveryrequesteddate IS NOT NULL) AND (deliveryrequesteddate <= '2019-11-13 23:59:59'::timestamp without time zone) AND (deliveryrequesteddate >= '2019-11-07 00:00:00'::timestamp without time zone))
  • Filter: ((NOT errorflag) AND (previousruleresultid 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: 1424
7. 53.224 53.224 ↑ 1.0 1 13,306

Index Scan using rule_primary_key on rule rule1_ (cost=0.28..8.30 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=13,306)

  • Index Cond: (uuid = trace0_.ruleid)
  • Filter: ((eventmessagetype)::text = ANY ('{LoadTender,BookingRequest}'::text[]))
8. 971.338 172,578.820 ↓ 0.0 0 13,306

Bitmap Heap Scan on resultitem resultitem2_ (cost=9.55..13.58 rows=1 width=16) (actual time=12.970..12.970 rows=0 loops=13,306)

  • Recheck Cond: ((deliveryrequesteddate >= '2019-11-07 00:00:00'::timestamp without time zone) AND (deliveryrequesteddate <= '2019-11-13 23:59:59'::timestamp without time zone) AND (resultid = trace0_.uuid) AND (type = 'sbuId'::text))
  • Filter: (name = ANY ('{ED2,EDD,EDG,EDQ,EDR,EDS,EDU}'::text[]))
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=13932
9. 10,711.330 171,607.482 ↓ 0.0 0 13,306

BitmapAnd (cost=9.55..9.55 rows=1 width=0) (actual time=12.897..12.897 rows=0 loops=13,306)

10. 160,763.092 160,763.092 ↓ 10,919.3 185,628 13,306

Bitmap Index Scan on deliverydate_resultitem_index (cost=0.00..4.61 rows=17 width=0) (actual time=12.082..12.082 rows=185,628 loops=13,306)

  • Index Cond: ((deliveryrequesteddate >= '2019-11-07 00:00:00'::timestamp without time zone) AND (deliveryrequesteddate <= '2019-11-13 23:59:59'::timestamp without time zone))
11. 133.060 133.060 ↑ 13.0 1 13,306

Bitmap Index Scan on resultitem_pkey (cost=0.00..4.69 rows=13 width=0) (actual time=0.010..0.010 rows=1 loops=13,306)

  • Index Cond: ((resultid = trace0_.uuid) AND (type = 'sbuId'::text))
12. 13.454 23,461.854 ↓ 0.0 0 1,922

Bitmap Heap Scan on resultitem resultitem3_ (cost=9.45..13.48 rows=1 width=16) (actual time=12.207..12.207 rows=0 loops=1,922)

  • Recheck Cond: ((resultid = trace0_.uuid) AND (type = 'consignee'::text) AND (deliveryrequesteddate >= '2019-11-07 00:00:00'::timestamp without time zone) AND (deliveryrequesteddate <= '2019-11-13 23:59:59'::timestamp without time zone))
  • Filter: (name = ANY ('{"Actega Rhenania GmbH (4183487)","ACTEGA Terra GmbH (2345)","DONECK EUROFLEX SA (227571)","Klumpp Coatings GmbH (5628354)","Siegwerk Büdingen GmbH (862607)","Teknos Deutschland GmbH (4708000)","Votteler Lackfabrik","GmbH & Co. KG (8717)","WEILBURGER Coatings GmbH (7056)","Weilburger Graphics GmbH (9324)"}'::text[]))
  • Rows Removed by Filter: 2
  • Heap Blocks: exact=2760
13. 3.844 23,448.400 ↓ 0.0 0 1,922

BitmapAnd (cost=9.45..9.45 rows=1 width=0) (actual time=12.200..12.200 rows=0 loops=1,922)

14. 11.532 11.532 ↑ 1.5 2 1,922

Bitmap Index Scan on resultitem_pkey (cost=0.00..4.59 rows=3 width=0) (actual time=0.006..0.006 rows=2 loops=1,922)

  • Index Cond: ((resultid = trace0_.uuid) AND (type = 'consignee'::text))
15. 23,433.024 23,433.024 ↓ 10,919.3 185,628 1,922

Bitmap Index Scan on deliverydate_resultitem_index (cost=0.00..4.61 rows=17 width=0) (actual time=12.192..12.192 rows=185,628 loops=1,922)

  • Index Cond: ((deliveryrequesteddate >= '2019-11-07 00:00:00'::timestamp without time zone) AND (deliveryrequesteddate <= '2019-11-13 23:59:59'::timestamp without time zone))
Planning time : 2.689 ms
Execution time : 200,420.933 ms