explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wGxv

Settings
# exclusive inclusive rows x rows loops node
1. 1.012 22,249.272 ↓ 1.7 1,917 1

Sort (cost=1,963,129.63..1,963,132.37 rows=1,096 width=100) (actual time=22,249.151..22,249.272 rows=1,917 loops=1)

  • Sort Key: i.order_id, i.mean_id, i.history_place_id, (min(i.position_ts))
  • Sort Method: quicksort Memory: 318kB
2.          

CTE i

3. 4,657.386 19,427.263 ↑ 5.6 336,275 1

Nested Loop (cost=163,127.14..899,477.62 rows=1,872,602 width=679) (actual time=7,136.257..19,427.263 rows=336,275 loops=1)

4. 21.157 7,252.388 ↓ 40.6 8,813 1

Nested Loop (cost=163,126.69..165,305.28 rows=217 width=1,574) (actual time=7,133.608..7,252.388 rows=8,813 loops=1)

5. 39.749 7,187.166 ↓ 40.6 8,813 1

Hash Join (cost=163,126.27..164,935.44 rows=217 width=1,559) (actual time=7,133.549..7,187.166 rows=8,813 loops=1)

  • Hash Cond: ((hpg.id)::numeric = pl.current_history_place)
6. 15.549 15.549 ↓ 1.0 17,811 1

Seq Scan on history_place_geog hpg (cost=0.00..1,718.00 rows=17,800 width=577) (actual time=0.016..15.549 rows=17,811 loops=1)

7. 17.127 7,131.868 ↓ 5.2 8,813 1

Hash (cost=163,105.22..163,105.22 rows=1,684 width=982) (actual time=7,131.868..7,131.868 rows=8,813 loops=1)

  • Buckets: 8192 (originally 2048) Batches: 2 (originally 1) Memory Usage: 6687kB
8. 6.666 7,114.741 ↓ 5.2 8,813 1

Nested Loop (cost=159,841.66..163,105.22 rows=1,684 width=982) (actual time=7,067.877..7,114.741 rows=8,813 loops=1)

9. 3.794 7,072.823 ↓ 5.2 8,813 1

