explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GkG4

Settings
# exclusive inclusive rows x rows loops node
1. 0.193 51,471.132 ↑ 1.0 100 1

Limit (cost=19,816,568.43..19,818,014.65 rows=100 width=2,116) (actual time=24,686.535..51,471.132 rows=100 loops=1)

  • Buffers: shared hit=328280 read=276898, temp read=4027794 written=119505
2.          

CTE p

3. 106.280 106.280 ↓ 1.0 136,024 1

Seq Scan on user_player p_1 (cost=0.00..16,729.84 rows=130,293 width=2,235) (actual time=0.017..106.280 rows=136,024 loops=1)

  • Filter: (((fwebcode)::text = ANY ('{618}'::text[])) AND ((floginname)::text ~~ '%sh\_%'::text) AND (fhouseplayer = 'N'::bpchar))
  • Rows Removed by Filter: 7043
  • Buffers: shared hit=14405
4. 7,524.995 51,470.939 ↑ 35,479,891.4 100 1

Nested Loop (cost=19,799,838.59..51,331,654,785.89 rows=3,547,989,139 width=2,116) (actual time=24,686.532..51,470.939 rows=100 loops=1)

  • Join Filter: (p.fid = (user_balancereport_2012.fuserid)::bpchar)
  • Rows Removed by Join Filter: 70695936
  • Buffers: shared hit=328280 read=276898, temp read=4027794 written=119505
5. 1.012 24,290.984 ↑ 10,473.4 520 1

Merge Append (cost=19,799,838.59..20,065,547.24 rows=5,446,170 width=831) (actual time=24,288.861..24,290.984 rows=520 loops=1)

  • Sort Key: user_balancereport_2012.freportdate DESC
  • Buffers: shared hit=313875 read=276898, temp read=63657 written=111863
6. 0.049 0.049 ↓ 0.0 0 1

