explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kONc

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 1,208.973 ↑ 5.0 1 1

GroupAggregate (cost=136,074.86..136,081.88 rows=5 width=14) (actual time=1,208.972..1,208.973 rows=1 loops=1)

  • Group Key: trace0_.ontimestatus
2. 0.011 1,208.965 ↑ 929.0 1 1

Sort (cost=136,074.86..136,077.18 rows=929 width=22) (actual time=1,208.965..1,208.965 rows=1 loops=1)

  • Sort Key: trace0_.ontimestatus
  • Sort Method: quicksort Memory: 25kB
3. 0.011 1,208.954 ↑ 929.0 1 1

Hash Join (cost=75,971.34..136,029.06 rows=929 width=22) (actual time=1,167.810..1,208.954 rows=1 loops=1)

  • Hash Cond: (trace0_.ruleid = rule1_.uuid)
4. 647.165 1,208.675 ↑ 6,014.0 1 1

Bitmap Heap Scan on trace trace0_ (cost=75,851.09..135,892.93 rows=6,014 width=38) (actual time=1,167.534..1,208.675 rows=1 loops=1)

  • Recheck Cond: ((deliveryrequesteddate IS NOT NULL) AND (deliveryrequesteddate <= '2019-10-08 23:59:59'::timestamp without time zone) AND (deliveryrequesteddate >= '2019-04-11 00:00:00'::timestamp without time zone) AND (previousruleresultid IS NULL))
  • Filter: ((NOT errorflag) AND (processingmode = '2'::numeric) AND ((identifierkeyvalues = '2009353576'::text) OR (carrierreferencenumber = '2009353576'::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: 455138
  • Heap Blocks: exact=315828
5. 27.323 561.447 ↓ 0.0 0 1

BitmapAnd (cost=75,741.04..75,741.04 rows=15,664 width=0) (actual time=561.446..561.447 rows=0 loops=1)

6. 92.984 92.984 ↓ 6.9 469,880 1

Bitmap Index Scan on trace_deliveryrequesteddate_idx (cost=0.00..1,695.43 rows=67,760 width=0) (actual time=92.983..92.984 rows=469,880 loops=1)

  • Index Cond: ((deliveryrequesteddate IS NOT NULL) AND (deliveryrequesteddate <= '2019-10-08 23:59:59'::timestamp without time zone) AND (deliveryrequesteddate >= '2019-04-11 00:00:00'::timestamp without time zone))
7. 441.140 441.140 ↓ 1.1 3,194,581 1

Bitmap Index Scan on previousruleresultidindex_trace (cost=0.00..74,042.35 rows=3,017,322 width=0) (actual time=441.139..441.140 rows=3,194,581 loops=1)

  • Index Cond: (previousruleresultid IS NULL)
8.          

SubPlan (forBitmap Heap Scan)

9. 0.063 0.063 ↓ 0.0 0 1

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

  • Index Cond: ((type = ANY ('{poNumber,deliveryNoteNumber,salesOrderNumber}'::text[])) AND (name = '2009353576'::text) AND (deliveryrequesteddate >= '2019-04-11 00:00:00'::timestamp without time zone) AND (deliveryrequesteddate <= '2019-10-08 23:59:59'::timestamp without time zone))
10. 0.030 0.268 ↑ 1.0 98 1

Hash (cost=119.01..119.01 rows=99 width=16) (actual time=0.268..0.268 rows=98 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
11. 0.238 0.238 ↑ 1.0 98 1

Seq Scan on rule rule1_ (cost=0.00..119.01 rows=99 width=16) (actual time=0.006..0.238 rows=98 loops=1)

  • Filter: ((eventmessagetype)::text = ANY ('{LoadTender,BookingRequest}'::text[]))
  • Rows Removed by Filter: 547
Planning time : 2.042 ms
Execution time : 1,212.801 ms