Merge Join (cost=159,841.23..159,888.19 rows=1,684 width=980) (actual time=7,067.822..7,072.823 rows=8,813 loops=1)

  • Merge Cond: ((((o.data #>> '{delivery_site,place_id}'::text[]))::integer) = r.place_id)
10. 1.429 7,067.849 ↓ 7.8 1,155 1

Sort (cost=159,682.73..159,683.10 rows=149 width=976) (actual time=7,067.619..7,067.849 rows=1,155 loops=1)

  • Sort Key: (((o.data #>> '{delivery_site,place_id}'::text[]))::integer)
  • Sort Method: quicksort Memory: 2542kB
11. 12.119 7,066.420 ↓ 9.0 1,334 1

Nested Loop (cost=159,295.54..159,677.35 rows=149 width=976) (actual time=7,043.292..7,066.420 rows=1,334 loops=1)

12. 1.135 7,046.297 ↓ 9.0 1,334 1

Finalize GroupAggregate (cost=159,295.12..159,313.55 rows=149 width=24) (actual time=7,043.241..7,046.297 rows=1,334 loops=1)

  • Group Key: o_1.id, e.mean_id, e.pair_start
13. 125.562 7,045.162 ↓ 18.1 2,250 1

Gather Merge (cost=159,295.12..159,310.82 rows=124 width=24) (actual time=7,043.224..7,045.162 rows=2,250 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
14. 0.571 6,919.600 ↓ 12.1 750 3 / 3

Partial GroupAggregate (cost=158,295.09..158,296.49 rows=62 width=24) (actual time=6,918.903..6,919.600 rows=750 loops=3)

  • Group Key: o_1.id, e.mean_id, e.pair_start
15. 3.245 6,919.029 ↓ 13.7 847 3 / 3

Sort (cost=158,295.09..158,295.25 rows=62 width=24) (actual time=6,918.895..6,919.029 rows=847 loops=3)

  • Sort Key: o_1.id, e.mean_id, e.pair_start
  • Sort Method: quicksort Memory: 80kB
  • Worker 0: Sort Method: quicksort Memory: 63kB
  • Worker 1: Sort Method: quicksort Memory: 87kB
16. 197.570 6,915.784 ↓ 13.7 847 3 / 3

Hash Join (cost=314.60..158,293.25 rows=62 width=24) (actual time=357.974..6,915.784 rows=847 loops=3)

  • Hash Cond: ((o_1.agency_id)::numeric = a.id)
17. 473.126 6,714.798 ↓ 5.6 186,858 3 / 3

Nested Loop (cost=0.98..157,887.74 rows=33,384 width=28) (actual time=3.161..6,714.798 rows=186,858 loops=3)

18. 3,065.086 3,065.086 ↓ 5.6 186,858 3 / 3

Parallel Index Scan using es_event_pairing_idx on es_event e (cost=0.56..100,969.46 rows=33,384 width=24) (actual time=0.149..3,065.086 rows=186,858 loops=3)

  • Index Cond: ((name = ANY ('{ORDER_IS_PAIR,ORDER_IS_UNPAIR}'::text[])) AND (pair_start >= '2019-12-01 00:00:00'::timestamp without time zone))
19. 3,176.586 3,176.586 ↑ 1.0 1 560,574 / 3

Index Scan using es_order_pk on es_order o_1 (cost=0.43..1.70 rows=1 width=8) (actual time=0.017..0.017 rows=1 loops=560,574)

  • Index Cond: (id = e.order_id)
20. 0.024 3.416 ↑ 1.0 9 3 / 3

Hash (cost=313.50..313.50 rows=9 width=5) (actual time=3.416..3.416 rows=9 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
21. 3.392 3.392 ↑ 1.0 9 3 / 3

Seq Scan on agencies a (cost=0.00..313.50 rows=9 width=5) (actual time=2.489..3.392 rows=9 loops=3)

  • Filter: (organization_id = '5660'::numeric)
  • Rows Removed by Filter: 5206
22. 8.004 8.004 ↑ 1.0 1 1,334

Index Scan using es_order_pk on es_order o (cost=0.43..2.43 rows=1 width=956) (actual time=0.006..0.006 rows=1 loops=1,334)

  • Index Cond: (id = o_1.id)
23. 1.138 1.180 ↓ 3.7 8,269 1

Sort (cost=158.51..164.16 rows=2,260 width=8) (actual time=0.057..1.180 rows=8,269 loops=1)

  • Sort Key: r.place_id
  • Sort Method: quicksort Memory: 26kB
24. 0.042 0.042 ↑ 83.7 27 1

Seq Scan on bridge_place_renault r (cost=0.00..32.60 rows=2,260 width=8) (actual time=0.038..0.042 rows=27 loops=1)

25. 35.252 35.252 ↑ 1.0 1 8,813

Index Scan using places_pkey on places pl (cost=0.42..1.91 rows=1 width=12) (actual time=0.004..0.004 rows=1 loops=8,813)

  • Index Cond: (id = (r.sub_place_id)::numeric)
26. 44.065 44.065 ↑ 1.0 1 8,813

Index Scan using history_place_pkey on history_place hp (cost=0.42..1.70 rows=1 width=27) (actual time=0.005..0.005 rows=1 loops=8,813)

  • Index Cond: (id = pl.current_history_place)
27. 5,076.288 7,517.489 ↑ 14.7 38 8,813

Append (cost=0.45..637.82 rows=560 width=28) (actual time=0.729..0.853 rows=38 loops=8,813)

28. 35.252 35.252 ↓ 0.0 0 8,813

Index Scan using _hyper_1_1_chunk_position_reorder_chunk_idx on _hyper_1_1_chunk p (cost=0.45..12.36 rows=11 width=28) (actual time=0.004..0.004 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
29. 26.439 26.439 ↓ 0.0 0 8,813

Index Scan using _hyper_1_2_chunk_position_reorder_chunk_idx on _hyper_1_2_chunk p_1 (cost=0.45..12.36 rows=11 width=28) (actual time=0.003..0.003 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
30. 26.439 26.439 ↓ 0.0 0 8,813

Index Scan using _hyper_1_3_chunk_position_reorder_chunk_idx on _hyper_1_3_chunk p_2 (cost=0.45..10.33 rows=9 width=28) (actual time=0.003..0.003 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
31. 26.439 26.439 ↓ 0.0 0 8,813

Index Scan using _hyper_1_4_chunk_position_reorder_chunk_idx on _hyper_1_4_chunk p_3 (cost=0.45..11.31 rows=10 width=28) (actual time=0.003..0.003 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
32. 35.252 35.252 ↓ 0.0 0 8,813

Index Scan using _hyper_1_5_chunk_position_reorder_chunk_idx on _hyper_1_5_chunk p_4 (cost=0.45..12.40 rows=11 width=28) (actual time=0.004..0.004 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
33. 35.252 35.252 ↓ 0.0 0 8,813

Index Scan using _hyper_1_6_chunk_position_reorder_chunk_idx on _hyper_1_6_chunk p_5 (cost=0.45..11.37 rows=10 width=28) (actual time=0.004..0.004 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
34. 35.252 35.252 ↓ 0.0 0 8,813

Index Scan using _hyper_1_7_chunk_position_reorder_chunk_idx on _hyper_1_7_chunk p_6 (cost=0.45..11.42 rows=10 width=28) (actual time=0.004..0.004 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
35. 35.252 35.252 ↓ 0.0 0 8,813

Index Scan using _hyper_1_8_chunk_position_reorder_chunk_idx on _hyper_1_8_chunk p_7 (cost=0.45..11.41 rows=10 width=28) (actual time=0.004..0.004 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
36. 35.252 35.252 ↓ 0.0 0 8,813

Index Scan using _hyper_1_9_chunk_position_reorder_chunk_idx on _hyper_1_9_chunk p_8 (cost=0.45..10.39 rows=9 width=28) (actual time=0.004..0.004 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
37. 35.252 35.252 ↓ 0.0 0 8,813

Index Scan using _hyper_1_10_chunk_position_reorder_chunk_idx on _hyper_1_10_chunk p_9 (cost=0.45..10.36 rows=9 width=28) (actual time=0.004..0.004 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
38. 35.252 35.252 ↓ 0.0 0 8,813

Index Scan using _hyper_1_11_chunk_position_reorder_chunk_idx on _hyper_1_11_chunk p_10 (cost=0.45..12.39 rows=11 width=28) (actual time=0.004..0.004 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
39. 35.252 35.252 ↓ 0.0 0 8,813

Index Scan using _hyper_1_12_chunk_position_reorder_chunk_idx on _hyper_1_12_chunk p_11 (cost=0.45..11.37 rows=10 width=28) (actual time=0.004..0.004 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
40. 35.252 35.252 ↓ 0.0 0 8,813

Index Scan using _hyper_1_13_chunk_position_reorder_chunk_idx on _hyper_1_13_chunk p_12 (cost=0.45..12.39 rows=11 width=28) (actual time=0.004..0.004 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
41. 35.252 35.252 ↓ 0.0 0 8,813

Index Scan using _hyper_1_14_chunk_position_reorder_chunk_idx on _hyper_1_14_chunk p_13 (cost=0.45..11.42 rows=10 width=28) (actual time=0.004..0.004 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
42. 35.252 35.252 ↓ 0.0 0 8,813

Index Scan using _hyper_1_15_chunk_position_reorder_chunk_idx on _hyper_1_15_chunk p_14 (cost=0.45..12.39 rows=11 width=28) (actual time=0.004..0.004 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
43. 26.439 26.439 ↓ 0.0 0 8,813

Index Scan using _hyper_1_16_chunk_position_reorder_chunk_idx on _hyper_1_16_chunk p_15 (cost=0.45..12.32 rows=11 width=28) (actual time=0.003..0.003 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
44. 26.439 26.439 ↓ 0.0 0 8,813

Index Scan using _hyper_1_17_chunk_position_reorder_chunk_idx on _hyper_1_17_chunk p_16 (cost=0.45..12.35 rows=11 width=28) (actual time=0.003..0.003 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
45. 35.252 35.252 ↓ 0.0 0 8,813

Index Scan using _hyper_1_18_chunk_position_reorder_chunk_idx on _hyper_1_18_chunk p_17 (cost=0.45..12.34 rows=11 width=28) (actual time=0.004..0.004 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
46. 35.252 35.252 ↓ 0.0 0 8,813

Index Scan using _hyper_1_19_chunk_position_reorder_chunk_idx on _hyper_1_19_chunk p_18 (cost=0.45..12.39 rows=11 width=28) (actual time=0.004..0.004 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
47. 26.439 26.439 ↓ 0.0 0 8,813

Index Scan using _hyper_1_23_chunk_position_reorder_chunk_idx on _hyper_1_23_chunk p_19 (cost=0.45..12.35 rows=11 width=28) (actual time=0.003..0.003 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
48. 26.439 26.439 ↓ 0.0 0 8,813

Index Scan using _hyper_1_24_chunk_position_reorder_chunk_idx on _hyper_1_24_chunk p_20 (cost=0.45..13.32 rows=12 width=28) (actual time=0.003..0.003 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
49. 26.439 26.439 ↓ 0.0 0 8,813

Index Scan using _hyper_1_25_chunk_position_reorder_chunk_idx on _hyper_1_25_chunk p_21 (cost=0.45..12.34 rows=11 width=28) (actual time=0.003..0.003 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
50. 26.439 26.439 ↓ 0.0 0 8,813

Index Scan using _hyper_1_26_chunk_position_reorder_chunk_idx on _hyper_1_26_chunk p_22 (cost=0.45..12.34 rows=11 width=28) (actual time=0.003..0.003 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
51. 35.252 35.252 ↓ 0.0 0 8,813

Index Scan using _hyper_1_27_chunk_position_reorder_chunk_idx on _hyper_1_27_chunk p_23 (cost=0.45..10.37 rows=9 width=28) (actual time=0.004..0.004 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
52. 35.252 35.252 ↓ 0.0 0 8,813

Index Scan using _hyper_1_28_chunk_position_reorder_chunk_idx on _hyper_1_28_chunk p_24 (cost=0.45..10.33 rows=9 width=28) (actual time=0.004..0.004 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
53. 35.252 35.252 ↓ 0.0 0 8,813

Index Scan using _hyper_1_29_chunk_position_reorder_chunk_idx on _hyper_1_29_chunk p_25 (cost=0.45..12.36 rows=11 width=28) (actual time=0.004..0.004 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
54. 35.252 35.252 ↓ 0.0 0 8,813

Index Scan using _hyper_1_30_chunk_position_reorder_chunk_idx on _hyper_1_30_chunk p_26 (cost=0.45..11.39 rows=10 width=28) (actual time=0.004..0.004 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
55. 35.252 35.252 ↓ 0.0 0 8,813

Index Scan using _hyper_1_32_chunk_position_reorder_chunk_idx on _hyper_1_32_chunk p_27 (cost=0.45..12.35 rows=11 width=28) (actual time=0.004..0.004 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
56. 26.439 26.439 ↓ 0.0 0 8,813

Index Scan using _hyper_1_33_chunk_position_reorder_chunk_idx on _hyper_1_33_chunk p_28 (cost=0.45..12.36 rows=11 width=28) (actual time=0.003..0.003 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
57. 26.439 26.439 ↓ 0.0 0 8,813

Index Scan using _hyper_1_35_chunk_position_reorder_chunk_idx on _hyper_1_35_chunk p_29 (cost=0.45..11.35 rows=10 width=28) (actual time=0.003..0.003 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
58. 35.252 35.252 ↓ 0.0 0 8,813

Index Scan using _hyper_1_36_chunk_position_reorder_chunk_idx on _hyper_1_36_chunk p_30 (cost=0.45..11.40 rows=10 width=28) (actual time=0.004..0.004 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
59. 35.252 35.252 ↓ 0.0 0 8,813

Index Scan using _hyper_1_37_chunk_position_reorder_chunk_idx on _hyper_1_37_chunk p_31 (cost=0.45..11.42 rows=10 width=28) (actual time=0.004..0.004 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
60. 35.252 35.252 ↓ 0.0 0 8,813

Index Scan using _hyper_1_38_chunk_position_reorder_chunk_idx on _hyper_1_38_chunk p_32 (cost=0.45..11.41 rows=10 width=28) (actual time=0.004..0.004 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
61. 35.252 35.252 ↓ 0.0 0 8,813

Index Scan using _hyper_1_39_chunk_position_reorder_chunk_idx on _hyper_1_39_chunk p_33 (cost=0.45..11.43 rows=10 width=28) (actual time=0.004..0.004 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
62. 35.252 35.252 ↓ 0.0 0 8,813

Index Scan using _hyper_1_40_chunk_position_reorder_chunk_idx on _hyper_1_40_chunk p_34 (cost=0.45..11.42 rows=10 width=28) (actual time=0.004..0.004 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
63. 17.626 17.626 ↓ 0.0 0 8,813

Seq Scan on _hyper_1_41_chunk p_35 (cost=0.00..1.04 rows=1 width=28) (actual time=0.002..0.002 rows=0 loops=8,813)

  • Filter: ((position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (e.mean_id = mean_id) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
  • Rows Removed by Filter: 1
64. 35.252 35.252 ↓ 0.0 0 8,813

Index Scan using _hyper_1_42_chunk_position_reorder_chunk_idx on _hyper_1_42_chunk p_36 (cost=0.45..11.44 rows=10 width=28) (actual time=0.004..0.004 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
65. 35.252 35.252 ↓ 0.0 0 8,813

Index Scan using _hyper_1_44_chunk_position_reorder_chunk_idx on _hyper_1_44_chunk p_37 (cost=0.45..11.44 rows=10 width=28) (actual time=0.004..0.004 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
66. 35.252 35.252 ↓ 0.0 0 8,813

Index Scan using _hyper_1_45_chunk_position_reorder_chunk_idx on _hyper_1_45_chunk p_38 (cost=0.45..11.44 rows=10 width=28) (actual time=0.004..0.004 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
67. 35.252 35.252 ↓ 0.0 0 8,813

Index Scan using _hyper_1_46_chunk_position_reorder_chunk_idx on _hyper_1_46_chunk p_39 (cost=0.45..12.44 rows=11 width=28) (actual time=0.004..0.004 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
68. 35.252 35.252 ↓ 0.0 0 8,813

Index Scan using _hyper_1_47_chunk_position_reorder_chunk_idx on _hyper_1_47_chunk p_40 (cost=0.45..11.38 rows=10 width=28) (actual time=0.004..0.004 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
69. 35.252 35.252 ↓ 0.0 0 8,813

Index Scan using _hyper_1_48_chunk_position_reorder_chunk_idx on _hyper_1_48_chunk p_41 (cost=0.45..10.43 rows=9 width=28) (actual time=0.004..0.004 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
70. 44.065 44.065 ↓ 0.0 0 8,813

Index Scan using _hyper_1_49_chunk_position_reorder_chunk_idx on _hyper_1_49_chunk p_42 (cost=0.45..11.47 rows=10 width=28) (actual time=0.005..0.005 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
71. 44.065 44.065 ↓ 0.0 0 8,813

Index Scan using _hyper_1_174_chunk_position_reorder_chunk_idx on _hyper_1_174_chunk p_43 (cost=0.45..12.45 rows=11 width=28) (actual time=0.005..0.005 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
72. 132.195 132.195 ↑ 1.8 6 8,813

Index Scan using _hyper_1_178_chunk_position_reorder_chunk_idx on _hyper_1_178_chunk p_44 (cost=0.45..12.45 rows=11 width=28) (actual time=0.006..0.015 rows=6 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
73. 211.512 211.512 ↓ 1.2 12 8,813

Index Scan using _hyper_1_182_chunk_position_reorder_chunk_idx on _hyper_1_182_chunk p_45 (cost=0.45..11.47 rows=10 width=28) (actual time=0.006..0.024 rows=12 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
74. 211.512 211.512 ↓ 1.2 12 8,813

Index Scan using _hyper_1_187_chunk_position_reorder_chunk_idx on _hyper_1_187_chunk p_46 (cost=0.45..11.47 rows=10 width=28) (actual time=0.006..0.024 rows=12 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
75. 88.130 88.130 ↑ 3.3 3 8,813

Index Scan using _hyper_1_192_chunk_position_reorder_chunk_idx on _hyper_1_192_chunk p_47 (cost=0.45..11.26 rows=10 width=28) (actual time=0.005..0.010 rows=3 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
76. 35.252 35.252 ↓ 0.0 0 8,813

Index Scan using _hyper_1_197_chunk_position_reorder_chunk_idx on _hyper_1_197_chunk p_48 (cost=0.45..10.23 rows=9 width=28) (actual time=0.004..0.004 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
77. 35.252 35.252 ↓ 0.0 0 8,813

Index Scan using _hyper_1_202_chunk_position_reorder_chunk_idx on _hyper_1_202_chunk p_49 (cost=0.45..13.40 rows=12 width=28) (actual time=0.004..0.004 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
78. 35.252 35.252 ↓ 0.0 0 8,813

Index Scan using _hyper_1_207_chunk_position_reorder_chunk_idx on _hyper_1_207_chunk p_50 (cost=0.45..14.43 rows=13 width=28) (actual time=0.004..0.004 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
79. 35.252 35.252 ↓ 0.0 0 8,813

Index Scan using _hyper_1_213_chunk_position_reorder_chunk_idx on _hyper_1_213_chunk p_51 (cost=0.45..14.44 rows=13 width=28) (actual time=0.004..0.004 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
80. 35.252 35.252 ↓ 0.0 0 8,813

Index Scan using _hyper_1_248_chunk_position_reorder_chunk_idx on _hyper_1_248_chunk p_52 (cost=0.45..13.46 rows=12 width=28) (actual time=0.004..0.004 rows=0 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
81. 105.756 105.756 ↑ 3.0 4 8,813

Index Scan using _hyper_1_270_chunk_position_reorder_chunk_idx on _hyper_1_270_chunk p_53 (cost=0.45..13.48 rows=12 width=28) (actual time=0.005..0.012 rows=4 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
82. 61.691 61.691 ↑ 3.0 1 8,813

Index Scan using _hyper_1_276_chunk_position_reorder_chunk_idx on _hyper_1_276_chunk p_54 (cost=0.45..4.38 rows=3 width=28) (actual time=0.004..0.007 rows=1 loops=8,813)

  • Index Cond: ((mean_id = e.mean_id) AND (position_ts >= e.pair_start) AND (position_ts <= (max(e.pair_end))) AND (position_ts >= (((o.data #>> '{delivery_slot,start}'::text[]))::timestamp without time zone - '01:00:00'::interval)) AND (position_ts <= (((o.data #>> '{delivery_slot,end}'::text[]))::timestamp without time zone + '06:00:00'::interval)))
83.          

CTE ns

84. 356.985 20,732.516 ↑ 5.6 336,275 1

WindowAgg (cost=254,491.45..310,669.51 rows=1,872,602 width=24) (actual time=20,301.302..20,732.516 rows=336,275 loops=1)

85. 398.948 20,375.531 ↑ 5.6 336,275 1

Sort (cost=254,491.45..259,172.96 rows=1,872,602 width=21) (actual time=20,301.270..20,375.531 rows=336,275 loops=1)

  • Sort Key: i_1.order_id, i_1.mean_id, i_1.history_place_id, i_1.position_ts
  • Sort Method: external merge Disk: 11552kB
86. 19,976.583 19,976.583 ↑ 5.6 336,275 1

CTE Scan on i i_1 (cost=0.00..37,452.04 rows=1,872,602 width=21) (actual time=7,136.262..19,976.583 rows=336,275 loops=1)

87.          

CTE s

88. 415.535 21,482.485 ↑ 5.6 336,275 1

WindowAgg (cost=254,491.45..301,306.50 rows=1,872,602 width=28) (actual time=20,988.616..21,482.485 rows=336,275 loops=1)

89. 180.448 21,066.950 ↑ 5.6 336,275 1

Sort (cost=254,491.45..259,172.96 rows=1,872,602 width=24) (actual time=20,988.600..21,066.950 rows=336,275 loops=1)

  • Sort Key: ns.order_id, ns.mean_id, ns.history_place_id, ns.position_ts
  • Sort Method: external merge Disk: 12528kB
90. 20,886.502 20,886.502 ↑ 5.6 336,275 1

CTE Scan on ns (cost=0.00..37,452.04 rows=1,872,602 width=24) (actual time=20,301.304..20,886.502 rows=336,275 loops=1)

91. 41.848 22,248.260 ↓ 1.7 1,917 1

GroupAggregate (cost=451,585.03..451,620.65 rows=1,096 width=100) (actual time=22,193.627..22,248.260 rows=1,917 loops=1)

  • Group Key: i.order_id, i.order_reference, i.mean_id, i.history_place_id, i.site_name, s.intersects_sequence
92. 68.631 22,206.412 ↓ 65.1 71,323 1

Sort (cost=451,585.03..451,587.77 rows=1,096 width=92) (actual time=22,193.602..22,206.412 rows=71,323 loops=1)

  • Sort Key: i.order_id, i.order_reference, i.mean_id, i.history_place_id, i.site_name, s.intersects_sequence
  • Sort Method: external merge Disk: 5312kB
93. 80.455 22,137.781 ↓ 65.1 71,323 1

Merge Join (cost=414,066.70..451,529.70 rows=1,096 width=92) (actual time=21,998.123..22,137.781 rows=71,323 loops=1)

  • Merge Cond: ((s.order_id = i.order_id) AND (s.mean_id = i.mean_id) AND (s.history_place_id = i.history_place_id) AND (s.position_ts = i.position_ts))
94. 188.789 21,927.275 ↑ 5.6 335,739 1

Sort (cost=258,147.45..262,828.96 rows=1,872,602 width=28) (actual time=21,877.133..21,927.275 rows=335,739 loops=1)

  • Sort Key: s.order_id, s.mean_id, s.history_place_id, s.position_ts
  • Sort Method: external merge Disk: 13840kB
95. 21,738.486 21,738.486 ↑ 5.6 336,275 1

CTE Scan on s (cost=0.00..37,452.04 rows=1,872,602 width=28) (actual time=20,988.619..21,738.486 rows=336,275 loops=1)

96. 7.392 130.051 ↑ 13.1 71,323 1

Materialize (cost=155,919.24..160,600.75 rows=936,301 width=84) (actual time=120.967..130.051 rows=71,323 loops=1)

97. 29.446 122.659 ↑ 55.6 16,844 1

Sort (cost=155,919.24..158,259.99 rows=936,301 width=84) (actual time=120.958..122.659 rows=16,844 loops=1)

  • Sort Key: i.order_id, i.mean_id, i.history_place_id, i.position_ts
  • Sort Method: quicksort Memory: 2822kB
98. 93.213 93.213 ↑ 55.6 16,844 1

CTE Scan on i (cost=0.00..37,452.04 rows=936,301 width=84) (actual time=0.052..93.213 rows=16,844 loops=1)

  • Filter: geofence_intersects
  • Rows Removed by Filter: 319431
Planning time : 10.852 ms
Execution time : 22,297.809 ms