explain.depesz.com

PostgreSQL's explain analyze made readable

Result: g5u3

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Sort (cost=2,643,137.37..2,665,867.42 rows=9,092,023 width=80) (actual rows= loops=)

  • Sort Key: c.event_feature_variation_id, c.metric_id, c.event_kind, c."time", c.user_key_hash
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=25,085.62..1,119,022.92 rows=9,092,023 width=80) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Limit (cost=24.73..24.74 rows=1 width=96) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Sort (cost=24.73..25.79 rows=421 width=96) (actual rows= loops=)

  • Sort Key: tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id DESC, tmp_exp_conversions_last_migrated_hll_rows.metric_id DESC, tmp_exp_conversions_last_migrated_hll_rows.event_kind DESC, tmp_exp_conversions_last_migrated_hll_rows."time" DESC, tmp_exp_conversions_last_migrated_hll_rows.user_key_hash DESC
5. 0.000 0.000 ↓ 0.0

Append (cost=0.00..18.42 rows=421 width=96) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on tmp_exp_conversions_last_migrated_hll_rows (cost=0.00..14.20 rows=420 width=164) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 2 (cost=0.00..0.02 rows=1 width=96) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.01 rows=1 width=96) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Append (cost=25,060.88..1,028,368.87 rows=9,062,931 width=80) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on _hyper_68_8678_chunk c (cost=25,060.88..116,115.78 rows=1,040,675 width=80) (actual rows= loops=)

  • Recheck Cond: ((event_feature_variation_id > tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id > tmp_exp_conversions_last_migrated_hll_rows.metric_id)) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind > tmp_exp_conversions_last_migrated_hll_rows.event_kind)) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" > tmp_exp_conversions_last_migrated_hll_rows."time")) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" = tmp_exp_conversions_last_migrated_hll_rows."time") AND (user_key_hash >= tmp_exp_conversions_last_migrated_hll_rows.user_key_hash)))
11. 0.000 0.000 ↓ 0.0

BitmapOr (cost=25,060.88..25,060.88 rows=1,040,819 width=0) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "8678_5848_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..23,742.44 rows=1,040,385 width=0) (actual rows= loops=)

  • Index Cond: (event_feature_variation_id > tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id)
13. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "8678_5848_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..12.59 rows=433 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id > tmp_exp_conversions_last_migrated_hll_rows.metric_id))
14. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "8678_5848_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..1.67 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind > tmp_exp_conversions_last_migrated_hll_rows.event_kind))
15. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "8678_5848_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..1.67 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" > tmp_exp_conversions_last_migrated_hll_rows."time"))
16. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "8678_5848_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..1.67 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" = tmp_exp_conversions_last_migrated_hll_rows."time") AND (user_key_hash >= tmp_exp_conversions_last_migrated_hll_rows.user_key_hash))
17. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on _hyper_68_8679_chunk c_1 (cost=39,371.18..182,447.83 rows=1,635,208 width=80) (actual rows= loops=)

  • Recheck Cond: ((event_feature_variation_id > tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id > tmp_exp_conversions_last_migrated_hll_rows.metric_id)) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind > tmp_exp_conversions_last_migrated_hll_rows.event_kind)) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" > tmp_exp_conversions_last_migrated_hll_rows."time")) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" = tmp_exp_conversions_last_migrated_hll_rows."time") AND (user_key_hash >= tmp_exp_conversions_last_migrated_hll_rows.user_key_hash)))
18. 0.000 0.000 ↓ 0.0

BitmapOr (cost=39,371.18..39,371.18 rows=1,635,361 width=0) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "8679_5850_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..37,309.34 rows=1,634,904 width=0) (actual rows= loops=)

  • Index Cond: (event_feature_variation_id > tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id)
20. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "8679_5850_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..12.82 rows=456 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id > tmp_exp_conversions_last_migrated_hll_rows.metric_id))
21. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "8679_5850_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..1.67 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind > tmp_exp_conversions_last_migrated_hll_rows.event_kind))
22. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "8679_5850_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..1.67 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" > tmp_exp_conversions_last_migrated_hll_rows."time"))
23. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "8679_5850_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..1.68 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" = tmp_exp_conversions_last_migrated_hll_rows."time") AND (user_key_hash >= tmp_exp_conversions_last_migrated_hll_rows.user_key_hash))
24. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on _hyper_68_8680_chunk c_2 (cost=113,706.51..474,287.85 rows=4,120,993 width=80) (actual rows= loops=)

  • Recheck Cond: ((event_feature_variation_id > tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id > tmp_exp_conversions_last_migrated_hll_rows.metric_id)) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind > tmp_exp_conversions_last_migrated_hll_rows.event_kind)) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" > tmp_exp_conversions_last_migrated_hll_rows."time")) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" = tmp_exp_conversions_last_migrated_hll_rows."time") AND (user_key_hash >= tmp_exp_conversions_last_migrated_hll_rows.user_key_hash)))
