explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IsY

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 4.860 ↑ 1.0 1 1

Aggregate (cost=906.08..906.09 rows=1 width=8) (actual time=4.859..4.860 rows=1 loops=1)

2. 0.029 4.850 ↓ 3.6 29 1

Hash Left Join (cost=187.15..906.06 rows=8 width=0) (actual time=4.784..4.850 rows=29 loops=1)

  • Hash Cond: (fee.fee_id = amount_override.fee_id)
  • Filter: ((amount_override.id IS NULL) OR (amount_override.amount <> '0'::numeric))
  • Rows Removed by Filter: 3
3. 0.803 4.813 ↓ 2.7 32 1

Hash Right Join (cost=186.09..904.96 rows=12 width=16) (actual time=4.766..4.813 rows=32 loops=1)

  • Hash Cond: (public__charge__2019_01.fee_id = fee.fee_id)
  • Filter: (public__charge__2019_01.charge_id IS NULL)
  • Rows Removed by Filter: 2459
4. 0.894 2.072 ↑ 1.1 2,459 1

Append (cost=4.17..715.72 rows=2,787 width=32) (actual time=0.116..2.072 rows=2,459 loops=1)

5. 0.003 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on public__charge__2019_01 (cost=4.17..11.28 rows=3 width=32) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (charge_status = 'ACTIVE'::charge_status)
6. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on public__charge__2019_01_status_scheduled_date_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
7. 0.001 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on public__charge__2019_02 (cost=4.17..11.28 rows=3 width=32) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: (charge_status = 'ACTIVE'::charge_status)
8. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on public__charge__2019_02_status_scheduled_date_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
9. 0.002 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on public__charge__2019_03 (cost=4.17..11.28 rows=3 width=32) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (charge_status = 'ACTIVE'::charge_status)
10. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on public__charge__2019_03_status_scheduled_date_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
11. 0.000 0.001 ↓ 0.0 0 1

Bitmap Heap Scan on public__charge__2019_04 (cost=4.17..11.28 rows=3 width=32) (actual time=0.001..0.001 rows=0 loops=1)

  • Recheck Cond: (charge_status = 'ACTIVE'::charge_status)
12. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on public__charge__2019_04_status_scheduled_date_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
13. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on public__charge__2019_05 (cost=4.17..11.28 rows=3 width=32) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (charge_status = 'ACTIVE'::charge_status)
14. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on public__charge__2019_05_status_scheduled_date_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
15. 0.000 0.001 ↓ 0.0 0 1

Bitmap Heap Scan on public__charge__2019_06 (cost=4.17..11.28 rows=3 width=32) (actual time=0.001..0.001 rows=0 loops=1)

  • Recheck Cond: (charge_status = 'ACTIVE'::charge_status)
16. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on public__charge__2019_06_status_scheduled_date_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
17. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on public__charge__2019_07 (cost=4.17..11.28 rows=3 width=32) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (charge_status = 'ACTIVE'::charge_status)
18. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on public__charge__2019_07_status_scheduled_date_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
19. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on public__charge__2019_08 (cost=0.00..1.61 rows=10 width=32) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: (charge_status = 'ACTIVE'::charge_status)
  • Rows Removed by Filter: 49
20. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on public__charge__2019_09 (cost=0.00..2.99 rows=1 width=32) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (charge_status = 'ACTIVE'::charge_status)
  • Rows Removed by Filter: 79
21. 0.008 0.008 ↓ 0.0 0 1

Index Scan using public__charge__2019_10_status_scheduled_date_idx on public__charge__2019_10 (cost=0.27..6.14 rows=1 width=32) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
22. 0.009 0.020 ↓ 0.0 0 1

Bitmap Heap Scan on public__charge__2019_11 (cost=4.34..15.71 rows=8 width=32) (actual time=0.020..0.020 rows=0 loops=1)

  • Recheck Cond: (charge_status = 'ACTIVE'::charge_status)
  • Heap Blocks: exact=9
23. 0.011 0.011 ↓ 4.9 39 1

