explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YM8E

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 10,528.838 ↑ 25.0 1 1

Limit (cost=235.98..6,556.94 rows=25 width=1,354) (actual time=6,811.623..10,528.838 rows=1 loops=1)

2. 0.020 10,528.835 ↑ 847.0 1 1

Hash Join (cost=235.98..214,389.96 rows=847 width=1,354) (actual time=6,811.622..10,528.835 rows=1 loops=1)

  • Hash Cond: (trace0_.ruleid = rule1_.uuid)
3. 10,528.489 10,528.553 ↑ 5,681.0 1 1

Index Scan using trace_deliveryrequesteddate_ontimestatus_idx on trace trace0_ (cost=110.73..214,249.69 rows=5,681 width=1,354) (actual time=6,811.341..10,528.553 rows=1 loops=1)

  • 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 ((identifierkeyvalues = '2605603110'::text) OR (carrierreferencenumber = '2605603110'::text) OR (hashed SubPlan 1)) 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: 483569
4.          

SubPlan (for Index Scan)

5. 0.064 0.064 ↓ 0.0 0 1

Index Scan using "type_name_deliveryRequestedDate" on resultitem resultitem2_ (cost=0.56..110.11 rows=24 width=16) (actual time=0.064..0.064 rows=0 loops=1)

  • Index Cond: ((type = ANY ('{poNumber,deliveryNoteNumber,salesOrderNumber}'::text[])) AND (name = '2605603110'::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))
6. 0.036 0.262 ↑ 1.0 96 1

Hash (cost=124.05..124.05 rows=96 width=16) (actual time=0.261..0.262 rows=96 loops=1)

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

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

  • Filter: ((eventmessagetype)::text = ANY ('{LoadTender,BookingRequest}'::text[]))
  • Rows Removed by Filter: 548
Planning time : 3.859 ms
Execution time : 10,528.913 ms