explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ipcu : DEF RATE

Settings
# exclusive inclusive rows x rows loops node
1. 1.613 5.234 ↑ 1.0 1 1

Gather Motion 20:1 (slice7; segments: 20) (cost=0.00..4,422.22 rows=1 width=9) (actual time=5.233..5.234 rows=1 loops=1)

  • (slice0) Executor memory: 617K bytes.
  • (slice1) Executor memory: 138K bytes avg x 20 workers, 138K bytes max (seg0).
  • (slice2) Executor memory: 62K bytes avg x 20 workers, 62K bytes max (seg0).
  • (slice3) Executor memory: 346K bytes (entry db).
  • (slice4) Executor memory: 65K bytes avg x 20 workers, 65K bytes max (seg0).
  • (slice5) Executor memory: 1130K bytes avg x 20 workers, 1130K bytes max (seg0).
  • (slice6) Executor memory: 154K bytes avg x 20 workers, 154K bytes max (seg0). Work_mem: 81K bytes max.
  • (slice7) Executor memory: 130K bytes avg x 20 workers, 130K bytes max (seg0). Work_mem: 65K bytes max.
  • (slice8) Memory used: 98304kBOptimizer: Pivotal Optimizer (GPORCA) version 3.88.0
2. 0.010 3.621 ↑ 1.0 1 1

Result (cost=0.00..4,422.22 rows=1 width=9) (actual time=3.621..3.621 rows=1 loops=1)

3. 0.018 3.611 ↑ 1.0 1 1

GroupAggregate (cost=0.00..4,422.22 rows=1 width=18) (actual time=3.611..3.611 rows=1 loops=1)

  • Group Key: container.im_formation_date, container.barcode, container.im_category, container.im_origin_impc_code, container.im_destination_impc_code, container.barcode_suffix, container.operations, container.ctid, container.gp_segment_id, ""outer"".ColRef_0089
4. 0.574 3.593 ↑ 1.0 1 1

Sort (cost=0.00..4,422.22 rows=1 width=53) (actual time=3.592..3.593 rows=1 loops=1)

  • Sort Key: container.im_formation_date, container.barcode, container.im_category, container.im_origin_impc_code, container.im_destination_impc_code, container.barcode_suffix, container.operations, container.ctid, container.gp_segment_id, ""outer"".ColRef_0089
  • Sort Method: quicksort Memory: 660kB
5. 0.247 3.019 ↑ 1.0 1 1

Redistribute Motion 20:20 (slice6; segments: 20) (cost=0.00..4,422.22 rows=1 width=53) (actual time=2.865..3.019 rows=1 loops=1)

  • Hash Key: container.im_formation_date, container.barcode, container.im_category, container.im_origin_impc_code, container.im_destination_impc_code, container.barcode_suffix, container.operations, container.ctid, container.gp_segment_id, ""outer"".ColRef_0089
6. 0.016 2.772 ↑ 1.0 1 1

GroupAggregate (cost=0.00..4,422.22 rows=1 width=53) (actual time=2.771..2.772 rows=1 loops=1)

  • Group Key: container.im_formation_date, container.barcode, container.im_category, container.im_origin_impc_code, container.im_destination_impc_code, container.barcode_suffix, container.operations, container.ctid, container.gp_segment_id, ""outer"".ColRef_0089
7. 0.537 2.756 ↑ 1.0 1 1

Sort (cost=0.00..4,422.22 rows=1 width=53) (actual time=2.755..2.756 rows=1 loops=1)

  • Sort Key: container.im_formation_date, container.barcode, container.im_category, container.im_origin_impc_code, container.im_destination_impc_code, container.barcode_suffix, container.operations, container.ctid, container.gp_segment_id, ""outer"".ColRef_0089
  • Sort Method: quicksort Memory: 980kB
8. 0.000 2.219 ↑ 1.0 1 1

Redistribute Motion 20:20 (slice5; segments: 20) (cost=0.00..4,422.22 rows=1 width=53) (actual time=2.024..2.219 rows=1 loops=1)

