explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Xaa1B

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 3,097.310 ↓ 11.0 11 1

Limit (cost=1,126.25..410,491.20 rows=1 width=1,354) (actual time=3,094.848..3,097.310 rows=11 loops=1)

2. 7.495 3,098.288 ↓ 11.0 11 1

Gather (cost=1,126.25..410,491.20 rows=1 width=1,354) (actual time=3,094.845..3,098.288 rows=11 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 1,057.045 3,090.793 ↓ 4.0 4 3

Nested Loop (cost=126.25..409,491.10 rows=1 width=1,354) (actual time=2,934.167..3,090.793 rows=4 loops=3)

4. 87.099 2,033.736 ↓ 112.9 79,925 3

Hash Join (cost=125.69..153,577.20 rows=708 width=1,354) (actual time=3.065..2,033.736 rows=79,925 loops=3)

  • Hash Cond: (trace0_.ruleid = rule1_.uuid)
5. 1,946.347 1,946.347 ↓ 16.8 79,925 3

Parallel Index Scan using trace_deliveryrequesteddate_idx on trace trace0_ (cost=0.43..153,439.42 rows=4,747 width=1,354) (actual time=2.710..1,946.347 rows=79,925 loops=3)

  • Index Cond: ((deliveryrequesteddate IS NOT NULL) AND (deliveryrequesteddate <= '2019-12-06 23:59:59'::timestamp without time zone) AND (deliveryrequesteddate >= '2019-06-09 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: 83238
6. 0.042 0.290 ↑ 1.0 96 3

Hash (cost=124.05..124.05 rows=96 width=16) (actual time=0.290..0.290 rows=96 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
7. 0.248 0.248 ↑ 1.0 96 3

Seq Scan on rule rule1_ (cost=0.00..124.05 rows=96 width=16) (actual time=0.009..0.248 rows=96 loops=3)

  • Filter: ((eventmessagetype)::text = ANY ('{LoadTender,BookingRequest}'::text[]))
  • Rows Removed by Filter: 548
8. 0.012 0.012 ↓ 0.0 0 239,774

Index Scan using resulitd_index on resultitem (cost=0.56..361.45 rows=1 width=52) (actual time=0.012..0.012 rows=0 loops=239,774)

  • Index Cond: (resultid = trace0_.uuid)
  • Filter: ((trace0_.identifierkeyvalues = '2605603110'::text) OR (trace0_.carrierreferencenumber = '2605603110'::text) OR ((name = '2605603110'::text) AND (type = ANY ('{poNumber,deliveryNoteNumber,salesOrderNumber}'::text[]))))
  • Rows Removed by Filter: 14
Planning time : 41.315 ms
Execution time : 3,098.431 ms