explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mU17

Settings
# exclusive inclusive rows x rows loops node
1. 0.613 89,578.810 ↑ 1,552.6 19 1

Nested Loop (cost=1,106.25..22,635.25 rows=29,500 width=486) (actual time=3,439.077..89,578.810 rows=19 loops=1)

2. 0.488 89,558.589 ↑ 3.1 19 1

Nested Loop (cost=1,105.99..20,938.74 rows=59 width=163) (actual time=3,433.000..89,558.589 rows=19 loops=1)

3. 0.732 44.794 ↓ 2.0 117 1

Nested Loop (cost=1,093.81..8,484.00 rows=59 width=138) (actual time=14.676..44.794 rows=117 loops=1)

4. 0.509 43.009 ↓ 2.0 117 1

Hash Left Join (cost=1,093.67..8,457.18 rows=59 width=134) (actual time=14.654..43.009 rows=117 loops=1)

  • Hash Cond: ((rl.created_date = bl.created_date) AND (rl.object_roid = bl.object_roid))
5. 0.159 39.034 ↓ 2.0 117 1

Append (cost=0.00..7,353.47 rows=59 width=125) (actual time=11.173..39.034 rows=117 loops=1)

6. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on reg_logs rl (cost=0.00..0.00 rows=1 width=112) (actual time=0.003..0.004 rows=0 loops=1)

  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (type = 'domain'::text) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
7. 29.180 38.651 ↓ 117.0 117 1

Bitmap Heap Scan on reg_logs_201911 rl_1 (cost=884.58..7,109.20 rows=1 width=890) (actual time=11.170..38.651 rows=117 loops=1)

  • Recheck Cond: ((type = 'domain'::text) AND (operation = 'UPDATE'::text))
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
  • Rows Removed by Filter: 22604
  • Heap Blocks: exact=7349
8. 0.560 9.471 ↓ 0.0 0 1

BitmapAnd (cost=884.58..884.58 rows=8,613 width=0) (actual time=9.471..9.471 rows=0 loops=1)

9. 3.797 3.797 ↓ 1.0 24,001 1

Bitmap Index Scan on reg_logs_201911_type_idx (cost=0.00..413.29 rows=23,449 width=0) (actual time=3.797..3.797 rows=24,001 loops=1)

  • Index Cond: (type = 'domain'::text)
10. 5.114 5.114 ↓ 1.1 34,012 1

Bitmap Index Scan on reg_logs_201911_operation_idx (cost=0.00..471.04 rows=31,750 width=0) (actual time=5.114..5.114 rows=34,012 loops=1)

  • Index Cond: (operation = 'UPDATE'::text)
11. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_201912 rl_2 (cost=1.66..4.29 rows=1 width=112) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
12. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_201912_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
13. 0.000 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202001 rl_3 (cost=1.66..4.29 rows=1 width=112) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
14. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202001_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
15. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202002 rl_4 (cost=1.66..4.29 rows=1 width=112) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
16. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202002_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
17. 0.002 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202003 rl_5 (cost=1.66..4.29 rows=1 width=112) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
18. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202003_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
19. 0.001 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202004 rl_6 (cost=1.66..4.29 rows=1 width=112) (actual time=0.003..0.004 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
20. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202004_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
21. 0.000 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202005 rl_7 (cost=1.66..4.29 rows=1 width=112) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
22. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202005_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
23. 0.002 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202006 rl_8 (cost=1.66..4.29 rows=1 width=112) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
24. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202006_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
25. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202007 rl_9 (cost=1.66..4.29 rows=1 width=112) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
26. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202007_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
27. 0.002 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202008 rl_10 (cost=1.66..4.29 rows=1 width=112) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
28. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202008_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
29. 0.000 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202009 rl_11 (cost=1.66..4.29 rows=1 width=112) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
30. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202009_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
31. 0.003 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202010 rl_12 (cost=1.66..4.29 rows=1 width=112) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
32. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202010_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
33. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202011 rl_13 (cost=1.66..4.29 rows=1 width=112) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
34. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202011_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
35. 0.002 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202012 rl_14 (cost=1.66..4.29 rows=1 width=112) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
36. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202012_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
37. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202101 rl_15 (cost=1.66..4.29 rows=1 width=112) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
38. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202101_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
39. 0.000 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202102 rl_16 (cost=1.66..4.29 rows=1 width=112) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
40. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202102_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
41. 0.000 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202103 rl_17 (cost=1.66..4.29 rows=1 width=112) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
42. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202103_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
43. 0.000 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202104 rl_18 (cost=1.66..4.29 rows=1 width=112) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
44. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202104_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
45. 0.000 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202105 rl_19 (cost=1.66..4.29 rows=1 width=112) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
46. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202105_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
47. 0.000 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202106 rl_20 (cost=1.66..4.29 rows=1 width=112) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
48. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202106_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
49. 0.002 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202107 rl_21 (cost=1.66..4.29 rows=1 width=112) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
50. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202107_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
51. 0.002 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202108 rl_22 (cost=1.66..4.29 rows=1 width=112) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
52. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202108_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
53. 0.003 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202109 rl_23 (cost=1.66..4.29 rows=1 width=112) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
54. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202109_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
55. 0.000 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202110 rl_24 (cost=1.66..4.29 rows=1 width=112) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
56. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202110_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
57. 0.002 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202111 rl_25 (cost=1.66..4.29 rows=1 width=112) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
58. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202111_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
59. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202112 rl_26 (cost=1.66..4.29 rows=1 width=112) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
60. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202112_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
61. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202201 rl_27 (cost=1.66..4.29 rows=1 width=112) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
62. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202201_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
63. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202202 rl_28 (cost=1.66..4.29 rows=1 width=112) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
64. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202202_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
65. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202203 rl_29 (cost=1.66..4.29 rows=1 width=112) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
66. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202203_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
67. 0.000 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202204 rl_30 (cost=1.66..4.29 rows=1 width=112) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
68. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202204_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
69. 0.000 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202205 rl_31 (cost=1.66..4.29 rows=1 width=112) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
70. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202205_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
71. 0.003 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202206 rl_32 (cost=1.66..4.29 rows=1 width=112) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
72. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202206_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
73. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202207 rl_33 (cost=1.66..4.29 rows=1 width=112) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
74. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202207_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
75. 0.002 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202208 rl_34 (cost=1.66..4.29 rows=1 width=112) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
76. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202208_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
77. 0.000 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202209 rl_35 (cost=1.66..4.29 rows=1 width=112) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
78. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202209_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
79. 0.002 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202210 rl_36 (cost=1.66..4.29 rows=1 width=112) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
80. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202210_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
81. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202211 rl_37 (cost=1.66..4.29 rows=1 width=112) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
82. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202211_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
83. 0.000 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202212 rl_38 (cost=1.66..4.29 rows=1 width=112) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
84. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202212_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
85. 0.002 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202301 rl_39 (cost=1.66..4.29 rows=1 width=112) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
86. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202301_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
87. 0.002 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202302 rl_40 (cost=1.66..4.29 rows=1 width=112) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
88. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202302_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
89. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202303 rl_41 (cost=1.66..4.29 rows=1 width=112) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
90. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202303_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
91. 0.000 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202304 rl_42 (cost=1.66..4.29 rows=1 width=112) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
92. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202304_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
93. 0.002 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202305 rl_43 (cost=1.66..4.29 rows=1 width=112) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
94. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202305_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
95. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202306 rl_44 (cost=1.66..4.29 rows=1 width=112) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
96. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202306_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
97. 0.002 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202307 rl_45 (cost=1.66..4.29 rows=1 width=112) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
98. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202307_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
99. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202308 rl_46 (cost=1.66..4.29 rows=1 width=112) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
100. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202308_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
101. 0.003 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202309 rl_47 (cost=1.66..4.29 rows=1 width=112) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
102. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202309_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
103. 0.000 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202310 rl_48 (cost=1.66..4.29 rows=1 width=112) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
104. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202310_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
105. 0.000 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202311 rl_49 (cost=1.66..4.29 rows=1 width=112) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
106. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202311_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
107. 0.000 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202312 rl_50 (cost=1.66..4.29 rows=1 width=112) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
108. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202312_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
109. 0.000 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202401 rl_51 (cost=1.66..4.29 rows=1 width=112) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
110. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202401_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
111. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202402 rl_52 (cost=1.66..4.29 rows=1 width=112) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
112. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202402_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
113. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202403 rl_53 (cost=1.66..4.29 rows=1 width=112) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
114. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202403_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
115. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202404 rl_54 (cost=1.66..4.29 rows=1 width=112) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
116. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202404_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
117. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202405 rl_55 (cost=1.66..4.29 rows=1 width=112) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
118. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202405_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
119. 0.003 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202406 rl_56 (cost=1.66..4.29 rows=1 width=112) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
120. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202406_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
121. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202407 rl_57 (cost=1.66..4.29 rows=1 width=112) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
122. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202407_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
123. 0.002 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on reg_logs_202408 rl_58 (cost=1.66..4.29 rows=1 width=112) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (type = 'domain'::text)
  • Filter: ((new_value ? 'rgp_status_name'::text) AND (created_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (operation = 'UPDATE'::text) AND ((((old_value -> 'rgp_status_name'::text) = 'addPeriod'::text) AND ((new_value -> 'rgp_status_name'::text) = 'pendingDelete'::text)) OR ((new_value -> 'rgp_status_name'::text) = 'redemptionPeriod'::text)))
124. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on reg_logs_202408_type_idx (cost=0.00..1.66 rows=2 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (type = 'domain'::text)
125. 0.869 3.466 ↑ 3.1 4,584 1

Hash (cost=877.86..877.86 rows=14,387 width=42) (actual time=3.466..3.466 rows=4,584 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 387kB
126. 0.303 2.597 ↑ 3.1 4,584 1

Append (cost=0.00..877.86 rows=14,387 width=42) (actual time=0.018..2.597 rows=4,584 loops=1)

127. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on balance_log bl (cost=0.00..0.00 rows=1 width=48) (actual time=0.010..0.010 rows=0 loops=1)

128. 0.007 0.007 ↑ 1.0 2 1

Seq Scan on balance_log_201906 bl_1 (cost=0.00..1.02 rows=2 width=55) (actual time=0.007..0.007 rows=2 loops=1)

129. 0.024 0.024 ↑ 1.0 68 1

Seq Scan on balance_log_201908 bl_2 (cost=0.00..2.68 rows=68 width=55) (actual time=0.011..0.024 rows=68 loops=1)

130. 0.039 0.039 ↑ 1.0 108 1

Seq Scan on balance_log_201909 bl_3 (cost=0.00..5.08 rows=108 width=56) (actual time=0.011..0.039 rows=108 loops=1)

131. 0.010 0.010 ↑ 1.0 6 1

Seq Scan on balance_log_201907 bl_4 (cost=0.00..1.06 rows=6 width=55) (actual time=0.008..0.010 rows=6 loops=1)

132. 0.259 0.259 ↑ 1.2 573 1

Seq Scan on balance_log_201910 bl_5 (cost=0.00..30.78 rows=678 width=44) (actual time=0.006..0.259 rows=573 loops=1)

133. 1.772 1.772 ↑ 1.2 3,827 1

Seq Scan on balance_log_201911 bl_6 (cost=0.00..176.04 rows=4,404 width=30) (actual time=0.010..1.772 rows=3,827 loops=1)

134. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on balance_log_201912 bl_7 (cost=0.00..11.60 rows=160 width=48) (actual time=0.007..0.007 rows=0 loops=1)

135. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on balance_log_202001 bl_8 (cost=0.00..11.60 rows=160 width=48) (actual time=0.007..0.007 rows=0 loops=1)

136. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on balance_log_202002 bl_9 (cost=0.00..11.60 rows=160 width=48) (actual time=0.004..0.004 rows=0 loops=1)

137. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on balance_log_202003 bl_10 (cost=0.00..11.60 rows=160 width=48) (actual time=0.005..0.005 rows=0 loops=1)

138. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on balance_log_202004 bl_11 (cost=0.00..11.60 rows=160 width=48) (actual time=0.005..0.005 rows=0 loops=1)

139. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on balance_log_202005 bl_12 (cost=0.00..11.60 rows=160 width=48) (actual time=0.007..0.007 rows=0 loops=1)

140. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on balance_log_202006 bl_13 (cost=0.00..11.60 rows=160 width=48) (actual time=0.004..0.004 rows=0 loops=1)

141. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on balance_log_202007 bl_14 (cost=0.00..11.60 rows=160 width=48) (actual time=0.004..0.004 rows=0 loops=1)

142. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on balance_log_202008 bl_15 (cost=0.00..11.60 rows=160 width=48) (actual time=0.005..0.006 rows=0 loops=1)

143. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on balance_log_202009 bl_16 (cost=0.00..11.60 rows=160 width=48) (actual time=0.006..0.006 rows=0 loops=1)

144. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on balance_log_202010 bl_17 (cost=0.00..11.60 rows=160 width=48) (actual time=0.004..0.004 rows=0 loops=1)

145. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on balance_log_202011 bl_18 (cost=0.00..11.60 rows=160 width=48) (actual time=0.004..0.004 rows=0 loops=1)

146. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on balance_log_202012 bl_19 (cost=0.00..11.60 rows=160 width=48) (actual time=0.006..0.006 rows=0 loops=1)

147. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on balance_log_202101 bl_20 (cost=0.00..11.60 rows=160 width=48) (actual time=0.003..0.003 rows=0 loops=1)

148. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on balance_log_202102 bl_21 (cost=0.00..11.60 rows=160 width=48) (actual time=0.004..0.005 rows=0 loops=1)

149. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on balance_log_202103 bl_22 (cost=0.00..11.60 rows=160 width=48) (actual time=0.004..0.004 rows=0 loops=1)

150. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on balance_log_202104 bl_23 (cost=0.00..11.60 rows=160 width=48) (actual time=0.003..0.003 rows=0 loops=1)

151. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on balance_log_202105 bl_24 (cost=0.00..11.60 rows=160 width=48) (actual time=0.001..0.001 rows=0 loops=1)

152. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on balance_log_202106 bl_25 (cost=0.00..11.60 rows=160 width=48) (actual time=0.001..0.001 rows=0 loops=1)

153. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on balance_log_202107 bl_26 (cost=0.00..11.60 rows=160 width=48) (actual time=0.002..0.002 rows=0 loops=1)

154. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on balance_log_202108 bl_27 (cost=0.00..11.60 rows=160 width=48) (actual time=0.003..0.003 rows=0 loops=1)

155. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on balance_log_202109 bl_28 (cost=0.00..11.60 rows=160 width=48) (actual time=0.002..0.002 rows=0 loops=1)

156. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on balance_log_202110 bl_29 (cost=0.00..11.60 rows=160 width=48) (actual time=0.002..0.002 rows=0 loops=1)

157. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on balance_log_202111 bl_30 (cost=0.00..11.60 rows=160 width=48) (actual time=0.001..0.001 rows=0 loops=1)

158. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on balance_log_202112 bl_31 (cost=0.00..11.60 rows=160 width=48) (actual time=0.003..0.003 rows=0 loops=1)

159. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on balance_log_202201 bl_32 (cost=0.00..11.60 rows=160 width=48) (actual time=0.001..0.002 rows=0 loops=1)

160. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on balance_log_202202 bl_33 (cost=0.00..11.60 rows=160 width=48) (actual time=0.002..0.002 rows=0 loops=1)

161. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on balance_log_202203 bl_34 (cost=0.00..11.60 rows=160 width=48) (actual time=0.001..0.001 rows=0 loops=1)

162. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on balance_log_202204 bl_35 (cost=0.00..11.60 rows=160 width=48) (actual time=0.005..0.005 rows=0 loops=1)

163. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on balance_log_202205 bl_36 (cost=0.00..11.60 rows=160 width=48) (actual time=0.001..0.001 rows=0 loops=1)

164. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on balance_log_202206 bl_37 (cost=0.00..11.60 rows=160 width=48) (actual time=0.001..0.001 rows=0 loops=1)

165. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on balance_log_202207 bl_38 (cost=0.00..11.60 rows=160 width=48) (actual time=0.002..0.002 rows=0 loops=1)

166. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on balance_log_202208 bl_39 (cost=0.00..11.60 rows=160 width=48) (actual time=0.003..0.003 rows=0 loops=1)

167. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on balance_log_202209 bl_40 (cost=0.00..11.60 rows=160 width=48) (actual time=0.001..0.001 rows=0 loops=1)

168. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on balance_log_202210 bl_41 (cost=0.00..11.60 rows=160 width=48) (actual time=0.001..0.002 rows=0 loops=1)

169. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on balance_log_202211 bl_42 (cost=0.00..11.60 rows=160 width=48) (actual time=0.002..0.002 rows=0 loops=1)

170. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on balance_log_202212 bl_43 (cost=0.00..11.60 rows=160 width=48) (actual time=0.003..0.003 rows=0 loops=1)

171. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on balance_log_202301 bl_44 (cost=0.00..11.60 rows=160 width=48) (actual time=0.002..0.002 rows=0 loops=1)

172. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on balance_log_202302 bl_45 (cost=0.00..11.60 rows=160 width=48) (actual time=0.002..0.002 rows=0 loops=1)

173. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on balance_log_202303 bl_46 (cost=0.00..11.60 rows=160 width=48) (actual time=0.001..0.001 rows=0 loops=1)

174. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on balance_log_202304 bl_47 (cost=0.00..11.60 rows=160 width=48) (actual time=0.004..0.004 rows=0 loops=1)

175. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on balance_log_202305 bl_48 (cost=0.00..11.60 rows=160 width=48) (actual time=0.001..0.001 rows=0 loops=1)

176. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on balance_log_202306 bl_49 (cost=0.00..11.60 rows=160 width=48) (actual time=0.002..0.002 rows=0 loops=1)

177. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on balance_log_202307 bl_50 (cost=0.00..11.60 rows=160 width=48) (actual time=0.002..0.002 rows=0 loops=1)

178. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on balance_log_202308 bl_51 (cost=0.00..11.60 rows=160 width=48) (actual time=0.003..0.003 rows=0 loops=1)

179. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on balance_log_202309 bl_52 (cost=0.00..11.60 rows=160 width=48) (actual time=0.002..0.002 rows=0 loops=1)

180. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on balance_log_202310 bl_53 (cost=0.00..11.60 rows=160 width=48) (actual time=0.001..0.001 rows=0 loops=1)

181. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on balance_log_202311 bl_54 (cost=0.00..11.60 rows=160 width=48) (actual time=0.002..0.002 rows=0 loops=1)

182. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on balance_log_202312 bl_55 (cost=0.00..11.60 rows=160 width=48) (actual time=0.008..0.008 rows=0 loops=1)

183. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on balance_log_202401 bl_56 (cost=0.00..11.60 rows=160 width=48) (actual time=0.001..0.002 rows=0 loops=1)

184. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on balance_log_202402 bl_57 (cost=0.00..11.60 rows=160 width=48) (actual time=0.002..0.002 rows=0 loops=1)

185. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on balance_log_202403 bl_58 (cost=0.00..11.60 rows=160 width=48) (actual time=0.001..0.002 rows=0 loops=1)

186. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on balance_log_202404 bl_59 (cost=0.00..11.60 rows=160 width=48) (actual time=0.004..0.004 rows=0 loops=1)

187. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on balance_log_202405 bl_60 (cost=0.00..11.60 rows=160 width=48) (actual time=0.002..0.003 rows=0 loops=1)

188. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on balance_log_202406 bl_61 (cost=0.00..11.60 rows=160 width=48) (actual time=0.001..0.001 rows=0 loops=1)

189. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on balance_log_202407 bl_62 (cost=0.00..11.60 rows=160 width=48) (actual time=0.002..0.002 rows=0 loops=1)

190. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on balance_log_202408 bl_63 (cost=0.00..11.60 rows=160 width=48) (actual time=0.003..0.003 rows=0 loops=1)

191. 1.053 1.053 ↑ 1.0 1 117

Index Scan using registrar_supervisor_valid on registrar r (cost=0.15..0.44 rows=1 width=12) (actual time=0.008..0.009 rows=1 loops=117)

  • Index Cond: (name = (rl.old_value -> 'registrar_name'::text))
192. 1.755 89,513.307 ↓ 0.0 0 117

Limit (cost=12.18..211.08 rows=1 width=33) (actual time=765.066..765.071 rows=0 loops=117)

193. 11.583 89,511.552 ↓ 0.0 0 117

Merge Append (cost=12.18..69,627.94 rows=350 width=33) (actual time=765.056..765.056 rows=0 loops=117)

  • Sort Key: reg_logs.created_date DESC
194. 1.638 1.638 ↓ 0.0 0 117

Sort (cost=0.01..0.02 rows=1 width=40) (actual time=0.014..0.014 rows=0 loops=117)

  • Sort Key: reg_logs.created_date DESC
  • Sort Method: quicksort Memory: 25kB
195. 0.000 0.000 ↓ 0.0 0 117

Seq Scan on reg_logs (cost=0.00..0.00 rows=1 width=40) (actual time=0.000..0.000 rows=0 loops=117)

  • Filter: ((created_date <= rl.created_date) AND (type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
196. 4,462.380 4,462.380 ↓ 0.0 0 117

Index Scan Backward using reg_logs_201906_created_date_idx on reg_logs_201906 (cost=0.42..3,257.53 rows=1 width=47) (actual time=38.140..38.140 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
  • Rows Removed by Filter: 135665
197. 54.171 54.171 ↓ 0.0 0 117

Index Scan Backward using reg_logs_201908_created_date_idx on reg_logs_201908 (cost=0.28..49.00 rows=1 width=47) (actual time=0.463..0.463 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
  • Rows Removed by Filter: 1230
198. 68.211 68.211 ↓ 0.0 0 117

Index Scan Backward using reg_logs_201909_created_date_idx on reg_logs_201909 (cost=0.28..52.87 rows=1 width=48) (actual time=0.583..0.583 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
  • Rows Removed by Filter: 1394
199. 5.733 5.733 ↓ 0.0 0 117

Index Scan Backward using reg_logs_201907_created_date_idx on reg_logs_201907 (cost=0.14..5.72 rows=1 width=47) (actual time=0.049..0.049 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
  • Rows Removed by Filter: 92
200. 83,014.542 83,014.542 ↓ 0.0 0 117

Index Scan Backward using reg_logs_201910_created_date_idx on reg_logs_201910 (cost=0.43..60,367.87 rows=282 width=31) (actual time=709.525..709.526 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
  • Rows Removed by Filter: 1735228
201. 1,878.084 1,878.084 ↓ 0.0 0 117

Index Scan Backward using reg_logs_201911_created_date_idx on reg_logs_201911 (cost=0.29..4,749.81 rows=6 width=25) (actual time=16.052..16.052 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
  • Rows Removed by Filter: 35443
202. 0.351 0.351 ↓ 0.0 0 117

Index Scan Backward using reg_logs_201912_created_date_idx on reg_logs_201912 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.003 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
203. 0.234 0.234 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202001_created_date_idx on reg_logs_202001 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
204. 0.234 0.234 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202002_created_date_idx on reg_logs_202002 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
205. 0.234 0.234 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202003_created_date_idx on reg_logs_202003 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
206. 0.234 0.234 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202004_created_date_idx on reg_logs_202004 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
207. 0.351 0.351 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202005_created_date_idx on reg_logs_202005 (cost=0.15..19.67 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
208. 0.234 0.234 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202006_created_date_idx on reg_logs_202006 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
209. 0.234 0.234 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202007_created_date_idx on reg_logs_202007 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
210. 0.234 0.234 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202008_created_date_idx on reg_logs_202008 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
211. 0.351 0.351 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202009_created_date_idx on reg_logs_202009 (cost=0.15..19.67 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
212. 0.351 0.351 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202010_created_date_idx on reg_logs_202010 (cost=0.15..19.67 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
213. 0.234 0.234 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202011_created_date_idx on reg_logs_202011 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
214. 0.234 0.234 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202012_created_date_idx on reg_logs_202012 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
215. 0.351 0.351 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202101_created_date_idx on reg_logs_202101 (cost=0.15..19.67 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
216. 0.234 0.234 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202102_created_date_idx on reg_logs_202102 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
217. 0.351 0.351 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202103_created_date_idx on reg_logs_202103 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.003 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
218. 0.234 0.234 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202104_created_date_idx on reg_logs_202104 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
219. 0.351 0.351 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202105_created_date_idx on reg_logs_202105 (cost=0.15..19.67 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
220. 0.234 0.234 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202106_created_date_idx on reg_logs_202106 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
221. 0.351 0.351 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202107_created_date_idx on reg_logs_202107 (cost=0.15..19.67 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
222. 0.234 0.234 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202108_created_date_idx on reg_logs_202108 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
223. 0.351 0.351 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202109_created_date_idx on reg_logs_202109 (cost=0.15..19.67 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
224. 0.234 0.234 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202110_created_date_idx on reg_logs_202110 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
225. 0.234 0.234 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202111_created_date_idx on reg_logs_202111 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
226. 0.234 0.234 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202112_created_date_idx on reg_logs_202112 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
227. 0.351 0.351 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202201_created_date_idx on reg_logs_202201 (cost=0.15..19.67 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
228. 0.234 0.234 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202202_created_date_idx on reg_logs_202202 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
229. 0.234 0.234 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202203_created_date_idx on reg_logs_202203 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
230. 0.234 0.234 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202204_created_date_idx on reg_logs_202204 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
231. 0.351 0.351 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202205_created_date_idx on reg_logs_202205 (cost=0.15..19.67 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
232. 0.234 0.234 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202206_created_date_idx on reg_logs_202206 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
233. 0.234 0.234 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202207_created_date_idx on reg_logs_202207 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
234. 0.234 0.234 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202208_created_date_idx on reg_logs_202208 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
235. 0.234 0.234 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202209_created_date_idx on reg_logs_202209 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
236. 0.234 0.234 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202210_created_date_idx on reg_logs_202210 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
237. 0.234 0.234 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202211_created_date_idx on reg_logs_202211 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
238. 0.234 0.234 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202212_created_date_idx on reg_logs_202212 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
239. 0.351 0.351 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202301_created_date_idx on reg_logs_202301 (cost=0.15..19.67 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
240. 0.351 0.351 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202302_created_date_idx on reg_logs_202302 (cost=0.15..19.67 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
241. 0.234 0.234 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202303_created_date_idx on reg_logs_202303 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
242. 0.234 0.234 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202304_created_date_idx on reg_logs_202304 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
243. 0.351 0.351 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202305_created_date_idx on reg_logs_202305 (cost=0.15..19.67 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
244. 0.234 0.234 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202306_created_date_idx on reg_logs_202306 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
245. 0.234 0.234 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202307_created_date_idx on reg_logs_202307 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
246. 0.234 0.234 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202308_created_date_idx on reg_logs_202308 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
247. 0.351 0.351 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202309_created_date_idx on reg_logs_202309 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.003 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
248. 0.351 0.351 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202310_created_date_idx on reg_logs_202310 (cost=0.15..19.67 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
249. 0.234 0.234 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202311_created_date_idx on reg_logs_202311 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
250. 0.234 0.234 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202312_created_date_idx on reg_logs_202312 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
251. 0.234 0.234 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202401_created_date_idx on reg_logs_202401 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
252. 0.234 0.234 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202402_created_date_idx on reg_logs_202402 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
253. 0.234 0.234 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202403_created_date_idx on reg_logs_202403 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
254. 0.234 0.234 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202404_created_date_idx on reg_logs_202404 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
255. 0.234 0.234 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202405_created_date_idx on reg_logs_202405 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
256. 0.234 0.234 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202406_created_date_idx on reg_logs_202406 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
257. 0.234 0.234 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202407_created_date_idx on reg_logs_202407 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
258. 0.234 0.234 ↓ 0.0 0 117

Index Scan Backward using reg_logs_202408_created_date_idx on reg_logs_202408 (cost=0.15..19.67 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=117)

  • Index Cond: (created_date <= rl.created_date)
  • Filter: ((type = 'contact'::text) AND ((new_value -> 'id'::text) = (rl.old_value -> 'registrant'::text)))
259. 19.608 19.608 ↑ 500.0 1 19

Function Scan on get_rate_data (cost=0.26..10.26 rows=500 width=32) (actual time=1.032..1.032 rows=1 loops=19)

  • Filter: enabled
Planning time : 68.252 ms
Execution time : 89,582.498 ms