Index Scan Backward using idx_user_blrpt_dtidtotbal_2012 on user_balancereport_2012 (cost=0.14..8.16 rows=1 width=1,336) (actual time=0.048..0.049 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
7. 0.013 0.013 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2013_20_freportdate_fuserid_totalbala_idx on user_balancereport_sg_2013_2012m12 (cost=0.14..8.16 rows=1 width=1,336) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
8. 0.011 0.011 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2013_20_freportdate_fuserid_totalbal_idx1 on user_balancereport_sg_2013_2013m01 (cost=0.14..8.16 rows=1 width=1,336) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
9. 0.010 0.010 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2013_20_freportdate_fuserid_totalbal_idx2 on user_balancereport_sg_2013_2013m02 (cost=0.14..8.16 rows=1 width=1,336) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
10. 0.010 0.010 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2013_20_freportdate_fuserid_totalbal_idx3 on user_balancereport_sg_2013_2013m03 (cost=0.14..8.16 rows=1 width=1,336) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
11. 0.010 0.010 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2013_20_freportdate_fuserid_totalbal_idx4 on user_balancereport_sg_2013_2013m04 (cost=0.14..8.16 rows=1 width=1,336) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
12. 0.009 0.009 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2013_20_freportdate_fuserid_totalbal_idx5 on user_balancereport_sg_2013_2013m05 (cost=0.14..8.16 rows=1 width=1,336) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
13. 0.010 0.010 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2013_20_freportdate_fuserid_totalbal_idx6 on user_balancereport_sg_2013_2013m06 (cost=0.14..8.16 rows=1 width=1,336) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
14. 0.010 0.010 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2013_20_freportdate_fuserid_totalbal_idx7 on user_balancereport_sg_2013_2013m07 (cost=0.14..8.16 rows=1 width=1,336) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
15. 0.011 0.011 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2013_20_freportdate_fuserid_totalbal_idx8 on user_balancereport_sg_2013_2013m08 (cost=0.14..8.16 rows=1 width=1,336) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
16. 0.011 0.011 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2013_20_freportdate_fuserid_totalbal_idx9 on user_balancereport_sg_2013_2013m09 (cost=0.14..8.16 rows=1 width=1,336) (actual time=0.010..0.011 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
17. 0.009 0.009 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2013_2_freportdate_fuserid_totalbal_idx10 on user_balancereport_sg_2013_2013m10 (cost=0.14..8.16 rows=1 width=1,336) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
18. 0.010 0.010 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2013_2_freportdate_fuserid_totalbal_idx11 on user_balancereport_sg_2013_2013m11 (cost=0.14..8.16 rows=1 width=1,336) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
19. 0.010 0.010 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2013_2_freportdate_fuserid_totalbal_idx12 on user_balancereport_sg_2013_2013m12 (cost=0.14..8.16 rows=1 width=1,336) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
20. 0.010 0.010 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2014_20_freportdate_fuserid_totalbala_idx on user_balancereport_sg_2014_2014m01 (cost=0.14..8.16 rows=1 width=1,336) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
21. 0.010 0.010 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2014_20_freportdate_fuserid_totalbal_idx1 on user_balancereport_sg_2014_2014m02 (cost=0.14..8.16 rows=1 width=1,336) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
22. 0.010 0.010 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2014_20_freportdate_fuserid_totalbal_idx2 on user_balancereport_sg_2014_2014m03 (cost=0.14..8.16 rows=1 width=1,336) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
23. 0.010 0.010 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2014_20_freportdate_fuserid_totalbal_idx3 on user_balancereport_sg_2014_2014m04 (cost=0.14..8.16 rows=1 width=1,336) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
24. 0.010 0.010 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2014_20_freportdate_fuserid_totalbal_idx4 on user_balancereport_sg_2014_2014m05 (cost=0.14..8.16 rows=1 width=1,336) (actual time=0.009..0.010 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
25. 0.009 0.009 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2014_20_freportdate_fuserid_totalbal_idx5 on user_balancereport_sg_2014_2014m06 (cost=0.14..8.16 rows=1 width=1,336) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
26. 0.010 0.010 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2014_20_freportdate_fuserid_totalbal_idx6 on user_balancereport_sg_2014_2014m07 (cost=0.14..8.16 rows=1 width=1,336) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
27. 0.011 0.011 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2014_20_freportdate_fuserid_totalbal_idx7 on user_balancereport_sg_2014_2014m08 (cost=0.14..8.16 rows=1 width=1,336) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
28. 0.021 0.021 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2014_20_freportdate_fuserid_totalbal_idx8 on user_balancereport_sg_2014_2014m09 (cost=0.15..8.17 rows=1 width=1,175) (actual time=0.020..0.021 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
29. 0.016 0.016 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2014_20_freportdate_fuserid_totalbal_idx9 on user_balancereport_sg_2014_2014m10 (cost=0.28..8.30 rows=1 width=1,148) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=2
30. 0.016 0.016 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2014_2_freportdate_fuserid_totalbal_idx10 on user_balancereport_sg_2014_2014m11 (cost=0.28..8.30 rows=1 width=1,148) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=2
31. 0.016 0.016 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2014_2_freportdate_fuserid_totalbal_idx11 on user_balancereport_sg_2014_2014m12 (cost=0.28..8.30 rows=1 width=1,146) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=2
32. 0.016 0.016 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2015_20_freportdate_fuserid_totalbala_idx on user_balancereport_sg_2015_2015m01 (cost=0.29..8.31 rows=1 width=1,144) (actual time=0.015..0.016 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=2
33. 0.018 0.018 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2015_20_freportdate_fuserid_totalbal_idx1 on user_balancereport_sg_2015_2015m02 (cost=0.42..8.44 rows=1 width=1,139) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=3
34. 0.019 0.019 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2015_20_freportdate_fuserid_totalbal_idx2 on user_balancereport_sg_2015_2015m03 (cost=0.42..8.44 rows=1 width=1,139) (actual time=0.019..0.019 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=3
35. 0.020 0.020 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2015_20_freportdate_fuserid_totalbal_idx3 on user_balancereport_sg_2015_2015m04 (cost=0.42..8.45 rows=1 width=1,139) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=3
36. 0.020 0.020 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2015_20_freportdate_fuserid_totalbal_idx4 on user_balancereport_sg_2015_2015m05 (cost=0.42..8.45 rows=1 width=1,139) (actual time=0.019..0.020 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=3
37. 0.019 0.019 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2015_20_freportdate_fuserid_totalbal_idx5 on user_balancereport_sg_2015_2015m06 (cost=0.43..8.45 rows=1 width=1,139) (actual time=0.019..0.019 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=3
38. 0.021 0.021 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2015_20_freportdate_fuserid_totalbal_idx6 on user_balancereport_sg_2015_2015m07 (cost=0.43..8.45 rows=1 width=1,140) (actual time=0.021..0.021 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=3
39. 0.058 0.058 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2015_20_freportdate_fuserid_totalbal_idx7 on user_balancereport_sg_2015_2015m08 (cost=0.43..8.45 rows=1 width=1,140) (actual time=0.058..0.058 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=3
40. 0.046 0.046 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2015_20_freportdate_fuserid_totalbal_idx8 on user_balancereport_sg_2015_2015m09 (cost=0.43..8.45 rows=1 width=1,140) (actual time=0.046..0.046 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=3
41. 0.013 0.013 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2015_20_freportdate_fuserid_totalbal_idx9 on user_balancereport_sg_2015_2015m10 (cost=0.43..8.45 rows=1 width=1,140) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=3
42. 0.014 0.014 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2015_2_freportdate_fuserid_totalbal_idx10 on user_balancereport_sg_2015_2015m11 (cost=0.43..8.45 rows=1 width=1,140) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=3
43. 0.011 0.011 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2015_2_freportdate_fuserid_totalbal_idx11 on user_balancereport_sg_2015_2015m12 (cost=0.43..8.45 rows=1 width=1,140) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=3
44. 0.012 0.012 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2016_20_freportdate_fuserid_totalbala_idx on user_balancereport_sg_2016_2016m01 (cost=0.56..8.57 rows=1 width=1,127) (actual time=0.011..0.012 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=4
45. 0.014 0.014 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2016_20_freportdate_fuserid_totalbal_idx1 on user_balancereport_sg_2016_2016m02 (cost=0.56..8.58 rows=1 width=1,127) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=4
46. 0.012 0.012 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2016_20_freportdate_fuserid_totalbal_idx2 on user_balancereport_sg_2016_2016m03 (cost=0.56..8.58 rows=1 width=1,126) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=4
47. 0.011 0.011 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2016_20_freportdate_fuserid_totalbal_idx3 on user_balancereport_sg_2016_2016m04 (cost=0.56..8.58 rows=1 width=1,126) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=4
48. 0.012 0.012 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2016_20_freportdate_fuserid_totalbal_idx4 on user_balancereport_sg_2016_2016m05 (cost=0.56..8.58 rows=1 width=1,112) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=4
49. 0.011 0.011 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2016_20_freportdate_fuserid_totalbal_idx5 on user_balancereport_sg_2016_2016m06 (cost=0.56..8.58 rows=1 width=1,112) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=4
50. 0.018 0.018 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2016_20_freportdate_fuserid_totalbal_idx6 on user_balancereport_sg_2016_2016m07 (cost=0.56..8.58 rows=1 width=1,112) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=4
51. 0.013 0.013 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2016_20_freportdate_fuserid_totalbal_idx7 on user_balancereport_sg_2016_2016m08 (cost=0.56..8.58 rows=1 width=1,112) (actual time=0.012..0.013 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=4
52. 0.012 0.012 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2016_20_freportdate_fuserid_totalbal_idx8 on user_balancereport_sg_2016_2016m09 (cost=0.56..8.58 rows=1 width=1,112) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=4
53. 0.011 0.011 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2016_20_freportdate_fuserid_totalbal_idx9 on user_balancereport_sg_2016_2016m10 (cost=0.56..8.58 rows=1 width=1,112) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=4
54. 0.012 0.012 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2016_2_freportdate_fuserid_totalbal_idx10 on user_balancereport_sg_2016_2016m11 (cost=0.56..8.58 rows=1 width=1,111) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=4
55. 0.011 0.011 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2016_2_freportdate_fuserid_totalbal_idx11 on user_balancereport_sg_2016_2016m12 (cost=0.56..8.58 rows=1 width=1,110) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=4
56. 0.011 0.011 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_bf20170_freportdate_fuserid_totalbala_idx on user_balancereport_sg_bf201707_2017m01 (cost=0.56..8.58 rows=1 width=893) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=4
57. 0.010 0.010 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_bf20170_freportdate_fuserid_totalbal_idx1 on user_balancereport_sg_bf201707_2017m02 (cost=0.56..8.58 rows=1 width=892) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=4
58. 0.011 0.011 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_bf20170_freportdate_fuserid_totalbal_idx2 on user_balancereport_sg_bf201707_2017m03 (cost=0.56..8.58 rows=1 width=894) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=4
59. 0.016 0.016 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_bf20170_freportdate_fuserid_totalbal_idx3 on user_balancereport_sg_bf201707_2017m04 (cost=0.56..8.58 rows=1 width=1,071) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=4
60. 0.013 0.013 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_bf20170_freportdate_fuserid_totalbal_idx4 on user_balancereport_sg_bf201707_2017m05 (cost=0.56..8.58 rows=1 width=892) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=4
61. 0.014 0.014 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_bf20170_freportdate_fuserid_totalbal_idx5 on user_balancereport_sg_bf201707_2017m06 (cost=0.56..8.58 rows=1 width=1,070) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=4
62. 0.006 0.006 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_bf20170_freportdate_fuserid_totalbal_idx6 on user_balancereport_sg_bf201707_2017m07 (cost=0.14..8.16 rows=1 width=1,336) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
63. 0.005 0.005 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_bf20170_freportdate_fuserid_totalbal_idx7 on user_balancereport_sg_bf201707_2017m08 (cost=0.14..8.16 rows=1 width=1,336) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
64. 0.005 0.005 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_bf20170_freportdate_fuserid_totalbal_idx8 on user_balancereport_sg_bf201707_2017m09 (cost=0.14..8.16 rows=1 width=1,336) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
65. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_bf20170_freportdate_fuserid_totalbal_idx9 on user_balancereport_sg_bf201707_2017m10 (cost=0.14..8.16 rows=1 width=1,336) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
66. 0.005 0.005 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_bf2017_freportdate_fuserid_totalbal_idx10 on user_balancereport_sg_bf201707_2017m11 (cost=0.14..8.16 rows=1 width=1,336) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
67. 0.005 0.005 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_bf2017_freportdate_fuserid_totalbal_idx11 on user_balancereport_sg_bf201707_2017m12 (cost=0.14..8.16 rows=1 width=1,336) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
68. 0.005 0.005 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_bf2018__freportdate_fuserid_totalbala_idx on user_balancereport_sg_bf2018_2017m01 (cost=0.14..8.16 rows=1 width=1,336) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
69. 0.005 0.005 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_bf2018__freportdate_fuserid_totalbal_idx1 on user_balancereport_sg_bf2018_2017m02 (cost=0.14..8.16 rows=1 width=1,336) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
70. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_bf2018__freportdate_fuserid_totalbal_idx2 on user_balancereport_sg_bf2018_2017m03 (cost=0.14..8.16 rows=1 width=1,336) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
71. 0.005 0.005 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_bf2018__freportdate_fuserid_totalbal_idx3 on user_balancereport_sg_bf2018_2017m04 (cost=0.14..8.16 rows=1 width=1,336) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
72. 0.005 0.005 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_bf2018__freportdate_fuserid_totalbal_idx4 on user_balancereport_sg_bf2018_2017m05 (cost=0.14..8.16 rows=1 width=1,336) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
73. 0.005 0.005 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_bf2018__freportdate_fuserid_totalbal_idx5 on user_balancereport_sg_bf2018_2017m06 (cost=0.14..8.16 rows=1 width=1,336) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
74. 0.016 0.016 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_bf2018__freportdate_fuserid_totalbal_idx6 on user_balancereport_sg_bf2018_2017m07 (cost=0.56..8.58 rows=1 width=893) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=4
75. 0.013 0.013 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_bf2018__freportdate_fuserid_totalbal_idx7 on user_balancereport_sg_bf2018_2017m08 (cost=0.56..8.58 rows=1 width=980) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=4
76. 0.011 0.011 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_bf2018__freportdate_fuserid_totalbal_idx8 on user_balancereport_sg_bf2018_2017m09 (cost=0.56..8.58 rows=1 width=852) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=4
77. 0.015 0.015 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_bf2018__freportdate_fuserid_totalbal_idx9 on user_balancereport_sg_bf2018_2017m10 (cost=0.56..8.58 rows=1 width=829) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=4
78. 0.017 0.017 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_bf2018_freportdate_fuserid_totalbal_idx10 on user_balancereport_sg_bf2018_2017m11 (cost=0.56..8.58 rows=1 width=832) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=4
79. 0.012 0.012 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_bf2018_freportdate_fuserid_totalbal_idx11 on user_balancereport_sg_bf2018_2017m12 (cost=0.56..8.58 rows=1 width=827) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=4
80. 0.005 0.005 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_bf2018_freportdate_fuserid_totalbal_idx12 on user_balancereport_sg_bf2018_default (cost=0.14..8.16 rows=1 width=1,336) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
81. 0.015 0.015 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2018m01_freportdate_fuserid_totalbala_idx on user_balancereport_sg_2018m01 (cost=0.56..8.58 rows=1 width=895) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=4
82. 0.011 0.011 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2018m02_freportdate_fuserid_totalbala_idx on user_balancereport_sg_2018m02 (cost=0.56..8.58 rows=1 width=894) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=4
83. 0.012 0.012 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2018m03_freportdate_fuserid_totalbala_idx on user_balancereport_sg_2018m03 (cost=0.56..8.58 rows=1 width=895) (actual time=0.011..0.012 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=4
84. 0.012 0.012 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2018m04_freportdate_fuserid_totalbala_idx on user_balancereport_sg_2018m04 (cost=0.56..8.58 rows=1 width=894) (actual time=0.011..0.012 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=4
85. 0.012 0.012 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2018m05_freportdate_fuserid_totalbala_idx on user_balancereport_sg_2018m05 (cost=0.56..8.58 rows=1 width=895) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=4
86. 0.011 0.011 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2018m06_freportdate_fuserid_totalbala_idx on user_balancereport_sg_2018m06 (cost=0.56..8.58 rows=1 width=895) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=4
87. 0.009 0.009 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2018m07_freportdate_fuserid_totalbala_idx on user_balancereport_sg_2018m07 (cost=0.42..8.44 rows=1 width=947) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=3
88. 0.009 0.009 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2018m08_freportdate_fuserid_totalbala_idx on user_balancereport_sg_2018m08 (cost=0.42..8.44 rows=1 width=945) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=3
89. 0.009 0.009 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2018m09_freportdate_fuserid_totalbala_idx on user_balancereport_sg_2018m09 (cost=0.42..8.44 rows=1 width=943) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=3
90. 0.029 0.029 ↑ 44,363.0 1 1

Index Scan Backward using user_balancereport_sg_2018m10_freportdate_fuserid_totalbala_idx on user_balancereport_sg_2018m10 (cost=0.42..6,793.79 rows=44,363 width=941) (actual time=0.029..0.029 rows=1 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=4
91. 0.006 0.006 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2018m11_freportdate_fuserid_totalbala_idx on user_balancereport_sg_2018m11 (cost=0.14..8.16 rows=1 width=1,336) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
92. 0.005 0.005 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_2018m12_freportdate_fuserid_totalbala_idx on user_balancereport_sg_2018m12 (cost=0.14..8.16 rows=1 width=1,336) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
93. 0.005 0.005 ↓ 0.0 0 1

Index Scan Backward using user_balancereport_sg_default_freportdate_fuserid_totalbala_idx on user_balancereport_sg_default (cost=0.14..8.16 rows=1 width=1,336) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
94. 0.004 0.009 ↓ 0.0 0 1

Sort (cost=8.66..8.67 rows=1 width=1,336) (actual time=0.009..0.009 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2018m01_1.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
95. 0.005 0.005 ↓ 0.0 0 1

Index Scan using user_balancereport_sg_2018m01_pkey on user_balancereport_sg_2018m01 user_balancereport_sg_2018m01_1 (cost=0.14..8.65 rows=1 width=1,336) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
96. 0.001 0.006 ↓ 0.0 0 1

Sort (cost=8.66..8.67 rows=1 width=1,336) (actual time=0.006..0.006 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2018m02_1.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
97. 0.005 0.005 ↓ 0.0 0 1

Index Scan using user_balancereport_sg_2018m02_pkey on user_balancereport_sg_2018m02 user_balancereport_sg_2018m02_1 (cost=0.14..8.65 rows=1 width=1,336) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
98. 0.001 0.006 ↓ 0.0 0 1

Sort (cost=8.66..8.67 rows=1 width=1,336) (actual time=0.006..0.006 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2018m03_1.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
99. 0.005 0.005 ↓ 0.0 0 1

Index Scan using user_balancereport_sg_2018m03_pkey on user_balancereport_sg_2018m03 user_balancereport_sg_2018m03_1 (cost=0.14..8.65 rows=1 width=1,336) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
100. 0.001 0.006 ↓ 0.0 0 1

Sort (cost=8.66..8.67 rows=1 width=1,336) (actual time=0.006..0.006 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2018m04_1.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
101. 0.005 0.005 ↓ 0.0 0 1

Index Scan using user_balancereport_sg_2018m04_pkey on user_balancereport_sg_2018m04 user_balancereport_sg_2018m04_1 (cost=0.14..8.65 rows=1 width=1,336) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
102. 0.002 0.006 ↓ 0.0 0 1

Sort (cost=8.66..8.67 rows=1 width=1,336) (actual time=0.006..0.006 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2018m05_1.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
103. 0.004 0.004 ↓ 0.0 0 1

Index Scan using user_balancereport_sg_2018m05_pkey on user_balancereport_sg_2018m05 user_balancereport_sg_2018m05_1 (cost=0.14..8.65 rows=1 width=1,336) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
104. 0.002 0.007 ↓ 0.0 0 1

Sort (cost=8.66..8.67 rows=1 width=1,336) (actual time=0.007..0.007 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2018m06_1.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
105. 0.005 0.005 ↓ 0.0 0 1

Index Scan using user_balancereport_sg_2018m06_pkey on user_balancereport_sg_2018m06 user_balancereport_sg_2018m06_1 (cost=0.14..8.65 rows=1 width=1,336) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
106. 0.004 2,317.908 ↓ 0.0 0 1

Sort (cost=112,151.25..112,151.25 rows=1 width=895) (actual time=2,317.908..2,317.908 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2018m07_1.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=53230
107. 2,317.904 2,317.904 ↓ 0.0 0 1

Seq Scan on user_balancereport_sg_2018m07 user_balancereport_sg_2018m07_1 (cost=0.00..112,151.24 rows=1 width=895) (actual time=2,317.904..2,317.904 rows=0 loops=1)

  • Filter: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Rows Removed by Filter: 2946062
  • Buffers: shared hit=53230
108. 0.013 3,391.216 ↓ 0.0 0 1

Sort (cost=336,209.43..336,209.43 rows=1 width=894) (actual time=3,391.216..3,391.216 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2018m08_1.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=386 read=276898
109. 3,391.203 3,391.203 ↓ 0.0 0 1

Seq Scan on user_balancereport_sg_2018m08 user_balancereport_sg_2018m08_1 (cost=0.00..336,209.42 rows=1 width=894) (actual time=3,391.203..3,391.203 rows=0 loops=1)

  • Filter: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Rows Removed by Filter: 2946271
  • Buffers: shared hit=386 read=276898
110. 0.012 2,340.968 ↓ 0.0 0 1

Sort (cost=222,865.89..222,865.90 rows=1 width=895) (actual time=2,340.968..2,340.968 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2018m09_1.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=165839
111. 2,340.956 2,340.956 ↓ 0.0 0 1

Seq Scan on user_balancereport_sg_2018m09 user_balancereport_sg_2018m09_1 (cost=0.00..222,865.88 rows=1 width=895) (actual time=2,340.956..2,340.956 rows=0 loops=1)

  • Filter: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Rows Removed by Filter: 2851344
  • Buffers: shared hit=165839
112. 1,575.180 6,173.561 ↑ 1,899,087.0 1 1

Sort (cost=2,538,452.72..2,543,200.43 rows=1,899,087 width=895) (actual time=6,173.561..6,173.561 rows=1 loops=1)

  • Sort Key: user_balancereport_sg_2018m10_1.freportdate DESC
  • Sort Method: external merge Disk: 137096kB
  • Buffers: shared hit=42053, temp read=20541 written=37603
113. 4,598.381 4,598.381 ↓ 1.0 1,901,492 1

Seq Scan on user_balancereport_sg_2018m10 user_balancereport_sg_2018m10_1 (cost=0.00..100,999.12 rows=1,899,087 width=895) (actual time=4.934..4,598.381 rows=1,901,492 loops=1)

  • Filter: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Rows Removed by Filter: 1045814
  • Buffers: shared hit=42053
114. 2,610.189 8,503.012 ↑ 2,920,240.0 1 1

Sort (cost=3,498,278.34..3,505,578.94 rows=2,920,240 width=794) (actual time=8,503.012..8,503.012 rows=1 loops=1)

  • Sort Key: user_balancereport_sg_2018m11_1.freportdate DESC
  • Sort Method: external merge Disk: 210552kB
  • Buffers: shared hit=42046, temp read=40467 written=66593
115. 5,892.823 5,892.823 ↑ 1.0 2,920,240 1

Seq Scan on user_balancereport_sg_2018m11 user_balancereport_sg_2018m11_1 (cost=0.00..100,450.80 rows=2,920,240 width=794) (actual time=0.037..5,892.823 rows=2,920,240 loops=1)

  • Filter: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=42046
116. 403.524 1,560.702 ↑ 2,347.1 248 1

Sort (cost=487,281.89..488,737.08 rows=582,077 width=794) (actual time=1,559.894..1,560.702 rows=248 loops=1)

  • Sort Key: user_balancereport_sg_2018m12_1.freportdate DESC
  • Sort Method: external merge Disk: 42000kB
  • Buffers: shared hit=10061, temp read=2649 written=7667
117. 1,157.178 1,157.178 ↑ 1.0 582,077 1

Seq Scan on user_balancereport_sg_2018m12 user_balancereport_sg_2018m12_1 (cost=0.00..21,702.54 rows=582,077 width=794) (actual time=0.050..1,157.178 rows=582,077 loops=1)

  • Filter: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=10061
118. 0.499 1.078 ↑ 1.0 272 1

Sort (cost=22.44..23.12 rows=272 width=1,081) (actual time=0.735..1.078 rows=272 loops=1)

  • Sort Key: user_balancereport_sg_2019m01.freportdate DESC
  • Sort Method: quicksort Memory: 63kB
  • Buffers: shared hit=6
119. 0.579 0.579 ↑ 1.0 272 1

Seq Scan on user_balancereport_sg_2019m01 (cost=0.00..11.44 rows=272 width=1,081) (actual time=0.034..0.579 rows=272 loops=1)

  • Filter: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=6
120. 0.005 0.020 ↓ 0.0 0 1

Sort (cost=8.66..8.67 rows=1 width=1,336) (actual time=0.020..0.020 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2019m02.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
121. 0.015 0.015 ↓ 0.0 0 1

Index Scan using user_balancereport_sg_2019m02_pkey on user_balancereport_sg_2019m02 (cost=0.14..8.65 rows=1 width=1,336) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
122. 0.002 0.021 ↓ 0.0 0 1

Sort (cost=8.66..8.67 rows=1 width=1,336) (actual time=0.021..0.021 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2019m03.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
123. 0.019 0.019 ↓ 0.0 0 1

Index Scan using user_balancereport_sg_2019m03_pkey on user_balancereport_sg_2019m03 (cost=0.14..8.65 rows=1 width=1,336) (actual time=0.019..0.019 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
124. 0.003 0.010 ↓ 0.0 0 1

Sort (cost=8.66..8.67 rows=1 width=1,336) (actual time=0.010..0.010 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2019m04.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
125. 0.007 0.007 ↓ 0.0 0 1

Index Scan using user_balancereport_sg_2019m04_pkey on user_balancereport_sg_2019m04 (cost=0.14..8.65 rows=1 width=1,336) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
126. 0.003 0.009 ↓ 0.0 0 1

Sort (cost=8.66..8.67 rows=1 width=1,336) (actual time=0.009..0.009 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2019m05.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
127. 0.006 0.006 ↓ 0.0 0 1

Index Scan using user_balancereport_sg_2019m05_pkey on user_balancereport_sg_2019m05 (cost=0.14..8.65 rows=1 width=1,336) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
128. 0.003 0.009 ↓ 0.0 0 1

Sort (cost=8.66..8.67 rows=1 width=1,336) (actual time=0.009..0.009 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2019m06.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
129. 0.006 0.006 ↓ 0.0 0 1

Index Scan using user_balancereport_sg_2019m06_pkey on user_balancereport_sg_2019m06 (cost=0.14..8.65 rows=1 width=1,336) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
130. 0.003 0.019 ↓ 0.0 0 1

Sort (cost=8.66..8.67 rows=1 width=1,336) (actual time=0.019..0.019 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2019m07.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
131. 0.016 0.016 ↓ 0.0 0 1

Index Scan using user_balancereport_sg_2019m07_pkey on user_balancereport_sg_2019m07 (cost=0.14..8.65 rows=1 width=1,336) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
132. 0.003 0.013 ↓ 0.0 0 1

Sort (cost=8.66..8.67 rows=1 width=1,336) (actual time=0.013..0.013 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2019m08.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
133. 0.010 0.010 ↓ 0.0 0 1

Index Scan using user_balancereport_sg_2019m08_pkey on user_balancereport_sg_2019m08 (cost=0.14..8.65 rows=1 width=1,336) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
134. 0.003 0.009 ↓ 0.0 0 1

Sort (cost=8.66..8.67 rows=1 width=1,336) (actual time=0.009..0.009 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2019m09.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
135. 0.006 0.006 ↓ 0.0 0 1

Index Scan using user_balancereport_sg_2019m09_pkey on user_balancereport_sg_2019m09 (cost=0.14..8.65 rows=1 width=1,336) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
136. 0.002 0.008 ↓ 0.0 0 1

Sort (cost=8.66..8.67 rows=1 width=1,336) (actual time=0.008..0.008 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2019m10.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
137. 0.006 0.006 ↓ 0.0 0 1

Index Scan using user_balancereport_sg_2019m10_pkey on user_balancereport_sg_2019m10 (cost=0.14..8.65 rows=1 width=1,336) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
138. 0.003 0.009 ↓ 0.0 0 1

Sort (cost=8.66..8.67 rows=1 width=1,336) (actual time=0.009..0.009 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2019m11.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
139. 0.006 0.006 ↓ 0.0 0 1

Index Scan using user_balancereport_sg_2019m11_pkey on user_balancereport_sg_2019m11 (cost=0.14..8.65 rows=1 width=1,336) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
140. 0.002 0.009 ↓ 0.0 0 1

Sort (cost=8.66..8.67 rows=1 width=1,336) (actual time=0.009..0.009 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2019m12.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
141. 0.007 0.007 ↓ 0.0 0 1

Index Scan using user_balancereport_sg_2019m12_pkey on user_balancereport_sg_2019m12 (cost=0.14..8.65 rows=1 width=1,336) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
142. 0.003 0.009 ↓ 0.0 0 1

Sort (cost=8.66..8.67 rows=1 width=1,336) (actual time=0.009..0.009 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2020m01.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
143. 0.006 0.006 ↓ 0.0 0 1

Index Scan using user_balancereport_sg_2020m01_pkey on user_balancereport_sg_2020m01 (cost=0.14..8.65 rows=1 width=1,336) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
144. 0.003 0.012 ↓ 0.0 0 1

Sort (cost=8.66..8.67 rows=1 width=1,336) (actual time=0.012..0.012 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2020m02.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
145. 0.009 0.009 ↓ 0.0 0 1

Index Scan using user_balancereport_sg_2020m02_pkey on user_balancereport_sg_2020m02 (cost=0.14..8.65 rows=1 width=1,336) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
146. 0.003 0.009 ↓ 0.0 0 1

Sort (cost=8.66..8.67 rows=1 width=1,336) (actual time=0.009..0.009 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2020m03.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
147. 0.006 0.006 ↓ 0.0 0 1

Index Scan using user_balancereport_sg_2020m03_pkey on user_balancereport_sg_2020m03 (cost=0.14..8.65 rows=1 width=1,336) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
148. 0.003 0.009 ↓ 0.0 0 1

Sort (cost=8.66..8.67 rows=1 width=1,336) (actual time=0.009..0.009 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2020m04.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
149. 0.006 0.006 ↓ 0.0 0 1

Index Scan using user_balancereport_sg_2020m04_pkey on user_balancereport_sg_2020m04 (cost=0.14..8.65 rows=1 width=1,336) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
150. 0.003 0.009 ↓ 0.0 0 1

Sort (cost=8.66..8.67 rows=1 width=1,336) (actual time=0.008..0.009 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2020m05.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
151. 0.006 0.006 ↓ 0.0 0 1

Index Scan using user_balancereport_sg_2020m05_pkey on user_balancereport_sg_2020m05 (cost=0.14..8.65 rows=1 width=1,336) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
152. 0.003 0.009 ↓ 0.0 0 1

Sort (cost=8.66..8.67 rows=1 width=1,336) (actual time=0.009..0.009 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2020m06.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
153. 0.006 0.006 ↓ 0.0 0 1

Index Scan using user_balancereport_sg_2020m06_pkey on user_balancereport_sg_2020m06 (cost=0.14..8.65 rows=1 width=1,336) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
154. 0.003 0.022 ↓ 0.0 0 1

Sort (cost=8.66..8.67 rows=1 width=1,336) (actual time=0.022..0.022 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2020m07.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
155. 0.019 0.019 ↓ 0.0 0 1

Index Scan using user_balancereport_sg_2020m07_pkey on user_balancereport_sg_2020m07 (cost=0.14..8.65 rows=1 width=1,336) (actual time=0.019..0.019 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
156. 0.003 0.009 ↓ 0.0 0 1

Sort (cost=8.66..8.67 rows=1 width=1,336) (actual time=0.009..0.009 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2020m08.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
157. 0.006 0.006 ↓ 0.0 0 1

Index Scan using user_balancereport_sg_2020m08_pkey on user_balancereport_sg_2020m08 (cost=0.14..8.65 rows=1 width=1,336) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
158. 0.003 0.009 ↓ 0.0 0 1

Sort (cost=8.66..8.67 rows=1 width=1,336) (actual time=0.009..0.009 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2020m09.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
159. 0.006 0.006 ↓ 0.0 0 1

Index Scan using user_balancereport_sg_2020m09_pkey on user_balancereport_sg_2020m09 (cost=0.14..8.65 rows=1 width=1,336) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
160. 0.002 0.008 ↓ 0.0 0 1

Sort (cost=8.66..8.67 rows=1 width=1,336) (actual time=0.008..0.008 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2020m10.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
161. 0.006 0.006 ↓ 0.0 0 1

Index Scan using user_balancereport_sg_2020m10_pkey on user_balancereport_sg_2020m10 (cost=0.14..8.65 rows=1 width=1,336) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
162. 0.002 0.008 ↓ 0.0 0 1

Sort (cost=8.66..8.67 rows=1 width=1,336) (actual time=0.008..0.008 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2020m11.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
163. 0.006 0.006 ↓ 0.0 0 1

Index Scan using user_balancereport_sg_2020m11_pkey on user_balancereport_sg_2020m11 (cost=0.14..8.65 rows=1 width=1,336) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
164. 0.002 0.011 ↓ 0.0 0 1

Sort (cost=8.66..8.67 rows=1 width=1,336) (actual time=0.011..0.011 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2020m12.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
165. 0.009 0.009 ↓ 0.0 0 1

Index Scan using user_balancereport_sg_2020m12_pkey on user_balancereport_sg_2020m12 (cost=0.14..8.65 rows=1 width=1,336) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
166. 0.003 0.009 ↓ 0.0 0 1

Sort (cost=8.66..8.67 rows=1 width=1,336) (actual time=0.009..0.009 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2021m01.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
167. 0.006 0.006 ↓ 0.0 0 1

Index Scan using user_balancereport_sg_2021m01_pkey on user_balancereport_sg_2021m01 (cost=0.14..8.65 rows=1 width=1,336) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
168. 0.002 0.009 ↓ 0.0 0 1

Sort (cost=8.66..8.67 rows=1 width=1,336) (actual time=0.009..0.009 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2021m02.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
169. 0.007 0.007 ↓ 0.0 0 1

Index Scan using user_balancereport_sg_2021m02_pkey on user_balancereport_sg_2021m02 (cost=0.14..8.65 rows=1 width=1,336) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
170. 0.002 0.008 ↓ 0.0 0 1

Sort (cost=8.66..8.67 rows=1 width=1,336) (actual time=0.008..0.008 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2021m03.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
171. 0.006 0.006 ↓ 0.0 0 1

Index Scan using user_balancereport_sg_2021m03_pkey on user_balancereport_sg_2021m03 (cost=0.14..8.65 rows=1 width=1,336) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
172. 0.002 0.008 ↓ 0.0 0 1

Sort (cost=8.66..8.67 rows=1 width=1,336) (actual time=0.008..0.008 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2021m04.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
173. 0.006 0.006 ↓ 0.0 0 1

Index Scan using user_balancereport_sg_2021m04_pkey on user_balancereport_sg_2021m04 (cost=0.14..8.65 rows=1 width=1,336) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
174. 0.002 0.011 ↓ 0.0 0 1

Sort (cost=8.66..8.67 rows=1 width=1,336) (actual time=0.011..0.011 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2021m05.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
175. 0.009 0.009 ↓ 0.0 0 1

Index Scan using user_balancereport_sg_2021m05_pkey on user_balancereport_sg_2021m05 (cost=0.14..8.65 rows=1 width=1,336) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
176. 0.003 0.009 ↓ 0.0 0 1

Sort (cost=8.66..8.67 rows=1 width=1,336) (actual time=0.009..0.009 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2021m06.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
177. 0.006 0.006 ↓ 0.0 0 1

Index Scan using user_balancereport_sg_2021m06_pkey on user_balancereport_sg_2021m06 (cost=0.14..8.65 rows=1 width=1,336) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
178. 0.002 0.008 ↓ 0.0 0 1

Sort (cost=8.66..8.67 rows=1 width=1,336) (actual time=0.008..0.008 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2021m07.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
179. 0.006 0.006 ↓ 0.0 0 1

Index Scan using user_balancereport_sg_2021m07_pkey on user_balancereport_sg_2021m07 (cost=0.14..8.65 rows=1 width=1,336) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
180. 0.002 0.008 ↓ 0.0 0 1

Sort (cost=8.66..8.67 rows=1 width=1,336) (actual time=0.008..0.008 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2021m08.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
181. 0.006 0.006 ↓ 0.0 0 1

Index Scan using user_balancereport_sg_2021m08_pkey on user_balancereport_sg_2021m08 (cost=0.14..8.65 rows=1 width=1,336) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
182. 0.002 0.008 ↓ 0.0 0 1

Sort (cost=8.66..8.67 rows=1 width=1,336) (actual time=0.008..0.008 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2021m09.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
183. 0.006 0.006 ↓ 0.0 0 1

Index Scan using user_balancereport_sg_2021m09_pkey on user_balancereport_sg_2021m09 (cost=0.14..8.65 rows=1 width=1,336) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
184. 0.003 0.009 ↓ 0.0 0 1

Sort (cost=8.66..8.67 rows=1 width=1,336) (actual time=0.009..0.009 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2021m10.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
185. 0.006 0.006 ↓ 0.0 0 1

Index Scan using user_balancereport_sg_2021m10_pkey on user_balancereport_sg_2021m10 (cost=0.14..8.65 rows=1 width=1,336) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
186. 0.002 0.008 ↓ 0.0 0 1

Sort (cost=8.66..8.67 rows=1 width=1,336) (actual time=0.008..0.008 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2021m11.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
187. 0.006 0.006 ↓ 0.0 0 1

Index Scan using user_balancereport_sg_2021m11_pkey on user_balancereport_sg_2021m11 (cost=0.14..8.65 rows=1 width=1,336) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
188. 0.002 0.008 ↓ 0.0 0 1

Sort (cost=8.66..8.67 rows=1 width=1,336) (actual time=0.008..0.008 rows=0 loops=1)

  • Sort Key: user_balancereport_sg_2021m12.freportdate DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
189. 0.006 0.006 ↓ 0.0 0 1

Index Scan using user_balancereport_sg_2021m12_pkey on user_balancereport_sg_2021m12 (cost=0.14..8.65 rows=1 width=1,336) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((freportdate >= to_timestamp('2018-10-12 00:00:00'::text, 'yyyy-mm-dd hh24:mi:ss'::text)) AND (freportdate <= to_timestamp('2019-01-10 23:59:59'::text, 'yyyy-mm-dd hh24:mi:ss'::text)))
  • Buffers: shared hit=1
190. 19,654.960 19,654.960 ↓ 1.0 135,954 520

CTE Scan on p (cost=0.00..2,605.86 rows=130,293 width=380) (actual time=0.005..37.798 rows=135,954 loops=520)

  • Buffers: shared hit=14405, temp read=3964137 written=7642",,,,,,,,,"DBeaver 5.3.2 - Main