9. 2.239 2.266 ↑ 1.0 1 1

Hash Left Join (cost=0.00..4,422.22 rows=1 width=53) (actual time=1.908..2.266 rows=1 loops=1)

  • Hash Cond: (container.barcode = container_operation.barcode)
  • Extra Text: (seg10) Hash chain length 0.0 avg, 0 max, using 0 of 131072 buckets.
10. 0.000 0.027 ↑ 1.0 1 1

Redistribute Motion 20:20 (slice1; segments: 20) (cost=0.00..6.11 rows=1 width=52) (actual time=0.012..0.027 rows=1 loops=1)

  • Hash Key: container.barcode
11. 0.303 0.303 ↑ 1.0 1 1

Index Scan using container_im_destination_impc_code_index on container (cost=0.00..6.11 rows=1 width=52) (actual time=0.195..0.303 rows=1 loops=1)

  • Index Cond: (im_destination_impc_code = 'RUEKAA'::text)
  • Filter: ((im_origin_impc_code = 'HKHKGH'::text) AND (date_part('year'::text, im_formation_date) = 2020::double precision) AND (im_category = 'C'::text) AND (im_formation_date >= '2019-05-21 11:37:08.421+00'::timestamp with time zone) AND (im_formation_date < '2021-05-21 11:37:08.423+00'::timestamp with time zone) AND (NOT ((operations -> 'opened'::text) IS NULL)))
12. 0.000 0.000 ↓ 0.0 0

Hash (cost=2,012.68..2,012.68 rows=472,557 width=18) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..2,012.68 rows=472,557 width=18) (never executed)

14. 0.000 0.000 ↓ 0.0 0

Redistribute Motion 20:20 (slice4; segments: 20) (cost=0.00..2,004.17 rows=472,557 width=17) (never executed)

  • Hash Key: container_operation.barcode
15. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..1,979.03 rows=472,557 width=17) (never executed)

  • Join Filter: true
16. 0.000 0.000 ↓ 0.0 0

Assert (cost=0.00..6.00 rows=1 width=4) (never executed)

  • Assert Cond: ((row_number() OVER (?)) = 1)
17. 0.000 0.000 ↓ 0.0 0

Broadcast Motion 1:20 (slice3) (cost=0.00..6.00 rows=20 width=12) (never executed)

18. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..6.00 rows=1 width=12) (never executed)

19. 0.000 0.000 ↓ 0.0 0

WindowAgg (cost=0.00..6.00 rows=1 width=12) (never executed)

20. 0.000 0.000 ↓ 0.0 0

Gather Motion 20:1 (slice2; segments: 20) (cost=0.00..6.00 rows=1 width=4) (never executed)

21. 0.000 0.000 ↓ 0.0 0

Index Scan using operation_type_code_key on operation_type (cost=0.00..6.00 rows=1 width=4) (never executed)

  • Index Cond: (code = 'IM_CONTAINER_RECALCULATING'::text)
22. 0.000 0.000 ↓ 0.0 0

Sequence (cost=0.00..1,921.93 rows=472,557 width=17) (never executed)

23. 0.000 0.000 ↓ 0.0 0

Partition Selector for container_operation (dynamic scan id: 1) (cost=10.00..100.00 rows=5 width=4) (never executed)

  • Partitions selected: 85 (out of 85)
24. 0.000 0.000 ↓ 0.0 0

Dynamic Bitmap Heap Scan on container_operation (dynamic scan id: 1) (cost=0.00..1,921.93 rows=472,557 width=17) (never executed)

  • Recheck Cond: (type_id = operation_type.id)
  • Heap Blocks: exact=76590472 lossy=48320152
25. 0.000 0.000 ↓ 0.0 0

Dynamic Bitmap Index Scan on title_bmp_idx (cost=0.00..0.00 rows=0 width=0) (never executed)

  • Index Cond: (type_id = operation_type.id)
Planning time : 121.958 ms
Execution time : 35.568 ms