explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sJ5h

Settings

Optimization(s) for this plan:

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

Insert on supplies (cost=11,857,631.24..11,952,823.58 rows=3,173,078 width=48) (actual rows= loops=)

2.          

CTE last_supply

3. 0.000 0.000 ↓ 0.0

Limit (cost=0.56..0.68 rows=1 width=12) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Scan Backward using supplies_contract_block_idx on supplies supplies_1 (cost=0.56..975,198.93 rows=7,990,797 width=12) (actual rows= loops=)

  • Index Cond: (contract = ''::text)
5. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* (cost=11,857,630.56..11,952,822.90 rows=3,173,078 width=48) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

WindowAgg (cost=11,857,630.56..11,921,092.12 rows=3,173,078 width=44) (actual rows= loops=)

7.          

Initplan (forWindowAgg)

8. 0.000 0.000 ↓ 0.0

Index Scan using balances_meta_contract_key on balances_meta (cost=0.15..8.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (contract = ''::text)
9. 0.000 0.000 ↓ 0.0

Sort (cost=11,857,622.39..11,865,555.08 rows=3,173,078 width=20) (actual rows= loops=)

  • Sort Key: eth_balances_0.block
10. 0.000 0.000 ↓ 0.0

Nested Loop (cost=32.66..11,384,819.39 rows=3,173,078 width=20) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

CTE Scan on last_supply (cost=0.00..0.02 rows=1 width=8) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Append (cost=32.66..11,353,088.59 rows=3,173,078 width=12) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on eth_balances_0 (cost=32.66..2,107.64 rows=804 width=12) (actual rows= loops=)

  • Recheck Cond: ((block > $1) AND (block <= 7600000))
14. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on eth_balances_0_block_idx (cost=0.00..32.46 rows=804 width=0) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
15. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on eth_balances_100000 (cost=40.40..2,948.80 rows=1,169 width=12) (actual rows= loops=)

  • Recheck Cond: ((block > $1) AND (block <= 7600000))
16. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on eth_balances_100000_block_idx (cost=0.00..40.11 rows=1,169 width=0) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
17. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on eth_balances_200000 (cost=46.33..3,335.73 rows=1,357 width=12) (actual rows= loops=)

  • Recheck Cond: ((block > $1) AND (block <= 7600000))
18. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on eth_balances_200000_block_idx (cost=0.00..45.99 rows=1,357 width=0) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
19. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on eth_balances_300000 (cost=51.42..3,609.24 rows=1,463 width=12) (actual rows= loops=)

  • Recheck Cond: ((block > $1) AND (block <= 7600000))
20. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on eth_balances_300000_block_idx (cost=0.00..51.05 rows=1,463 width=0) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
21. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on eth_balances_400000 (cost=52.48..3,830.01 rows=1,567 width=12) (actual rows= loops=)

  • Recheck Cond: ((block > $1) AND (block <= 7600000))
22. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on eth_balances_400000_block_idx (cost=0.00..52.09 rows=1,567 width=0) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
23. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on eth_balances_500000 (cost=58.40..3,636.86 rows=1,364 width=12) (actual rows= loops=)

  • Recheck Cond: ((block > $1) AND (block <= 7600000))
24. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on eth_balances_500000_block_idx (cost=0.00..58.06 rows=1,364 width=0) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
25. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on eth_balances_600000 (cost=53.88..3,507.90 rows=1,313 width=12) (actual rows= loops=)

  • Recheck Cond: ((block > $1) AND (block <= 7600000))
26. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on eth_balances_600000_block_idx (cost=0.00..53.55 rows=1,313 width=0) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
27. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on eth_balances_700000 (cost=69.55..4,500.68 rows=1,671 width=12) (actual rows= loops=)

  • Recheck Cond: ((block > $1) AND (block <= 7600000))
28. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on eth_balances_700000_block_idx (cost=0.00..69.13 rows=1,671 width=0) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
29. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on eth_balances_800000 (cost=70.22..4,659.32 rows=1,736 width=12) (actual rows= loops=)

  • Recheck Cond: ((block > $1) AND (block <= 7600000))
30. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on eth_balances_800000_block_idx (cost=0.00..69.78 rows=1,736 width=0) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
31. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on eth_balances_900000 (cost=86.69..5,799.94 rows=2,172 width=12) (actual rows= loops=)

  • Recheck Cond: ((block > $1) AND (block <= 7600000))
32. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on eth_balances_900000_block_idx (cost=0.00..86.14 rows=2,172 width=0) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
33. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on eth_balances_1000000 (cost=97.64..6,511.80 rows=2,460 width=12) (actual rows= loops=)

  • Recheck Cond: ((block > $1) AND (block <= 7600000))
34. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on eth_balances_1000000_block_idx (cost=0.00..97.02 rows=2,460 width=0) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
35. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on eth_balances_1100000 (cost=119.39..7,998.58 rows=3,021 width=12) (actual rows= loops=)

  • Recheck Cond: ((block > $1) AND (block <= 7600000))
36. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on eth_balances_1100000_block_idx (cost=0.00..118.64 rows=3,021 width=0) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
37. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on eth_balances_1200000 (cost=128.92..8,521.74 rows=3,170 width=12) (actual rows= loops=)

  • Recheck Cond: ((block > $1) AND (block <= 7600000))
38. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on eth_balances_1200000_block_idx (cost=0.00..128.12 rows=3,170 width=0) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
39. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on eth_balances_1300000 (cost=133.85..10,099.49 rows=4,041 width=12) (actual rows= loops=)

  • Recheck Cond: ((block > $1) AND (block <= 7600000))
40. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on eth_balances_1300000_block_idx (cost=0.00..132.84 rows=4,041 width=0) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
41. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on eth_balances_1400000 (cost=161.29..12,069.97 rows=4,767 width=12) (actual rows= loops=)

  • Recheck Cond: ((block > $1) AND (block <= 7600000))
42. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on eth_balances_1400000_block_idx (cost=0.00..160.10 rows=4,767 width=0) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
43. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on eth_balances_1500000 (cost=177.90..12,079.29 rows=4,437 width=12) (actual rows= loops=)

  • Recheck Cond: ((block > $1) AND (block <= 7600000))
44. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on eth_balances_1500000_block_idx (cost=0.00..176.80 rows=4,437 width=0) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
45. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on eth_balances_1600000 (cost=166.92..11,288.97 rows=4,146 width=12) (actual rows= loops=)

  • Recheck Cond: ((block > $1) AND (block <= 7600000))
46. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on eth_balances_1600000_block_idx (cost=0.00..165.89 rows=4,146 width=0) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
47. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on eth_balances_1700000 (cost=188.99..12,910.50 rows=4,738 width=12) (actual rows= loops=)

  • Recheck Cond: ((block > $1) AND (block <= 7600000))
48. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on eth_balances_1700000_block_idx (cost=0.00..187.81 rows=4,738 width=0) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
49. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on eth_balances_1800000 (cost=161.28..10,846.04 rows=3,986 width=12) (actual rows= loops=)

  • Recheck Cond: ((block > $1) AND (block <= 7600000))
50. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on eth_balances_1800000_block_idx (cost=0.00..160.29 rows=3,986 width=0) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
51. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on eth_balances_1900000 (cost=194.13..13,178.40 rows=4,849 width=12) (actual rows= loops=)

  • Recheck Cond: ((block > $1) AND (block <= 7600000))
52. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on eth_balances_1900000_block_idx (cost=0.00..192.92 rows=4,849 width=0) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
53. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on eth_balances_2000000 (cost=178.77..12,235.21 rows=4,521 width=12) (actual rows= loops=)

  • Recheck Cond: ((block > $1) AND (block <= 7600000))
54. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on eth_balances_2000000_block_idx (cost=0.00..177.64 rows=4,521 width=0) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
55. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on eth_balances_2100000 (cost=183.20..12,381.25 rows=4,563 width=12) (actual rows= loops=)

  • Recheck Cond: ((block > $1) AND (block <= 7600000))
56. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on eth_balances_2100000_block_idx (cost=0.00..182.06 rows=4,563 width=0) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
57. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on eth_balances_2200000 (cost=183.32..12,422.54 rows=4,575 width=12) (actual rows= loops=)

  • Recheck Cond: ((block > $1) AND (block <= 7600000))
58. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on eth_balances_2200000_block_idx (cost=0.00..182.18 rows=4,575 width=0) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
59. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on eth_balances_2300000 (cost=1,088.39..60,639.71 rows=21,850 width=12) (actual rows= loops=)

60. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on eth_balances_3800000 (cost=1,060.95..70,957.39 rows=26,977 width=12) (actual rows= loops=)

  • Recheck Cond: ((block > $1) AND (block <= 7600000))
61. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on eth_balances_3800000_block_idx (cost=0.00..1,054.20 rows=26,977 width=0) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
62. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on eth_balances_3900000 (cost=1,290.82..84,912.47 rows=32,233 width=12) (actual rows= loops=)

  • Recheck Cond: ((block > $1) AND (block <= 7600000))
63. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on eth_balances_3900000_block_idx (cost=0.00..1,282.76 rows=32,233 width=0) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
64. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on eth_balances_4000000 (cost=1,271.50..84,624.12 rows=32,299 width=12) (actual rows= loops=)

  • Recheck Cond: ((block > $1) AND (block <= 7600000))
65. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on eth_balances_4000000_block_idx (cost=0.00..1,263.42 rows=32,299 width=0) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
66. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on eth_balances_4100000 (cost=1,935.73..126,660.86 rows=48,321 width=12) (actual rows= loops=)

  • Recheck Cond: ((block > $1) AND (block <= 7600000))
67. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on eth_balances_4100000_block_idx (cost=0.00..1,923.64 rows=48,321 width=0) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
68. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on eth_balances_4200000 (cost=2,548.12..164,674.63 rows=62,799 width=12) (actual rows= loops=)

  • Recheck Cond: ((block > $1) AND (block <= 7600000))
69. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on eth_balances_4200000_block_idx (cost=0.00..2,532.42 rows=62,799 width=0) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
70. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on eth_balances_4300000 (cost=2,404.60..155,912.30 rows=59,333 width=12) (actual rows= loops=)

  • Recheck Cond: ((block > $1) AND (block <= 7600000))
71. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on eth_balances_4300000_block_idx (cost=0.00..2,389.76 rows=59,333 width=0) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
72. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on eth_balances_4400000 (cost=1,667.04..109,348.72 rows=41,620 width=12) (actual rows= loops=)

  • Recheck Cond: ((block > $1) AND (block <= 7600000))
73. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on eth_balances_4400000_block_idx (cost=0.00..1,656.63 rows=41,620 width=0) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
74. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on eth_balances_4500000 (cost=1,844.67..120,545.60 rows=46,072 width=12) (actual rows= loops=)

  • Recheck Cond: ((block > $1) AND (block <= 7600000))
75. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on eth_balances_4500000_block_idx (cost=0.00..1,833.15 rows=46,072 width=0) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
76. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on eth_balances_4600000 (cost=2,625.11..170,243.68 rows=65,237 width=12) (actual rows= loops=)

  • Recheck Cond: ((block > $1) AND (block <= 7600000))
77. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on eth_balances_4600000_block_idx (cost=0.00..2,608.80 rows=65,237 width=0) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
78. 0.000 0.000 ↓ 0.0

Index Scan using eth_balances_4700000_block_idx on eth_balances_4700000 (cost=0.56..395,292.70 rows=100,137 width=12) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
79. 0.000 0.000 ↓ 0.0

Index Scan using eth_balances_4800000_block_idx on eth_balances_4800000 (cost=0.56..514,554.42 rows=130,261 width=12) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
80. 0.000 0.000 ↓ 0.0

Index Scan using eth_balances_4900000_block_idx on eth_balances_4900000 (cost=0.56..438,216.92 rows=110,890 width=12) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
81. 0.000 0.000 ↓ 0.0

Index Scan using eth_balances_5000000_block_idx on eth_balances_5000000 (cost=0.56..331,493.55 rows=83,719 width=12) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
82. 0.000 0.000 ↓ 0.0

Index Scan using eth_balances_5100000_block_idx on eth_balances_5100000 (cost=0.56..375,403.10 rows=95,089 width=12) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
83. 0.000 0.000 ↓ 0.0

Index Scan using eth_balances_5200000_block_idx on eth_balances_5200000 (cost=0.56..339,880.24 rows=86,088 width=12) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
84. 0.000 0.000 ↓ 0.0

Index Scan using eth_balances_5300000_block_idx on eth_balances_5300000 (cost=0.56..306,752.29 rows=77,695 width=12) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
85. 0.000 0.000 ↓ 0.0

Index Scan using eth_balances_5400000_block_idx on eth_balances_5400000 (cost=0.56..375,392.65 rows=95,074 width=12) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
86. 0.000 0.000 ↓ 0.0

Index Scan using eth_balances_5500000_block_idx on eth_balances_5500000 (cost=0.56..415,096.85 rows=105,146 width=12) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
87. 0.000 0.000 ↓ 0.0

Index Scan using eth_balances_5600000_block_idx on eth_balances_5600000 (cost=0.56..422,078.90 rows=106,903 width=12) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
88. 0.000 0.000 ↓ 0.0

Index Scan using eth_balances_5700000_block_idx on eth_balances_5700000 (cost=0.56..403,180.75 rows=102,127 width=12) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
89. 0.000 0.000 ↓ 0.0

Index Scan using eth_balances_5800000_block_idx on eth_balances_5800000 (cost=0.56..348,413.35 rows=88,244 width=12) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
90. 0.000 0.000 ↓ 0.0

Index Scan using eth_balances_5900000_block_idx on eth_balances_5900000 (cost=0.56..289,615.53 rows=73,355 width=12) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
91. 0.000 0.000 ↓ 0.0

Index Scan using eth_balances_6000000_block_idx on eth_balances_6000000 (cost=0.56..373,335.44 rows=94,546 width=12) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
92. 0.000 0.000 ↓ 0.0

Index Scan using eth_balances_6100000_block_idx on eth_balances_6100000 (cost=0.56..332,469.35 rows=84,207 width=12) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
93. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on eth_balances_6200000 (cost=2,806.02..173,937.40 rows=64,155 width=12) (actual rows= loops=)

  • Recheck Cond: ((block > $1) AND (block <= 7600000))
94. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on eth_balances_6200000_block_idx (cost=0.00..2,789.99 rows=64,155 width=0) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
95. 0.000 0.000 ↓ 0.0

Index Scan using eth_balances_6300000_block_idx on eth_balances_6300000 (cost=0.56..283,528.43 rows=71,803 width=12) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
96. 0.000 0.000 ↓ 0.0

Index Scan using eth_balances_6400000_block_idx on eth_balances_6400000 (cost=0.56..283,481.54 rows=71,792 width=12) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
97. 0.000 0.000 ↓ 0.0

Index Scan using eth_balances_6500000_block_idx on eth_balances_6500000 (cost=0.56..308,499.14 rows=78,126 width=12) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
98. 0.000 0.000 ↓ 0.0

Index Scan using eth_balances_6600000_block_idx on eth_balances_6600000 (cost=0.56..314,230.93 rows=79,578 width=12) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
99. 0.000 0.000 ↓ 0.0

Index Scan using eth_balances_6700000_block_idx on eth_balances_6700000 (cost=0.56..329,197.94 rows=83,377 width=12) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
100. 0.000 0.000 ↓ 0.0

Index Scan using eth_balances_6800000_block_idx on eth_balances_6800000 (cost=0.56..317,898.93 rows=80,511 width=12) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
101. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on eth_balances_6900000 (cost=2,891.64..177,234.93 rows=65,483 width=12) (actual rows= loops=)

  • Recheck Cond: ((block > $1) AND (block <= 7600000))
102. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on eth_balances_6900000_block_idx (cost=0.00..2,875.26 rows=65,483 width=0) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
103. 0.000 0.000 ↓ 0.0

Index Scan using eth_balances_7000000_block_idx on eth_balances_7000000 (cost=0.56..331,142.96 rows=83,855 width=12) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
104. 0.000 0.000 ↓ 0.0

Index Scan using eth_balances_7100000_block_idx on eth_balances_7100000 (cost=0.56..337,796.33 rows=85,542 width=12) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
105. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on eth_balances_7200000 (cost=3,609.05..194,667.40 rows=68,731 width=12) (actual rows= loops=)

  • Recheck Cond: ((block > $1) AND (block <= 7600000))
106. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on eth_balances_7200000_block_idx (cost=0.00..3,591.87 rows=68,731 width=0) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
107. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on eth_balances_7300000 (cost=3,146.08..174,449.14 rows=62,197 width=12) (actual rows= loops=)

  • Recheck Cond: ((block > $1) AND (block <= 7600000))
108. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on eth_balances_7300000_block_idx (cost=0.00..3,130.53 rows=62,197 width=0) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
109. 0.000 0.000 ↓ 0.0

Index Scan using eth_balances_7400000_block_idx on eth_balances_7400000 (cost=0.56..337,713.93 rows=85,518 width=12) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
110. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on eth_balances_7500000 (cost=178.90..10,943.71 rows=4,144 width=12) (actual rows= loops=)

  • Recheck Cond: ((block > $1) AND (block <= 7600000))
111. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on eth_balances_7500000_block_idx (cost=0.00..177.87 rows=4,144 width=0) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))
112. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on eth_balances_7600000 (cost=4.20..12.69 rows=5 width=12) (actual rows= loops=)

  • Recheck Cond: ((block > $1) AND (block <= 7600000))
113. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on eth_balances_7600000_block_idx (cost=0.00..4.20 rows=5 width=0) (actual rows= loops=)

  • Index Cond: ((block > $1) AND (block <= 7600000))