explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Kfdi

Settings
# exclusive inclusive rows x rows loops node
1. 1.674 22,188.301 ↓ 1.7 1,917 1

Sort (cost=1,478,593.32..1,478,596.06 rows=1,096 width=100) (actual time=22,188.107..22,188.301 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,734.739 19,947.853 ↑ 5.6 336,275 1

Nested Loop (cost=163,127.14..899,483.65 rows=1,872,621 width=679) (actual time=7,353.319..19,947.853 rows=336,275 loops=1)

4. 25.647 7,484.113 ↓ 40.6 8,813 1

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

5. 50.480 7,414.401 ↓ 40.6 8,813 1

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

  • Hash Cond: ((hpg.id)::numeric = pl.current_history_place)
6. 13.891 13.891 ↓ 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.013..13.891 rows=17,811 loops=1)

7. 13.805 7,350.030 ↓ 5.2 8,813 1

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

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

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

9. 3.549 7,287.824 ↓ 5.2 8,813 1

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

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

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

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

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

12. 1.244 7,235.387 ↓ 9.0 1,334 1

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

  • Group Key: o_1.id, e.mean_id, e.pair_start
13. 53.019 7,234.143 ↓ 16.9 2,090 1

Gather Merge (cost=159,295.12..159,310.82 rows=124 width=24) (actual time=7,231.972..7,234.143 rows=2,090 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
14. 0.586 7,181.124 ↓ 11.2 697 3 / 3

Partial GroupAggregate (cost=158,295.09..158,296.49 rows=62 width=24) (actual time=7,180.397..7,181.124 rows=697 loops=3)

  • Group Key: o_1.id, e.mean_id, e.pair_start
15. 1.008 7,180.538 ↓ 13.7 847 3 / 3

Sort (cost=158,295.09..158,295.25 rows=62 width=24) (actual time=7,180.387..7,180.538 rows=847 loops=3)

  • Sort Key: o_1.id, e.mean_id, e.pair_start
  • Sort Method: quicksort Memory: 116kB
  • Worker 0: Sort Method: quicksort Memory: 85kB
  • Worker 1: Sort Method: quicksort Memory: 54kB
16. 224.002 7,179.530 ↓ 13.7 847 3 / 3

Hash Join (cost=314.60..158,293.25 rows=62 width=24) (actual time=422.164..7,179.530 rows=847 loops=3)

  • Hash Cond: ((o_1.agency_id)::numeric = a.id)
17. 347.558 6,952.058 ↓ 5.6 186,865 3 / 3

Nested Loop (cost=0.98..157,887.74 rows=33,384 width=28) (actual time=0.177..6,952.058 rows=186,865 loops=3)

18. 3,240.930 3,240.930 ↓ 5.6 186,865 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.093..3,240.930 rows=186,865 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,363.570 3,363.570 ↑ 1.0 1 560,595 / 3

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

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

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

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

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

  • Filter: (organization_id = '5660'::numeric)
  • Rows Removed by Filter: 5206
22. 9.338 9.338 ↑ 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.007..0.007 rows=1 loops=1,334)

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

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

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

Seq Scan on bridge_place_renault r (cost=0.00..32.60 rows=2,260 width=8) (actual time=0.021..0.024 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,252.548 7,729.001 ↑ 14.7 38 8,813

Append (cost=0.45..637.82 rows=560 width=28) (actual time=0.747..0.877 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. 44.065 44.065 ↓ 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.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)))
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. 44.065 44.065 ↓ 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.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)))
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. 35.252 35.252 ↓ 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.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)))
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. 35.252 35.252 ↓ 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.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)))
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. 26.439 26.439 ↓ 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.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)))
53. 26.439 26.439 ↓ 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.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)))
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. 35.252 35.252 ↓ 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.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)))
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. 44.065 44.065 ↓ 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.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)))
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. 123.382 123.382 ↑ 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.005..0.014 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. 220.325 220.325 ↓ 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.025 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. 79.317 79.317 ↑ 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.009 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. 114.569 114.569 ↑ 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.013 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. 55.700 22,186.627 ↓ 1.7 1,917 1

GroupAggregate (cost=579,018.71..579,054.33 rows=1,096 width=100) (actual time=22,106.459..22,186.627 rows=1,917 loops=1)

  • Group Key: i.order_id, i.order_reference, i.mean_id, i.history_place_id, i.site_name, (sum(((COALESCE((i_1.geofence_intersects <> lag(i_1.geofence_intersects) OVER (?)), false))::integer)) OVER (?))
84. 98.123 22,130.927 ↓ 65.1 71,323 1

Sort (cost=579,018.71..579,021.45 rows=1,096 width=92) (actual time=22,106.435..22,130.927 rows=71,323 loops=1)

  • Sort Key: i.order_id, i.order_reference, i.mean_id, i.history_place_id, i.site_name, (sum(((COALESCE((i_1.geofence_intersects <> lag(i_1.geofence_intersects) OVER (?)), false))::integer)) OVER (?))
  • Sort Method: external merge Disk: 5312kB
85. 79.868 22,032.804 ↓ 65.1 71,323 1

Merge Join (cost=410,416.53..578,963.37 rows=1,096 width=92) (actual time=21,059.510..22,032.804 rows=71,323 loops=1)

  • Merge Cond: ((i_1.order_id = i.order_id) AND (i_1.mean_id = i.mean_id) AND (i_1.history_place_id = i.history_place_id) AND (i_1.position_ts = i.position_ts))
86. 407.364 21,759.723 ↑ 5.6 335,739 1

WindowAgg (cost=254,493.95..371,532.76 rows=1,872,621 width=28) (actual time=20,877.845..21,759.723 rows=335,739 loops=1)

87. 388.545 21,352.359 ↑ 5.6 335,740 1

WindowAgg (cost=254,493.95..310,672.58 rows=1,872,621 width=24) (actual time=20,877.827..21,352.359 rows=335,740 loops=1)

88. 445.003 20,963.814 ↑ 5.6 335,741 1

Sort (cost=254,493.95..259,175.50 rows=1,872,621 width=21) (actual time=20,877.808..20,963.814 rows=335,741 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
89. 20,518.811 20,518.811 ↑ 5.6 336,275 1

CTE Scan on i i_1 (cost=0.00..37,452.42 rows=1,872,621 width=21) (actual time=7,353.325..20,518.811 rows=336,275 loops=1)

90. 9.177 193.213 ↑ 13.1 71,323 1

Materialize (cost=155,922.58..160,604.13 rows=936,310 width=84) (actual time=181.584..193.213 rows=71,323 loops=1)

91. 46.525 184.036 ↑ 55.6 16,844 1

Sort (cost=155,922.58..158,263.35 rows=936,310 width=84) (actual time=181.571..184.036 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
92. 137.511 137.511 ↑ 55.6 16,844 1

CTE Scan on i (cost=0.00..37,452.42 rows=936,310 width=84) (actual time=0.050..137.511 rows=16,844 loops=1)

  • Filter: geofence_intersects
  • Rows Removed by Filter: 319431
Planning time : 11.414 ms
Execution time : 22,220.609 ms