explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RaRL

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 1,521.262 ↑ 1.0 50 1

Limit (cost=28,439.72..28,439.85 rows=50 width=316) (actual time=1,521.251..1,521.262 rows=50 loops=1)

2.          

CTE cte_root

3. 0.597 2.043 ↓ 3.0 1,724 1

HashAggregate (cost=1,363.34..1,369.09 rows=575 width=8) (actual time=1.787..2.043 rows=1,724 loops=1)

  • Group Key: o_1.id, o_1.customer_id
4. 0.139 1.446 ↓ 3.0 1,724 1

Append (cost=14.17..1,360.47 rows=575 width=8) (actual time=0.729..1.446 rows=1,724 loops=1)

5. 0.580 1.287 ↓ 3.0 1,724 1

Bitmap Heap Scan on orders o_1 (cost=14.17..1,351.81 rows=573 width=8) (actual time=0.728..1.287 rows=1,724 loops=1)

  • Recheck Cond: ((create_stamp > '2020-07-30 00:00:00+00'::timestamp with time zone) AND (create_stamp < '2020-08-02 00:00:00+00'::timestamp with time zone))
  • Filter: (location_id = ANY ('{51,52,53,54,55}'::integer[]))
  • Heap Blocks: exact=122
6. 0.707 0.707 ↓ 3.1 1,768 1

Bitmap Index Scan on orders_create_stamp (cost=0.00..14.02 rows=573 width=0) (actual time=0.707..0.707 rows=1,768 loops=1)

  • Index Cond: ((create_stamp > '2020-07-30 00:00:00+00'::timestamp with time zone) AND (create_stamp < '2020-08-02 00:00:00+00'::timestamp with time zone))
7. 0.001 0.002 ↓ 0.0 0 1

HashAggregate (cost=0.00..0.01 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Group Key: order_id, customer_id
8. 0.001 0.001 ↓ 0.0 0 1

Result (cost=0.00..0.00 rows=0 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • One-Time Filter: false
9. 0.001 0.018 ↓ 0.0 0 1

Limit (cost=0.01..0.02 rows=1 width=8) (actual time=0.018..0.018 rows=0 loops=1)

10. 0.016 0.017 ↓ 0.0 0 1

Sort (cost=0.01..0.02 rows=0 width=8) (actual time=0.017..0.017 rows=0 loops=1)

  • Sort Key: id DESC
  • Sort Method: quicksort Memory: 25kB
11. 0.001 0.001 ↓ 0.0 0 1

Result (cost=0.00..0.00 rows=0 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • One-Time Filter: false
12.          

CTE cte_reserved_slots_grouped_by_start_time

13. 0.000 0.000 ↓ 0.0 0

Unique (cost=7,388.38..7,392.38 rows=200 width=37) (never executed)

14. 0.000 0.000 ↓ 0.0 0

Sort (cost=7,388.38..7,388.88 rows=200 width=37) (never executed)

  • Sort Key: reserved_slots_grouped_by_item_id.order_id, ((sum(reserved_slots_grouped_by_item_id.total_gross_slots))::integer), ((sum(reserved_slots_grouped_by_item_id.count_reserved))::integer), reserved_slots_grouped_by_item_id.item_scheduled_start_time, (max(reserved_slots_grouped_by_item_id.end_time)), (bool_or(reserved_slots_grouped_by_item_id.is_all_day_event)), (min(reserved_slots_grouped_by_item_id.all_day_date))
15. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=7,352.20..7,380.74 rows=200 width=37) (never executed)

  • Group Key: reserved_slots_grouped_by_item_id.order_id, reserved_slots_grouped_by_item_id.item_scheduled_start_time
16. 0.000 0.000 ↓ 0.0 0

Sort (cost=7,352.20..7,355.39 rows=1,277 width=37) (never executed)

  • Sort Key: reserved_slots_grouped_by_item_id.order_id, reserved_slots_grouped_by_item_id.item_scheduled_start_time
17. 0.000 0.000 ↓ 0.0 0

Subquery Scan on reserved_slots_grouped_by_item_id (cost=7,244.81..7,286.32 rows=1,277 width=37) (never executed)

18. 0.000 0.000 ↓ 0.0 0

Unique (cost=7,244.81..7,273.55 rows=1,277 width=57) (never executed)

19. 0.000 0.000 ↓ 0.0 0

Sort (cost=7,244.81..7,248.01 rows=1,277 width=57) (never executed)

  • Sort Key: o_2.id, (max(COALESCE((rs.qty_people_included * rs.qty), 0))), ((min(COALESCE((COALESCE(count(*), '0'::bigint)), '0'::bigint)))::integer), rs.order_item_id, (min(rs.item_scheduled_start_time)), (max(rs.end_time)), (bool_or(rs.is_all_day_event)), (min(rs.all_day_date))
20. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=7,121.46..7,178.93 rows=1,277 width=57) (never executed)

  • Group Key: o_2.id, rs.order_item_id, rs.qty_people_included, rs.qty, (COALESCE(count(*), '0'::bigint))
21. 0.000 0.000 ↓ 0.0 0

Sort (cost=7,121.46..7,124.66 rows=1,277 width=49) (never executed)

  • Sort Key: o_2.id, rs.order_item_id, rs.qty_people_included, rs.qty, (COALESCE(count(*), '0'::bigint))
22. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=6,242.20..7,055.58 rows=1,277 width=49) (never executed)

  • Hash Cond: (oi.id = poat.order_item_id)
23. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=6,241.13..7,049.71 rows=1,277 width=53) (never executed)

  • Hash Cond: (oi.sku = p.id)
24. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=6,147.29..6,952.50 rows=1,277 width=57) (never executed)

  • Hash Cond: (crspl.reserved_slot_id = rs.id)
25. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=1,741.52..2,079.45 rows=33,793 width=12) (never executed)

  • Group Key: crspl.reserved_slot_id
26. 0.000 0.000 ↓ 0.0 0

Seq Scan on customer_reserved_slot_participation_link crspl (cost=0.00..1,382.01 rows=71,901 width=4) (never executed)

27. 0.000 0.000 ↓ 0.0 0

Hash (cost=4,389.81..4,389.81 rows=1,277 width=53) (never executed)

28. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=2.72..4,389.81 rows=1,277 width=53) (never executed)

  • Hash Cond: (rs.facility_id = f.id)
29. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.13..4,383.39 rows=1,581 width=57) (never executed)

30. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.71..3,463.64 rows=1,592 width=12) (never executed)

  • Join Filter: (cdf.order_id = oi.order_id)
31. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.29..3,057.75 rows=575 width=8) (never executed)

32. 0.000 0.000 ↓ 0.0 0

CTE Scan on cte_root cdf (cost=0.00..11.50 rows=575 width=4) (never executed)

33. 0.000 0.000 ↓ 0.0 0

Index Only Scan using orders_pkey on orders o_2 (cost=0.29..5.30 rows=1 width=4) (never executed)

  • Index Cond: (id = cdf.order_id)
  • Heap Fetches: 0
34. 0.000 0.000 ↓ 0.0 0

Index Scan using order_items_order_id on order_items oi (cost=0.42..0.67 rows=3 width=12) (never executed)

  • Index Cond: (order_id = o_2.id)
35. 0.000 0.000 ↓ 0.0 0

Index Scan using reserved_slots_order_item_id on reserved_slots rs (cost=0.42..0.56 rows=2 width=45) (never executed)

  • Index Cond: (order_item_id = oi.id)
  • Filter: (qty > 0)
36. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.32..1.32 rows=21 width=4) (never executed)

37. 0.000 0.000 ↓ 0.0 0

Seq Scan on facilities f (cost=0.00..1.32 rows=21 width=4) (never executed)

  • Filter: (facility_type = ANY ('{0,3}'::integer[]))
38. 0.000 0.000 ↓ 0.0 0

Hash (cost=76.77..76.77 rows=1,366 width=4) (never executed)

39. 0.000 0.000 ↓ 0.0 0