25. 0.000 0.000 ↓ 0.0

BitmapOr (cost=113,706.51..113,706.51 rows=4,121,165 width=0) (actual rows= loops=)

26. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "8680_5852_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..108,534.64 rows=4,120,650 width=0) (actual rows= loops=)

  • Index Cond: (event_feature_variation_id > tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id)
27. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "8680_5852_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..15.61 rows=515 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id > tmp_exp_conversions_last_migrated_hll_rows.metric_id))
28. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "8680_5852_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..1.67 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind > tmp_exp_conversions_last_migrated_hll_rows.event_kind))
29. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "8680_5852_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..1.68 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" > tmp_exp_conversions_last_migrated_hll_rows."time"))
30. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "8680_5852_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..1.68 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" = tmp_exp_conversions_last_migrated_hll_rows."time") AND (user_key_hash >= tmp_exp_conversions_last_migrated_hll_rows.user_key_hash))
31. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on _hyper_68_8681_chunk c_3 (cost=21,615.50..95,424.97 rows=843,547 width=80) (actual rows= loops=)

  • Recheck Cond: ((event_feature_variation_id > tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id > tmp_exp_conversions_last_migrated_hll_rows.metric_id)) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind > tmp_exp_conversions_last_migrated_hll_rows.event_kind)) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" > tmp_exp_conversions_last_migrated_hll_rows."time")) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" = tmp_exp_conversions_last_migrated_hll_rows."time") AND (user_key_hash >= tmp_exp_conversions_last_migrated_hll_rows.user_key_hash)))
32. 0.000 0.000 ↓ 0.0

BitmapOr (cost=21,615.50..21,615.50 rows=843,610 width=0) (actual rows= loops=)

33. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "8681_5854_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..20,550.32 rows=843,422 width=0) (actual rows= loops=)

  • Index Cond: (event_feature_variation_id > tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id)
34. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "8681_5854_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..5.74 rows=188 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id > tmp_exp_conversions_last_migrated_hll_rows.metric_id))
35. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "8681_5854_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..1.67 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind > tmp_exp_conversions_last_migrated_hll_rows.event_kind))
36. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "8681_5854_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..1.67 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" > tmp_exp_conversions_last_migrated_hll_rows."time"))
37. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "8681_5854_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..1.67 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" = tmp_exp_conversions_last_migrated_hll_rows."time") AND (user_key_hash >= tmp_exp_conversions_last_migrated_hll_rows.user_key_hash))
38. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on _hyper_68_8682_chunk c_4 (cost=5,689.94..26,256.64 rows=231,305 width=80) (actual rows= loops=)

  • Recheck Cond: ((event_feature_variation_id > tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id > tmp_exp_conversions_last_migrated_hll_rows.metric_id)) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind > tmp_exp_conversions_last_migrated_hll_rows.event_kind)) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" > tmp_exp_conversions_last_migrated_hll_rows."time")) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" = tmp_exp_conversions_last_migrated_hll_rows."time") AND (user_key_hash >= tmp_exp_conversions_last_migrated_hll_rows.user_key_hash)))
39. 0.000 0.000 ↓ 0.0

BitmapOr (cost=5,689.94..5,689.94 rows=231,320 width=0) (actual rows= loops=)

40. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "8682_5856_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..5,393.71 rows=231,275 width=0) (actual rows= loops=)

  • Index Cond: (event_feature_variation_id > tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id)
41. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "8682_5856_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..2.10 rows=45 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id > tmp_exp_conversions_last_migrated_hll_rows.metric_id))
42. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "8682_5856_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..1.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind > tmp_exp_conversions_last_migrated_hll_rows.event_kind))
43. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "8682_5856_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..1.67 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" > tmp_exp_conversions_last_migrated_hll_rows."time"))
44. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "8682_5856_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..1.67 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" = tmp_exp_conversions_last_migrated_hll_rows."time") AND (user_key_hash >= tmp_exp_conversions_last_migrated_hll_rows.user_key_hash))
45. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on _hyper_68_8906_chunk c_5 (cost=5,203.79..26,130.68 rows=231,688 width=80) (actual rows= loops=)

  • Recheck Cond: ((event_feature_variation_id > tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id > tmp_exp_conversions_last_migrated_hll_rows.metric_id)) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind > tmp_exp_conversions_last_migrated_hll_rows.event_kind)) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" > tmp_exp_conversions_last_migrated_hll_rows."time")) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" = tmp_exp_conversions_last_migrated_hll_rows."time") AND (user_key_hash >= tmp_exp_conversions_last_migrated_hll_rows.user_key_hash)))
46. 0.000 0.000 ↓ 0.0