Bitmap Index Scan on public__charge__2019_11_status_scheduled_date_idx (cost=0.00..4.33 rows=8 width=0) (actual time=0.011..0.011 rows=39 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
24. 0.010 0.027 ↓ 0.0 0 1

Bitmap Heap Scan on public__charge__2019_12 (cost=4.82..43.17 rows=70 width=32) (actual time=0.026..0.027 rows=0 loops=1)

  • Recheck Cond: (charge_status = 'ACTIVE'::charge_status)
  • Heap Blocks: exact=8
25. 0.017 0.017 ↓ 1.6 112 1

Bitmap Index Scan on public__charge__2019_12_status_scheduled_date_idx (cost=0.00..4.81 rows=70 width=0) (actual time=0.016..0.017 rows=112 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
26. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on public__charge__2020_01 (cost=4.81..59.37 rows=68 width=32) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (charge_status = 'ACTIVE'::charge_status)
27. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on public__charge__2020_01_status_scheduled_date_idx (cost=0.00..4.79 rows=68 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
28. 0.008 0.008 ↓ 0.0 0 1

Index Scan using public__charge__2020_02_status_scheduled_date_idx on public__charge__2020_02 (cost=0.28..15.63 rows=5 width=32) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
29. 0.504 0.504 ↑ 1.1 923 1

Seq Scan on public__charge__2020_03 (cost=0.00..82.04 rows=997 width=32) (actual time=0.010..0.504 rows=923 loops=1)

  • Filter: (charge_status = 'ACTIVE'::charge_status)
  • Rows Removed by Filter: 1721
30. 0.494 0.494 ↓ 1.0 1,536 1

Seq Scan on public__charge__2020_04 (cost=0.00..49.09 rows=1,510 width=32) (actual time=0.004..0.494 rows=1,536 loops=1)

  • Filter: (charge_status = 'ACTIVE'::charge_status)
  • Rows Removed by Filter: 17
31. 0.003 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on public__charge__2020_05 (cost=4.17..11.28 rows=3 width=32) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: (charge_status = 'ACTIVE'::charge_status)
32. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on public__charge__2020_05_status_scheduled_date_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
33. 0.000 0.001 ↓ 0.0 0 1

Bitmap Heap Scan on public__charge__2020_06 (cost=4.17..11.28 rows=3 width=32) (actual time=0.001..0.001 rows=0 loops=1)

  • Recheck Cond: (charge_status = 'ACTIVE'::charge_status)
34. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on public__charge__2020_06_status_scheduled_date_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
35. 0.000 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on public__charge__2020_07 (cost=4.17..11.28 rows=3 width=32) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (charge_status = 'ACTIVE'::charge_status)
36. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on public__charge__2020_07_status_scheduled_date_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
37. 0.000 0.001 ↓ 0.0 0 1

Bitmap Heap Scan on public__charge__2020_08 (cost=4.17..11.28 rows=3 width=32) (actual time=0.001..0.001 rows=0 loops=1)

  • Recheck Cond: (charge_status = 'ACTIVE'::charge_status)
38. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on public__charge__2020_08_status_scheduled_date_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
39. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on public__charge__2020_09 (cost=4.17..11.28 rows=3 width=32) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (charge_status = 'ACTIVE'::charge_status)
40. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on public__charge__2020_09_status_scheduled_date_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
41. 0.002 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on public__charge__2020_10 (cost=4.17..11.28 rows=3 width=32) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (charge_status = 'ACTIVE'::charge_status)
42. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on public__charge__2020_10_status_scheduled_date_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
43. 0.001 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on public__charge__2020_11 (cost=4.17..11.28 rows=3 width=32) (actual time=0.001..0.002 rows=0 loops=1)

  • Recheck Cond: (charge_status = 'ACTIVE'::charge_status)
44. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on public__charge__2020_11_status_scheduled_date_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
45. 0.002 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on public__charge__2020_12 (cost=4.17..11.28 rows=3 width=32) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (charge_status = 'ACTIVE'::charge_status)
46. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on public__charge__2020_12_status_scheduled_date_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
47. 0.000 0.001 ↓ 0.0 0 1

Bitmap Heap Scan on public__charge__2021_01 (cost=4.17..11.28 rows=3 width=32) (actual time=0.001..0.001 rows=0 loops=1)

  • Recheck Cond: (charge_status = 'ACTIVE'::charge_status)
48. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on public__charge__2021_01_status_scheduled_date_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
49. 0.001 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on public__charge__2021_02 (cost=4.17..11.28 rows=3 width=32) (actual time=0.003..0.004 rows=0 loops=1)

  • Recheck Cond: (charge_status = 'ACTIVE'::charge_status)
50. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on public__charge__2021_02_status_scheduled_date_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
51. 0.000 0.001 ↓ 0.0 0 1

Bitmap Heap Scan on public__charge__2021_03 (cost=4.17..11.28 rows=3 width=32) (actual time=0.001..0.001 rows=0 loops=1)

  • Recheck Cond: (charge_status = 'ACTIVE'::charge_status)
52. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on public__charge__2021_03_status_scheduled_date_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
53. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on public__charge__2021_04 (cost=4.17..11.28 rows=3 width=32) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (charge_status = 'ACTIVE'::charge_status)
54. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on public__charge__2021_04_status_scheduled_date_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
55. 0.002 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on public__charge__2021_05 (cost=4.17..11.28 rows=3 width=32) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (charge_status = 'ACTIVE'::charge_status)
56. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on public__charge__2021_05_status_scheduled_date_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
57. 0.000 0.001 ↓ 0.0 0 1

Bitmap Heap Scan on public__charge__2021_06 (cost=4.17..11.28 rows=3 width=32) (actual time=0.001..0.001 rows=0 loops=1)

  • Recheck Cond: (charge_status = 'ACTIVE'::charge_status)
58. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on public__charge__2021_06_status_scheduled_date_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
59. 0.002 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on public__charge__2021_07 (cost=4.17..11.28 rows=3 width=32) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (charge_status = 'ACTIVE'::charge_status)
60. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on public__charge__2021_07_status_scheduled_date_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
61. 0.000 0.001 ↓ 0.0 0 1

Bitmap Heap Scan on public__charge__2021_08 (cost=4.17..11.28 rows=3 width=32) (actual time=0.001..0.001 rows=0 loops=1)

  • Recheck Cond: (charge_status = 'ACTIVE'::charge_status)
62. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on public__charge__2021_08_status_scheduled_date_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
63. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on public__charge__2021_09 (cost=4.17..11.28 rows=3 width=32) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (charge_status = 'ACTIVE'::charge_status)
64. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on public__charge__2021_09_status_scheduled_date_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
65. 0.000 0.001 ↓ 0.0 0 1

Bitmap Heap Scan on public__charge__2021_10 (cost=4.17..11.28 rows=3 width=32) (actual time=0.001..0.001 rows=0 loops=1)

  • Recheck Cond: (charge_status = 'ACTIVE'::charge_status)
66. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on public__charge__2021_10_status_scheduled_date_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
67. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on public__charge__2021_11 (cost=4.17..11.28 rows=3 width=32) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (charge_status = 'ACTIVE'::charge_status)
68. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on public__charge__2021_11_status_scheduled_date_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
69. 0.002 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on public__charge__2021_12 (cost=4.17..11.28 rows=3 width=32) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (charge_status = 'ACTIVE'::charge_status)
70. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on public__charge__2021_12_status_scheduled_date_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
71. 0.000 0.001 ↓ 0.0 0 1

Bitmap Heap Scan on public__charge__2022_01 (cost=4.17..11.28 rows=3 width=32) (actual time=0.001..0.001 rows=0 loops=1)

  • Recheck Cond: (charge_status = 'ACTIVE'::charge_status)
72. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on public__charge__2022_01_status_scheduled_date_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
73. 0.004 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on public__charge__2022_02 (cost=4.17..11.28 rows=3 width=32) (actual time=0.004..0.005 rows=0 loops=1)

  • Recheck Cond: (charge_status = 'ACTIVE'::charge_status)
74. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on public__charge__2022_02_status_scheduled_date_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
75. 0.002 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on public__charge__2022_03 (cost=4.17..11.28 rows=3 width=32) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (charge_status = 'ACTIVE'::charge_status)
76. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on public__charge__2022_03_status_scheduled_date_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
77. 0.000 0.001 ↓ 0.0 0 1

Bitmap Heap Scan on public__charge__2022_04 (cost=4.17..11.28 rows=3 width=32) (actual time=0.001..0.001 rows=0 loops=1)

  • Recheck Cond: (charge_status = 'ACTIVE'::charge_status)
78. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on public__charge__2022_04_status_scheduled_date_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
79. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on public__charge__2022_05 (cost=4.17..11.28 rows=3 width=32) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (charge_status = 'ACTIVE'::charge_status)
80. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on public__charge__2022_05_status_scheduled_date_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
81. 0.000 0.001 ↓ 0.0 0 1

Bitmap Heap Scan on public__charge__2022_06 (cost=4.17..11.28 rows=3 width=32) (actual time=0.001..0.001 rows=0 loops=1)

  • Recheck Cond: (charge_status = 'ACTIVE'::charge_status)
82. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on public__charge__2022_06_status_scheduled_date_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
83. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on public__charge__2022_07 (cost=4.17..11.28 rows=3 width=32) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (charge_status = 'ACTIVE'::charge_status)
84. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on public__charge__2022_07_status_scheduled_date_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
85. 0.002 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on public__charge__2022_08 (cost=4.17..11.28 rows=3 width=32) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (charge_status = 'ACTIVE'::charge_status)
86. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on public__charge__2022_08_status_scheduled_date_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
87. 0.000 0.001 ↓ 0.0 0 1

Bitmap Heap Scan on public__charge__2022_09 (cost=4.17..11.28 rows=3 width=32) (actual time=0.001..0.001 rows=0 loops=1)

  • Recheck Cond: (charge_status = 'ACTIVE'::charge_status)
88. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on public__charge__2022_09_status_scheduled_date_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
89. 0.002 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on public__charge__2022_10 (cost=4.17..11.28 rows=3 width=32) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (charge_status = 'ACTIVE'::charge_status)
90. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on public__charge__2022_10_status_scheduled_date_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
91. 0.000 0.001 ↓ 0.0 0 1

Bitmap Heap Scan on public__charge__2022_11 (cost=4.17..11.28 rows=3 width=32) (actual time=0.001..0.001 rows=0 loops=1)

  • Recheck Cond: (charge_status = 'ACTIVE'::charge_status)
92. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on public__charge__2022_11_status_scheduled_date_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
93. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on public__charge__2022_12 (cost=4.17..11.28 rows=3 width=32) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (charge_status = 'ACTIVE'::charge_status)
94. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on public__charge__2022_12_status_scheduled_date_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (charge_status = 'ACTIVE'::charge_status)
95. 0.777 1.938 ↓ 1.0 2,491 1

Hash (cost=150.89..150.89 rows=2,482 width=16) (actual time=1.938..1.938 rows=2,491 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 149kB
96. 1.161 1.161 ↓ 1.0 2,491 1

Seq Scan on fee (cost=0.00..150.89 rows=2,482 width=16) (actual time=0.005..1.161 rows=2,491 loops=1)

  • Filter: (fee_status = 'ACTIVE'::fee_status)
  • Rows Removed by Filter: 1473
97. 0.004 0.008 ↑ 1.0 3 1

Hash (cost=1.03..1.03 rows=3 width=48) (actual time=0.008..0.008 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
98. 0.004 0.004 ↑ 1.0 3 1

Seq Scan on amount_override (cost=0.00..1.03 rows=3 width=48) (actual time=0.003..0.004 rows=3 loops=1)

Planning time : 3.270 ms
Execution time : 5.430 ms