Index Only Scan using products_pkey on products p (cost=0.28..76.77 rows=1,366 width=4) (never executed)

  • Heap Fetches: 0
40. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.05..1.05 rows=2 width=4) (never executed)

41. 0.000 0.000 ↓ 0.0 0

Seq Scan on products_on_account_transactions poat (cost=0.00..1.05 rows=2 width=4) (never executed)

  • Filter: created_as_rain_check
42.          

CTE cte_reserved_slots_grouped_by_order_id

43. 0.194 54.881 ↓ 4.6 929 1

Unique (cost=7,319.31..7,323.31 rows=200 width=37) (actual time=54.646..54.881 rows=929 loops=1)

44. 0.209 54.687 ↓ 4.6 929 1

Sort (cost=7,319.31..7,319.81 rows=200 width=37) (actual time=54.645..54.687 rows=929 loops=1)

  • Sort Key: o_3.id, ((sum((max(COALESCE((rs_1.qty_people_included * rs_1.qty), 0)))))::integer), ((sum(((min(COALESCE((COALESCE(count(*), '0'::bigint)), '0'::bigint)))::integer)))::integer), (min((min(rs_1.item_scheduled_start_time)))), (max((max(rs_1.end_time)))), (bool_or((bool_or(rs_1.is_all_day_event)))), (min((min(rs_1.all_day_date))))
  • Sort Method: quicksort Memory: 97kB
45. 0.431 54.478 ↓ 4.6 929 1

GroupAggregate (cost=7,244.81..7,311.66 rows=200 width=37) (actual time=53.695..54.478 rows=929 loops=1)

  • Group Key: o_3.id
46. 0.297 54.047 ↓ 1.1 1,431 1

Unique (cost=7,244.81..7,273.55 rows=1,277 width=57) (actual time=53.685..54.047 rows=1,431 loops=1)

47. 0.550 53.750 ↓ 1.1 1,431 1

Sort (cost=7,244.81..7,248.01 rows=1,277 width=57) (actual time=53.684..53.750 rows=1,431 loops=1)

  • Sort Key: o_3.id, (max(COALESCE((rs_1.qty_people_included * rs_1.qty), 0))), ((min(COALESCE((COALESCE(count(*), '0'::bigint)), '0'::bigint)))::integer), rs_1.order_item_id, (min(rs_1.item_scheduled_start_time)), (max(rs_1.end_time)), (bool_or(rs_1.is_all_day_event)), (min(rs_1.all_day_date))
  • Sort Method: quicksort Memory: 250kB
48. 0.993 53.200 ↓ 1.1 1,431 1

GroupAggregate (cost=7,121.46..7,178.93 rows=1,277 width=57) (actual time=52.089..53.200 rows=1,431 loops=1)

  • Group Key: o_3.id, rs_1.order_item_id, rs_1.qty_people_included, rs_1.qty, (COALESCE(count(*), '0'::bigint))
49. 2.017 52.207 ↓ 2.2 2,825 1

Sort (cost=7,121.46..7,124.66 rows=1,277 width=49) (actual time=52.066..52.207 rows=2,825 loops=1)

  • Sort Key: o_3.id, rs_1.order_item_id, rs_1.qty_people_included, rs_1.qty, (COALESCE(count(*), '0'::bigint))
  • Sort Method: quicksort Memory: 458kB
50. 0.393 50.190 ↓ 2.2 2,825 1

Hash Left Join (cost=6,242.20..7,055.58 rows=1,277 width=49) (actual time=35.083..50.190 rows=2,825 loops=1)

  • Hash Cond: (oi_1.id = poat_1.order_item_id)
51. 0.641 49.784 ↓ 2.2 2,825 1

Hash Join (cost=6,241.13..7,049.71 rows=1,277 width=53) (actual time=35.051..49.784 rows=2,825 loops=1)

  • Hash Cond: (oi_1.sku = p_1.id)
52. 4.481 48.786 ↓ 2.2 2,825 1

Hash Right Join (cost=6,147.29..6,952.50 rows=1,277 width=57) (actual time=34.689..48.786 rows=2,825 loops=1)

  • Hash Cond: (crspl_1.reserved_slot_id = rs_1.id)