BitmapOr (cost=5,203.79..5,203.79 rows=231,703 width=0) (actual rows= loops=)

47. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "8906_5882_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..4,907.09 rows=231,659 width=0) (actual rows= loops=)

  • Index Cond: (event_feature_variation_id > tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id)
48. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "8906_5882_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..2.09 rows=44 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id > tmp_exp_conversions_last_migrated_hll_rows.metric_id))
49. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "8906_5882_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..1.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind > tmp_exp_conversions_last_migrated_hll_rows.event_kind))
50. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "8906_5882_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..1.67 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" > tmp_exp_conversions_last_migrated_hll_rows."time"))
51. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "8906_5882_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..1.67 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" = tmp_exp_conversions_last_migrated_hll_rows."time") AND (user_key_hash >= tmp_exp_conversions_last_migrated_hll_rows.user_key_hash))
52. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on _hyper_68_9244_chunk c_6 (cost=5,117.36..25,586.71 rows=227,845 width=80) (actual rows= loops=)

  • Recheck Cond: ((event_feature_variation_id > tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id > tmp_exp_conversions_last_migrated_hll_rows.metric_id)) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind > tmp_exp_conversions_last_migrated_hll_rows.event_kind)) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" > tmp_exp_conversions_last_migrated_hll_rows."time")) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" = tmp_exp_conversions_last_migrated_hll_rows."time") AND (user_key_hash >= tmp_exp_conversions_last_migrated_hll_rows.user_key_hash)))
53. 0.000 0.000 ↓ 0.0

BitmapOr (cost=5,117.36..5,117.36 rows=227,860 width=0) (actual rows= loops=)

54. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "9244_5888_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..4,825.47 rows=227,816 width=0) (actual rows= loops=)

  • Index Cond: (event_feature_variation_id > tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id)
55. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "9244_5888_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..2.09 rows=44 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id > tmp_exp_conversions_last_migrated_hll_rows.metric_id))
56. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "9244_5888_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..1.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind > tmp_exp_conversions_last_migrated_hll_rows.event_kind))
57. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "9244_5888_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..1.67 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" > tmp_exp_conversions_last_migrated_hll_rows."time"))
58. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "9244_5888_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..1.67 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" = tmp_exp_conversions_last_migrated_hll_rows."time") AND (user_key_hash >= tmp_exp_conversions_last_migrated_hll_rows.user_key_hash))
59. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on _hyper_68_9566_chunk c_7 (cost=5,010.34..25,078.63 rows=226,369 width=80) (actual rows= loops=)

  • Recheck Cond: ((event_feature_variation_id > tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id > tmp_exp_conversions_last_migrated_hll_rows.metric_id)) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind > tmp_exp_conversions_last_migrated_hll_rows.event_kind)) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" > tmp_exp_conversions_last_migrated_hll_rows."time")) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" = tmp_exp_conversions_last_migrated_hll_rows."time") AND (user_key_hash >= tmp_exp_conversions_last_migrated_hll_rows.user_key_hash)))
60. 0.000 0.000 ↓ 0.0

BitmapOr (cost=5,010.34..5,010.34 rows=226,385 width=0) (actual rows= loops=)

61. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "9566_5898_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..4,720.74 rows=226,336 width=0) (actual rows= loops=)

  • Index Cond: (event_feature_variation_id > tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id)
62. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "9566_5898_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..2.02 rows=49 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id > tmp_exp_conversions_last_migrated_hll_rows.metric_id))
63. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "9566_5898_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..1.54 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind > tmp_exp_conversions_last_migrated_hll_rows.event_kind))
64. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "9566_5898_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..1.54 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" > tmp_exp_conversions_last_migrated_hll_rows."time"))
65. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "9566_5898_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..1.54 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" = tmp_exp_conversions_last_migrated_hll_rows."time") AND (user_key_hash >= tmp_exp_conversions_last_migrated_hll_rows.user_key_hash))
66. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on _hyper_68_9949_chunk c_8 (cost=5,078.26..25,455.53 rows=226,897 width=80) (actual rows= loops=)

  • Recheck Cond: ((event_feature_variation_id > tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id > tmp_exp_conversions_last_migrated_hll_rows.metric_id)) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind > tmp_exp_conversions_last_migrated_hll_rows.event_kind)) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" > tmp_exp_conversions_last_migrated_hll_rows."time")) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" = tmp_exp_conversions_last_migrated_hll_rows."time") AND (user_key_hash >= tmp_exp_conversions_last_migrated_hll_rows.user_key_hash)))
67. 0.000 0.000 ↓ 0.0

BitmapOr (cost=5,078.26..5,078.26 rows=226,911 width=0) (actual rows= loops=)

68. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "9949_5904_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..4,787.56 rows=226,868 width=0) (actual rows= loops=)

  • Index Cond: (event_feature_variation_id > tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id)
69. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "9949_5904_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..2.08 rows=43 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id > tmp_exp_conversions_last_migrated_hll_rows.metric_id))
70. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "9949_5904_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..1.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind > tmp_exp_conversions_last_migrated_hll_rows.event_kind))
71. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "9949_5904_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..1.67 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" > tmp_exp_conversions_last_migrated_hll_rows."time"))
72. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "9949_5904_conversion_user_counts_hourly_event_feature_variation" (cost=0.00..1.67 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" = tmp_exp_conversions_last_migrated_hll_rows."time") AND (user_key_hash >= tmp_exp_conversions_last_migrated_hll_rows.user_key_hash))
73. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on _hyper_68_10323_chunk c_9 (cost=5,297.93..26,131.55 rows=230,757 width=80) (actual rows= loops=)

  • Recheck Cond: ((event_feature_variation_id > tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id > tmp_exp_conversions_last_migrated_hll_rows.metric_id)) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind > tmp_exp_conversions_last_migrated_hll_rows.event_kind)) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" > tmp_exp_conversions_last_migrated_hll_rows."time")) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" = tmp_exp_conversions_last_migrated_hll_rows."time") AND (user_key_hash >= tmp_exp_conversions_last_migrated_hll_rows.user_key_hash)))
74. 0.000 0.000 ↓ 0.0

BitmapOr (cost=5,297.93..5,297.93 rows=230,771 width=0) (actual rows= loops=)

75. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "10323_5939_conversion_user_counts_hourly_event_feature_variatio" (cost=0.00..5,002.41 rows=230,728 width=0) (actual rows= loops=)

  • Index Cond: (event_feature_variation_id > tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id)
76. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "10323_5939_conversion_user_counts_hourly_event_feature_variatio" (cost=0.00..2.08 rows=43 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id > tmp_exp_conversions_last_migrated_hll_rows.metric_id))
77. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "10323_5939_conversion_user_counts_hourly_event_feature_variatio" (cost=0.00..1.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind > tmp_exp_conversions_last_migrated_hll_rows.event_kind))
78. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "10323_5939_conversion_user_counts_hourly_event_feature_variatio" (cost=0.00..1.67 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" > tmp_exp_conversions_last_migrated_hll_rows."time"))
79. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "10323_5939_conversion_user_counts_hourly_event_feature_variatio" (cost=0.00..1.67 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" = tmp_exp_conversions_last_migrated_hll_rows."time") AND (user_key_hash >= tmp_exp_conversions_last_migrated_hll_rows.user_key_hash))
80. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on _hyper_68_10662_chunk c_10 (cost=1,151.84..5,452.69 rows=47,647 width=80) (actual rows= loops=)

  • Recheck Cond: ((event_feature_variation_id > tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id > tmp_exp_conversions_last_migrated_hll_rows.metric_id)) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind > tmp_exp_conversions_last_migrated_hll_rows.event_kind)) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" > tmp_exp_conversions_last_migrated_hll_rows."time")) OR ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" = tmp_exp_conversions_last_migrated_hll_rows."time") AND (user_key_hash >= tmp_exp_conversions_last_migrated_hll_rows.user_key_hash)))
81. 0.000 0.000 ↓ 0.0

BitmapOr (cost=1,151.84..1,151.84 rows=47,660 width=0) (actual rows= loops=)

82. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "10662_5945_conversion_user_counts_hourly_event_feature_variatio" (cost=0.00..1,085.79 rows=47,622 width=0) (actual rows= loops=)

  • Index Cond: (event_feature_variation_id > tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id)
83. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "10662_5945_conversion_user_counts_hourly_event_feature_variatio" (cost=0.00..1.89 rows=37 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id > tmp_exp_conversions_last_migrated_hll_rows.metric_id))
84. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "10662_5945_conversion_user_counts_hourly_event_feature_variatio" (cost=0.00..1.53 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind > tmp_exp_conversions_last_migrated_hll_rows.event_kind))
85. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "10662_5945_conversion_user_counts_hourly_event_feature_variatio" (cost=0.00..1.53 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" > tmp_exp_conversions_last_migrated_hll_rows."time"))
86. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "10662_5945_conversion_user_counts_hourly_event_feature_variatio" (cost=0.00..1.54 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((event_feature_variation_id = tmp_exp_conversions_last_migrated_hll_rows.event_feature_variation_id) AND (metric_id = tmp_exp_conversions_last_migrated_hll_rows.metric_id) AND (event_kind = tmp_exp_conversions_last_migrated_hll_rows.event_kind) AND ("time" = tmp_exp_conversions_last_migrated_hll_rows."time") AND (user_key_hash >= tmp_exp_conversions_last_migrated_hll_rows.user_key_hash))