53. 25.450 31.115 ↓ 1.3 42,254 1

HashAggregate (cost=1,741.52..2,079.45 rows=33,793 width=12) (actual time=21.486..31.115 rows=42,254 loops=1)

  • Group Key: crspl_1.reserved_slot_id
54. 5.665 5.665 ↓ 1.0 73,431 1

Seq Scan on customer_reserved_slot_participation_link crspl_1 (cost=0.00..1,382.01 rows=71,901 width=4) (actual time=0.010..5.665 rows=73,431 loops=1)

55. 0.598 13.190 ↓ 2.2 2,825 1

Hash (cost=4,389.81..4,389.81 rows=1,277 width=53) (actual time=13.190..13.190 rows=2,825 loops=1)

  • Buckets: 4,096 (originally 2048) Batches: 1 (originally 1) Memory Usage: 286kB
56. 0.669 12.592 ↓ 2.2 2,825 1

Hash Join (cost=2.72..4,389.81 rows=1,277 width=53) (actual time=0.501..12.592 rows=2,825 loops=1)

  • Hash Cond: (rs_1.facility_id = f_1.id)
57. 1.978 11.463 ↓ 1.8 2,827 1

Nested Loop (cost=1.13..4,383.39 rows=1,581 width=57) (actual time=0.033..11.463 rows=2,827 loops=1)

58. 0.168 6.337 ↓ 2.0 3,148 1

Nested Loop (cost=0.71..3,463.64 rows=1,592 width=12) (actual time=0.024..6.337 rows=3,148 loops=1)

  • Join Filter: (cdf_1.order_id = oi_1.order_id)
59. 0.707 2.721 ↓ 3.0 1,724 1

Nested Loop (cost=0.29..3,057.75 rows=575 width=8) (actual time=0.009..2.721 rows=1,724 loops=1)

60. 0.290 0.290 ↓ 3.0 1,724 1

CTE Scan on cte_root cdf_1 (cost=0.00..11.50 rows=575 width=4) (actual time=0.001..0.290 rows=1,724 loops=1)

61. 1.724 1.724 ↑ 1.0 1 1,724

Index Only Scan using orders_pkey on orders o_3 (cost=0.29..5.30 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1,724)

  • Index Cond: (id = cdf_1.order_id)
  • Heap Fetches: 1,724
62. 3.448 3.448 ↑ 1.5 2 1,724

Index Scan using order_items_order_id on order_items oi_1 (cost=0.42..0.67 rows=3 width=12) (actual time=0.001..0.002 rows=2 loops=1,724)

  • Index Cond: (order_id = o_3.id)
63. 3.148 3.148 ↑ 2.0 1 3,148

Index Scan using reserved_slots_order_item_id on reserved_slots rs_1 (cost=0.42..0.56 rows=2 width=45) (actual time=0.001..0.001 rows=1 loops=3,148)

  • Index Cond: (order_item_id = oi_1.id)
  • Filter: (qty > 0)
  • Rows Removed by Filter: 0
64. 0.003 0.460 ↑ 1.0 21 1

Hash (cost=1.32..1.32 rows=21 width=4) (actual time=0.460..0.460 rows=21 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
65. 0.457 0.457 ↑ 1.0 21 1

Seq Scan on facilities f_1 (cost=0.00..1.32 rows=21 width=4) (actual time=0.453..0.457 rows=21 loops=1)

  • Filter: (facility_type = ANY ('{0,3}'::integer[]))
  • Rows Removed by Filter: 6
66. 0.138 0.357 ↓ 1.0 1,378 1

Hash (cost=76.77..76.77 rows=1,366 width=4) (actual time=0.356..0.357 rows=1,378 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 65kB
67. 0.219 0.219 ↓ 1.0 1,378 1

Index Only Scan using products_pkey on products p_1 (cost=0.28..76.77 rows=1,366 width=4) (actual time=0.010..0.219 rows=1,378 loops=1)

  • Heap Fetches: 320
68. 0.001 0.013 ↓ 0.0 0 1

Hash (cost=1.05..1.05 rows=2 width=4) (actual time=0.012..0.013 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
69. 0.012 0.012 ↓ 0.0 0 1

Seq Scan on products_on_account_transactions poat_1 (cost=0.00..1.05 rows=2 width=4) (actual time=0.012..0.012 rows=0 loops=1)

  • Filter: created_as_rain_check
  • Rows Removed by Filter: 5
70.          

CTE cte_count_non_event_items

71. 0.540 13.535 ↑ 1.4 1,111 1

HashAggregate (cost=8,574.20..8,593.90 rows=1,576 width=8) (actual time=13.389..13.535 rows=1,111 loops=1)

  • Group Key: oi_2.order_id
72. 0.449 12.995 ↓ 1.0 1,587 1

Hash Anti Join (cost=4,725.33..8,566.32 rows=1,576 width=8) (actual time=9.202..12.995 rows=1,587 loops=1)

  • Hash Cond: (oi_2.id = oi_3.id)
73. 1.447 3.385 ↓ 2.0 3,148 1

Nested Loop (cost=0.42..3,821.45 rows=1,592 width=12) (actual time=0.022..3.385 rows=3,148 loops=1)

74. 0.214 0.214 ↓ 3.0 1,724 1

CTE Scan on cte_root cdf_2 (cost=0.00..11.50 rows=575 width=4) (actual time=0.001..0.214 rows=1,724 loops=1)

75. 1.724 1.724 ↑ 1.5 2 1,724

Index Scan using order_items_order_id on order_items oi_2 (cost=0.42..6.60 rows=3 width=12) (actual time=0.001..0.001 rows=2 loops=1,724)

  • Index Cond: (order_id = cdf_2.order_id)
76. 0.463 9.161 ↓ 1.9 3,056 1

Hash (cost=4,704.59..4,704.59 rows=1,626 width=4) (actual time=9.161..9.161 rows=3,056 loops=1)

  • Buckets: 4,096 (originally 2048) Batches: 1 (originally 1) Memory Usage: 140kB
77. 1.764 8.698 ↓ 1.9 3,056 1

Nested Loop (cost=0.84..4,704.59 rows=1,626 width=4) (actual time=0.018..8.698 rows=3,056 loops=1)

78. 0.071 3.786 ↓ 2.0 3,148 1

Nested Loop (cost=0.42..3,821.45 rows=1,592 width=4) (actual time=0.004..3.786 rows=3,148 loops=1)

79. 0.267 0.267 ↓ 3.0 1,724 1

CTE Scan on cte_root cdf_3 (cost=0.00..11.50 rows=575 width=4) (actual time=0.000..0.267 rows=1,724 loops=1)

80. 3.448 3.448 ↑ 1.5 2 1,724

Index Scan using order_items_order_id on order_items oi_3 (cost=0.42..6.60 rows=3 width=8) (actual time=0.001..0.002 rows=2 loops=1,724)

  • Index Cond: (order_id = cdf_3.order_id)
81. 3.148 3.148 ↑ 2.0 1 3,148

Index Only Scan using reserved_slots_order_item_id on reserved_slots rs_2 (cost=0.42..0.53 rows=2 width=4) (actual time=0.001..0.001 rows=1 loops=3,148)

  • Index Cond: (order_item_id = oi_3.id)
  • Heap Fetches: 3,218
82.          

Initplan (for Limit)

83. 0.759 0.898 ↑ 1.0 1 1

Aggregate (cost=12.94..12.95 rows=1 width=32) (actual time=0.898..0.898 rows=1 loops=1)

84. 0.139 0.139 ↓ 3.0 1,724 1

CTE Scan on cte_root this_cte (cost=0.00..11.50 rows=575 width=4) (actual time=0.000..0.139 rows=1,724 loops=1)

85. 0.767 1,521.251 ↑ 75.5 60 1

Sort (cost=3,748.07..3,759.39 rows=4,531 width=316) (actual time=1,521.247..1,521.251 rows=60 loops=1)

  • Sort Key: o.create_stamp
  • Sort Method: top-N heapsort Memory: 40kB
86. 0.652 1,520.484 ↑ 2.6 1,724 1

Hash Left Join (cost=3,123.20..3,591.59 rows=4,531 width=316) (actual time=1,515.140..1,520.484 rows=1,724 loops=1)

  • Hash Cond: (cte_root.order_id = ccnei.order_id)
87. 0.576 1,505.428 ↓ 3.0 1,724 1

Hash Left Join (cost=3,071.98..3,380.06 rows=575 width=253) (actual time=1,500.712..1,505.428 rows=1,724 loops=1)

  • Hash Cond: (cte_root.order_id = crsgboi.order_id)
88. 0.462 1,447.454 ↓ 3.0 1,724 1

Nested Loop Left Join (cost=3,065.48..3,352.00 rows=575 width=220) (actual time=1,443.304..1,447.454 rows=1,724 loops=1)

  • Join Filter: false
89. 1.162 1,446.992 ↓ 3.0 1,724 1

Nested Loop (cost=3,065.48..3,346.25 rows=575 width=187) (actual time=1,443.300..1,446.992 rows=1,724 loops=1)

90. 0.689 1,444.106 ↓ 3.0 1,724 1

Hash Right Join (cost=3,065.19..3,079.02 rows=575 width=152) (actual time=1,443.288..1,444.106 rows=1,724 loops=1)

  • Hash Cond: (balance_summary.order_id = o.id)
91. 1,436.726 1,436.726 ↓ 1.7 1,724 1

Function Scan on get_balance_summary_4 balance_summary (cost=0.25..10.25 rows=1,000 width=132) (actual time=1,436.587..1,436.726 rows=1,724 loops=1)

92. 0.298 6.691 ↓ 3.0 1,724 1

Hash (cost=3,057.75..3,057.75 rows=575 width=24) (actual time=6.690..6.691 rows=1,724 loops=1)

  • Buckets: 2,048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 118kB
93. 0.575 6.393 ↓ 3.0 1,724 1

Nested Loop (cost=0.29..3,057.75 rows=575 width=24) (actual time=1.802..6.393 rows=1,724 loops=1)

94. 2.370 2.370 ↓ 3.0 1,724 1

CTE Scan on cte_root (cost=0.00..11.50 rows=575 width=4) (actual time=1.789..2.370 rows=1,724 loops=1)

95. 3.448 3.448 ↑ 1.0 1 1,724

Index Scan using orders_pkey on orders o (cost=0.29..5.30 rows=1 width=20) (actual time=0.002..0.002 rows=1 loops=1,724)

  • Index Cond: (id = cte_root.order_id)
96. 1.724 1.724 ↑ 1.0 1 1,724

Index Scan using customers_pkey on customers c (cost=0.29..0.46 rows=1 width=39) (actual time=0.001..0.001 rows=1 loops=1,724)

  • Index Cond: (id = o.customer_id)
97. 0.000 0.000 ↓ 0.0 0 1,724

Result (cost=0.00..0.00 rows=0 width=33) (actual time=0.000..0.000 rows=0 loops=1,724)

  • One-Time Filter: false
98. 0.517 57.398 ↓ 4.6 929 1

Hash (cost=4.00..4.00 rows=200 width=37) (actual time=57.398..57.398 rows=929 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 70kB
99. 56.881 56.881 ↓ 4.6 929 1

CTE Scan on cte_reserved_slots_grouped_by_order_id crsgboi (cost=0.00..4.00 rows=200 width=37) (actual time=54.649..56.881 rows=929 loops=1)

100. 0.158 14.404 ↑ 1.4 1,111 1

Hash (cost=31.52..31.52 rows=1,576 width=8) (actual time=14.404..14.404 rows=1,111 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 60kB
101. 14.246 14.246 ↑ 1.4 1,111 1

CTE Scan on cte_count_non_event_items ccnei (cost=0.00..31.52 rows=1,576 width=8) (actual time=13.392..14.246 rows=1,111 loops=1)