explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UR2O

Settings
# exclusive inclusive rows x rows loops node
1. 59,481.908 59,481.908 ↓ 9.6 1,093 1

CTE Scan on base1 (cost=176,458.43..176,460.71 rows=114 width=104) (actual time=59,481.545..59,481.908 rows=1,093 loops=1)

2.          

CTE base1

3. 0.487 59,481.662 ↓ 9.6 1,093 1

Sort (cost=176,458.14..176,458.43 rows=114 width=112) (actual time=59,481.542..59,481.662 rows=1,093 loops=1)

  • Sort Key: sf.belongs_to DESC
  • Sort Method: quicksort Memory: 202kB
4. 1.007 59,481.175 ↓ 9.6 1,093 1

WindowAgg (cost=176,443.42..176,454.25 rows=114 width=112) (actual time=59,480.113..59,481.175 rows=1,093 loops=1)

5. 0.663 59,480.168 ↓ 9.6 1,093 1

Sort (cost=176,443.42..176,443.70 rows=114 width=52) (actual time=59,480.066..59,480.168 rows=1,093 loops=1)

  • Sort Key: (date_part('week'::text, (sf.belongs_to)::timestamp without time zone)), (date_part('isodow'::text, (sf.belongs_to)::timestamp without time zone)), sf.belongs_to
  • Sort Method: quicksort Memory: 202kB
6. 0.397 59,479.505 ↓ 9.6 1,093 1

WindowAgg (cost=176,436.39..176,439.52 rows=114 width=52) (actual time=59,479.047..59,479.505 rows=1,093 loops=1)

7. 0.573 59,479.108 ↓ 9.6 1,093 1

Sort (cost=176,436.39..176,436.67 rows=114 width=44) (actual time=59,478.959..59,479.108 rows=1,093 loops=1)

  • Sort Key: (date_part('isodow'::text, (sf.belongs_to)::timestamp without time zone))
  • Sort Method: quicksort Memory: 134kB
8. 1,052.818 59,478.535 ↓ 9.6 1,093 1

GroupAggregate (cost=176,427.36..176,432.49 rows=114 width=44) (actual time=57,760.753..59,478.535 rows=1,093 loops=1)

  • Group Key: sf.belongs_to
9. 2,891.957 58,425.717 ↓ 46,272.5 5,275,069 1

Sort (cost=176,427.36..176,427.65 rows=114 width=28) (actual time=57,759.131..58,425.717 rows=5,275,069 loops=1)

  • Sort Key: sf.belongs_to DESC
  • Sort Method: external merge Disk: 214648kB
10. 8,043.486 55,533.760 ↓ 46,272.5 5,275,069 1

Nested Loop Left Join (cost=328.58..176,423.47 rows=114 width=28) (actual time=549.897..55,533.760 rows=5,275,069 loops=1)

  • Filter: ((COALESCE(NULLIF(btrim(lf.value), ''::text), '1900-01-01'::text))::date <= (('now'::cstring)::date - '49 days'::interval))
  • Rows Removed by Filter: 1183
11. 1,570.309 36,937.770 ↓ 15,472.9 5,276,252 1

Hash Join (cost=328.02..175,534.29 rows=341 width=36) (actual time=549.849..36,937.770 rows=5,276,252 loops=1)

  • Hash Cond: (sf.location_id = l.id)
12. 684.964 35,364.437 ↓ 48.5 5,276,252 1

Nested Loop (cost=17.43..174,812.37 rows=108,777 width=36) (actual time=546.791..35,364.437 rows=5,276,252 loops=1)

13. 0.224 0.293 ↑ 1.9 20 1

HashAggregate (cost=17.43..17.81 rows=38 width=8) (actual time=0.078..0.293 rows=20 loops=1)

  • Group Key: department_roll_up.sales_department_id
14. 0.003 0.069 ↑ 1.0 38 1

Append (cost=0.28..17.33 rows=38 width=8) (actual time=0.034..0.069 rows=38 loops=1)

15. 0.055 0.055 ↑ 1.0 19 1

Index Scan using department_roll_up_dep_idx on department_roll_up (cost=0.28..8.48 rows=19 width=8) (actual time=0.034..0.055 rows=19 loops=1)

  • Index Cond: (department_id = 16498)
  • Filter: (deleted = 'N'::bpchar)
  • Rows Removed by Filter: 8
16. 0.011 0.011 ↑ 1.0 19 1

Index Scan using department_roll_up_dep_idx on department_roll_up department_roll_up_1 (cost=0.28..8.48 rows=19 width=8) (actual time=0.004..0.011 rows=19 loops=1)

  • Index Cond: (department_id = 16498)
  • Filter: (deleted = 'N'::bpchar)
  • Rows Removed by Filter: 8
17. 585.980 34,679.180 ↓ 60.1 263,813 20

Append (cost=0.00..4,555.99 rows=4,386 width=44) (actual time=30.103..1,733.959 rows=263,813 loops=20)

18. 0.060 0.060 ↓ 0.0 0 20

Seq Scan on sales_paf sf (cost=0.00..0.00 rows=1 width=44) (actual time=0.003..0.003 rows=0 loops=20)

  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)))
19. 0.100 0.100 ↓ 0.0 0 20

Index Scan using sales_paf_200501_dep_id_idx on sales_paf_200501 sf_1 (cost=0.12..0.24 rows=1 width=44) (actual time=0.005..0.005 rows=0 loops=20)

  • Index Cond: (department_id = department_roll_up.sales_department_id)
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)))
20. 0.080 0.080 ↓ 0.0 0 20

Index Scan using sales_paf_200502_dep_id_idx on sales_paf_200502 sf_2 (cost=0.14..0.46 rows=1 width=44) (actual time=0.004..0.004 rows=0 loops=20)

  • Index Cond: (department_id = department_roll_up.sales_department_id)
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)))
21. 0.140 0.140 ↓ 0.0 0 20

Index Scan using sales_paf_200503_dep_id_idx on sales_paf_200503 sf_3 (cost=0.14..0.46 rows=1 width=44) (actual time=0.007..0.007 rows=0 loops=20)

  • Index Cond: (department_id = department_roll_up.sales_department_id)
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)))
22. 0.100 0.100 ↓ 0.0 0 20

Index Scan using sales_paf_200504_dep_id_idx on sales_paf_200504 sf_4 (cost=0.14..0.46 rows=1 width=44) (actual time=0.005..0.005 rows=0 loops=20)

  • Index Cond: (department_id = department_roll_up.sales_department_id)
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)))
23. 0.140 0.140 ↓ 0.0 0 20

Index Scan using sales_paf_200505_dep_id_idx on sales_paf_200505 sf_5 (cost=0.14..0.46 rows=1 width=44) (actual time=0.007..0.007 rows=0 loops=20)

  • Index Cond: (department_id = department_roll_up.sales_department_id)
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)))
24. 0.060 0.060 ↓ 0.0 0 20

Index Scan using sales_paf_200506_dep_id_idx on sales_paf_200506 sf_6 (cost=0.14..0.46 rows=1 width=44) (actual time=0.003..0.003 rows=0 loops=20)

  • Index Cond: (department_id = department_roll_up.sales_department_id)
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)))
25. 0.060 0.060 ↓ 0.0 0 20

Index Scan using sales_paf_200507_dep_id_idx on sales_paf_200507 sf_7 (cost=0.14..0.28 rows=1 width=44) (actual time=0.003..0.003 rows=0 loops=20)

  • Index Cond: (department_id = department_roll_up.sales_department_id)
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)))
26. 0.140 0.140 ↓ 0.0 0 20

Index Scan using sales_paf_200508_dep_id_idx on sales_paf_200508 sf_8 (cost=0.14..0.28 rows=1 width=44) (actual time=0.007..0.007 rows=0 loops=20)

  • Index Cond: (department_id = department_roll_up.sales_department_id)
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)))
27. 0.080 0.080 ↓ 0.0 0 20

Index Scan using sales_paf_200509_dep_id_idx on sales_paf_200509 sf_9 (cost=0.14..0.28 rows=1 width=44) (actual time=0.004..0.004 rows=0 loops=20)

  • Index Cond: (department_id = department_roll_up.sales_department_id)
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)))
28. 0.100 0.100 ↓ 0.0 0 20

Index Scan using sales_paf_200510_dep_id_idx on sales_paf_200510 sf_10 (cost=0.14..0.28 rows=1 width=44) (actual time=0.005..0.005 rows=0 loops=20)

  • Index Cond: (department_id = department_roll_up.sales_department_id)
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)))
29. 0.100 0.100 ↓ 0.0 0 20

Index Scan using sales_paf_200511_dep_id_idx on sales_paf_200511 sf_11 (cost=0.14..0.28 rows=1 width=44) (actual time=0.005..0.005 rows=0 loops=20)

  • Index Cond: (department_id = department_roll_up.sales_department_id)
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)))
30. 0.140 0.140 ↓ 0.0 0 20

Index Scan using sales_paf_200512_dep_id_idx on sales_paf_200512 sf_12 (cost=0.14..0.28 rows=1 width=44) (actual time=0.007..0.007 rows=0 loops=20)

  • Index Cond: (department_id = department_roll_up.sales_department_id)
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)))
31. 0.100 0.100 ↓ 0.0 0 20

Index Scan using sales_paf_200601_dep_id_idx on sales_paf_200601 sf_13 (cost=0.14..0.28 rows=1 width=44) (actual time=0.005..0.005 rows=0 loops=20)

  • Index Cond: (department_id = department_roll_up.sales_department_id)
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)))
32. 0.080 0.080 ↓ 0.0 0 20

Index Scan using sales_paf_200602_dep_id_idx on sales_paf_200602 sf_14 (cost=0.14..0.28 rows=1 width=44) (actual time=0.004..0.004 rows=0 loops=20)

  • Index Cond: (department_id = department_roll_up.sales_department_id)
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)))
33. 0.080 0.080 ↓ 0.0 0 20

Index Scan using sales_paf_200603_dep_id_idx on sales_paf_200603 sf_15 (cost=0.14..0.28 rows=1 width=44) (actual time=0.004..0.004 rows=0 loops=20)

  • Index Cond: (department_id = department_roll_up.sales_department_id)
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)))
34. 0.120 0.120 ↓ 0.0 0 20

Index Scan using sales_paf_200604_dep_id_idx on sales_paf_200604 sf_16 (cost=0.14..0.28 rows=1 width=44) (actual time=0.006..0.006 rows=0 loops=20)

  • Index Cond: (department_id = department_roll_up.sales_department_id)
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)))
35. 0.120 0.120 ↓ 0.0 0 20

Index Scan using sales_paf_200605_dep_id_idx on sales_paf_200605 sf_17 (cost=0.14..0.28 rows=1 width=44) (actual time=0.006..0.006 rows=0 loops=20)

  • Index Cond: (department_id = department_roll_up.sales_department_id)
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)))
36. 0.140 0.140 ↓ 0.0 0 20

Index Scan using sales_paf_200606_dep_id_idx on sales_paf_200606 sf_18 (cost=0.14..0.28 rows=1 width=44) (actual time=0.007..0.007 rows=0 loops=20)

  • Index Cond: (department_id = department_roll_up.sales_department_id)
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)))
37. 0.180 0.180 ↓ 0.0 0 20

Index Scan using sales_paf_200607_dep_id_idx on sales_paf_200607 sf_19 (cost=0.14..0.28 rows=1 width=44) (actual time=0.009..0.009 rows=0 loops=20)

  • Index Cond: (department_id = department_roll_up.sales_department_id)
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)))
38. 0.080 0.080 ↓ 0.0 0 20

Index Scan using sales_paf_200608_dep_id_idx on sales_paf_200608 sf_20 (cost=0.14..0.28 rows=1 width=44) (actual time=0.004..0.004 rows=0 loops=20)

  • Index Cond: (department_id = department_roll_up.sales_department_id)
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)))
39. 0.080 0.080 ↓ 0.0 0 20

Index Scan using sales_paf_200609_dep_id_idx on sales_paf_200609 sf_21 (cost=0.14..0.28 rows=1 width=44) (actual time=0.004..0.004 rows=0 loops=20)

  • Index Cond: (department_id = department_roll_up.sales_department_id)
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)))
40. 0.080 0.080 ↓ 0.0 0 20

Index Scan using sales_paf_200610_dep_id_idx on sales_paf_200610 sf_22 (cost=0.14..0.28 rows=1 width=44) (actual time=0.004..0.004 rows=0 loops=20)

  • Index Cond: (department_id = department_roll_up.sales_department_id)
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)))
41. 0.100 0.100 ↓ 0.0 0 20

Index Scan using sales_paf_200611_dep_id_idx on sales_paf_200611 sf_23 (cost=0.14..0.28 rows=1 width=44) (actual time=0.005..0.005 rows=0 loops=20)

  • Index Cond: (department_id = department_roll_up.sales_department_id)
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)))
42. 0.080 0.080 ↓ 0.0 0 20

Index Scan using sales_paf_200612_dep_id_idx on sales_paf_200612 sf_24 (cost=0.14..0.28 rows=1 width=44) (actual time=0.004..0.004 rows=0 loops=20)

  • Index Cond: (department_id = department_roll_up.sales_department_id)
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)))
43. 0.120 0.120 ↓ 0.0 0 20

Index Scan using sales_paf_200701_dep_id_idx on sales_paf_200701 sf_25 (cost=0.14..0.28 rows=1 width=44) (actual time=0.006..0.006 rows=0 loops=20)

  • Index Cond: (department_id = department_roll_up.sales_department_id)
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)))
44. 0.100 0.100 ↓ 0.0 0 20

Index Scan using sales_paf_200702_dep_id_idx on sales_paf_200702 sf_26 (cost=0.14..0.28 rows=1 width=44) (actual time=0.005..0.005 rows=0 loops=20)

  • Index Cond: (department_id = department_roll_up.sales_department_id)
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)))
45. 0.100 0.100 ↓ 0.0 0 20

Index Scan using sales_paf_200703_dep_id_idx on sales_paf_200703 sf_27 (cost=0.14..0.28 rows=1 width=44) (actual time=0.005..0.005 rows=0 loops=20)

  • Index Cond: (department_id = department_roll_up.sales_department_id)
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)))
46. 0.140 0.140 ↓ 0.0 0 20

Index Scan using sales_paf_200704_dep_id_idx on sales_paf_200704 sf_28 (cost=0.14..0.28 rows=1 width=44) (actual time=0.007..0.007 rows=0 loops=20)

  • Index Cond: (department_id = department_roll_up.sales_department_id)
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)))
47. 0.120 0.120 ↓ 0.0 0 20

Index Scan Backward using sales_paf_200705_belongs_to_idx on sales_paf_200705 sf_29 (cost=0.15..2.12 rows=1 width=44) (actual time=0.006..0.006 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
48. 0.160 0.160 ↓ 0.0 0 20

Index Scan Backward using sales_paf_200706_belongs_to_idx on sales_paf_200706 sf_30 (cost=0.28..1.79 rows=1 width=44) (actual time=0.008..0.008 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
49. 0.140 0.140 ↓ 0.0 0 20

Index Scan Backward using sales_paf_200707_belongs_to_idx on sales_paf_200707 sf_31 (cost=0.28..2.19 rows=1 width=44) (actual time=0.007..0.007 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
50. 0.160 0.160 ↓ 0.0 0 20

Index Scan using sales_paf_200708_salestype_id_idx on sales_paf_200708 sf_32 (cost=0.28..2.31 rows=1 width=44) (actual time=0.008..0.008 rows=0 loops=20)

  • Index Cond: (sales_type_id = 67925)
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (department_roll_up.sales_department_id = department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)))
51. 0.220 0.220 ↓ 0.0 0 20

Index Scan using sales_paf_200709_salestype_id_idx on sales_paf_200709 sf_33 (cost=0.28..2.30 rows=1 width=44) (actual time=0.011..0.011 rows=0 loops=20)

  • Index Cond: (sales_type_id = 67925)
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (department_roll_up.sales_department_id = department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)))
52. 0.120 0.120 ↓ 0.0 0 20

Index Scan Backward using sales_paf_200710_belongs_to_idx on sales_paf_200710 sf_34 (cost=0.28..1.89 rows=1 width=44) (actual time=0.006..0.006 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
53. 0.140 0.140 ↓ 0.0 0 20

Index Scan Backward using sales_paf_200711_belongs_to_idx on sales_paf_200711 sf_35 (cost=0.28..2.09 rows=1 width=44) (actual time=0.007..0.007 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
54. 0.140 0.140 ↓ 0.0 0 20

Index Scan Backward using sales_paf_200712_belongs_to_idx on sales_paf_200712 sf_36 (cost=0.28..1.78 rows=1 width=44) (actual time=0.007..0.007 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
55. 0.120 0.120 ↓ 0.0 0 20

Index Scan Backward using sales_paf_200801_belongs_to_idx on sales_paf_200801 sf_37 (cost=0.29..1.96 rows=1 width=44) (actual time=0.006..0.006 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
56. 0.160 0.160 ↓ 0.0 0 20

Index Scan Backward using sales_paf_200802_belongs_to_idx on sales_paf_200802 sf_38 (cost=0.29..2.01 rows=1 width=44) (actual time=0.008..0.008 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
57. 0.100 0.100 ↓ 0.0 0 20

Index Scan Backward using sales_paf_200803_belongs_to_idx on sales_paf_200803 sf_39 (cost=0.29..2.32 rows=1 width=44) (actual time=0.005..0.005 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
58. 0.180 0.180 ↓ 0.0 0 20

Index Scan Backward using sales_paf_200804_belongs_to_idx on sales_paf_200804 sf_40 (cost=0.29..2.03 rows=1 width=44) (actual time=0.009..0.009 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
59. 0.120 0.120 ↓ 0.0 0 20

Index Scan Backward using sales_paf_200805_belongs_to_idx on sales_paf_200805 sf_41 (cost=0.29..2.17 rows=1 width=44) (actual time=0.006..0.006 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
60. 0.100 0.100 ↓ 0.0 0 20

Index Scan Backward using sales_paf_200806_belongs_to_idx on sales_paf_200806 sf_42 (cost=0.29..2.06 rows=1 width=44) (actual time=0.005..0.005 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
61. 0.120 0.120 ↓ 0.0 0 20

Index Scan Backward using sales_paf_200807_belongs_to_idx on sales_paf_200807 sf_43 (cost=0.29..2.32 rows=1 width=44) (actual time=0.006..0.006 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
62. 0.140 0.140 ↓ 0.0 0 20

Index Scan Backward using sales_paf_200808_belongs_to_idx on sales_paf_200808 sf_44 (cost=0.29..2.32 rows=1 width=44) (actual time=0.007..0.007 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
63. 0.160 0.160 ↓ 0.0 0 20

Index Scan using sales_paf_200809_salestype_id_idx on sales_paf_200809 sf_45 (cost=0.28..1.93 rows=1 width=44) (actual time=0.008..0.008 rows=0 loops=20)

  • Index Cond: (sales_type_id = 67925)
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (department_roll_up.sales_department_id = department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)))
64. 0.120 0.120 ↓ 0.0 0 20

Index Scan Backward using sales_paf_200810_belongs_to_idx on sales_paf_200810 sf_46 (cost=0.29..2.32 rows=1 width=44) (actual time=0.006..0.006 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
65. 0.140 0.140 ↓ 0.0 0 20

Index Scan Backward using sales_paf_200811_belongs_to_idx on sales_paf_200811 sf_47 (cost=0.29..2.13 rows=1 width=44) (actual time=0.007..0.007 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
66. 0.120 0.120 ↓ 0.0 0 20

Index Scan Backward using sales_paf_200812_belongs_to_idx on sales_paf_200812 sf_48 (cost=0.29..2.08 rows=1 width=44) (actual time=0.006..0.006 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
67. 0.140 0.140 ↓ 0.0 0 20

Index Scan Backward using sales_paf_200901_belongs_to_idx on sales_paf_200901 sf_49 (cost=0.29..2.24 rows=1 width=44) (actual time=0.007..0.007 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
68. 0.140 0.140 ↓ 0.0 0 20

Index Scan Backward using sales_paf_200902_belongs_to_idx on sales_paf_200902 sf_50 (cost=0.29..2.32 rows=1 width=44) (actual time=0.007..0.007 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
69. 0.120 0.120 ↓ 0.0 0 20

Index Scan Backward using sales_paf_200903_belongs_to_idx on sales_paf_200903 sf_51 (cost=0.29..2.21 rows=1 width=44) (actual time=0.006..0.006 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
70. 0.120 0.120 ↓ 0.0 0 20

Index Scan Backward using sales_paf_200904_belongs_to_idx on sales_paf_200904 sf_52 (cost=0.29..2.21 rows=1 width=44) (actual time=0.006..0.006 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
71. 0.120 0.120 ↓ 0.0 0 20

Index Scan Backward using sales_paf_200905_belongs_to_idx on sales_paf_200905 sf_53 (cost=0.29..2.16 rows=1 width=44) (actual time=0.006..0.006 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
72. 0.180 0.180 ↓ 0.0 0 20

Index Scan Backward using sales_paf_200906_belongs_to_idx on sales_paf_200906 sf_54 (cost=0.29..2.08 rows=1 width=44) (actual time=0.009..0.009 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
73. 0.140 0.140 ↓ 0.0 0 20

Index Scan Backward using sales_paf_200907_belongs_to_idx on sales_paf_200907 sf_55 (cost=0.29..2.32 rows=1 width=44) (actual time=0.007..0.007 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
74. 0.160 0.160 ↓ 0.0 0 20

Index Scan Backward using sales_paf_200908_belongs_to_idx on sales_paf_200908 sf_56 (cost=0.29..2.32 rows=1 width=44) (actual time=0.008..0.008 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
75. 0.100 0.100 ↓ 0.0 0 20

Index Scan Backward using sales_paf_200909_belongs_to_idx on sales_paf_200909 sf_57 (cost=0.29..2.15 rows=1 width=44) (actual time=0.005..0.005 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
76. 0.100 0.100 ↓ 0.0 0 20

Index Scan Backward using sales_paf_200910_belongs_to_idx on sales_paf_200910 sf_58 (cost=0.29..2.32 rows=1 width=44) (actual time=0.005..0.005 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
77. 0.140 0.140 ↓ 0.0 0 20

Index Scan Backward using sales_paf_200911_belongs_to_idx on sales_paf_200911 sf_59 (cost=0.29..2.32 rows=1 width=44) (actual time=0.007..0.007 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
78. 0.180 0.180 ↓ 0.0 0 20

Index Scan Backward using sales_paf_200912_belongs_to_idx on sales_paf_200912 sf_60 (cost=0.29..2.19 rows=1 width=44) (actual time=0.009..0.009 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
79. 0.120 0.120 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201001_belongs_to_idx on sales_paf_201001 sf_61 (cost=0.29..2.32 rows=1 width=44) (actual time=0.006..0.006 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
80. 0.120 0.120 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201002_belongs_to_idx on sales_paf_201002 sf_62 (cost=0.29..2.18 rows=1 width=44) (actual time=0.006..0.006 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
81. 0.140 0.140 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201003_belongs_to_idx on sales_paf_201003 sf_63 (cost=0.29..2.12 rows=1 width=44) (actual time=0.007..0.007 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
82. 0.100 0.100 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201004_belongs_to_idx on sales_paf_201004 sf_64 (cost=0.29..2.10 rows=1 width=44) (actual time=0.005..0.005 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
83. 0.140 0.140 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201005_belongs_to_idx on sales_paf_201005 sf_65 (cost=0.29..2.32 rows=1 width=44) (actual time=0.007..0.007 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
84. 0.140 0.140 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201006_belongs_to_idx on sales_paf_201006 sf_66 (cost=0.29..2.09 rows=1 width=44) (actual time=0.007..0.007 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
85. 0.140 0.140 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201007_belongs_to_idx on sales_paf_201007 sf_67 (cost=0.29..2.03 rows=1 width=44) (actual time=0.007..0.007 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
86. 0.140 0.140 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201008_belongs_to_idx on sales_paf_201008 sf_68 (cost=0.29..2.01 rows=1 width=44) (actual time=0.007..0.007 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
87. 0.100 0.100 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201009_belongs_to_idx on sales_paf_201009 sf_69 (cost=0.29..2.04 rows=1 width=44) (actual time=0.005..0.005 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
88. 0.180 0.180 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201010_belongs_to_idx on sales_paf_201010 sf_70 (cost=0.29..2.32 rows=1 width=44) (actual time=0.009..0.009 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
89. 0.100 0.100 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201011_belongs_to_idx on sales_paf_201011 sf_71 (cost=0.29..2.02 rows=1 width=44) (actual time=0.005..0.005 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
90. 0.140 0.140 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201012_belongs_to_idx on sales_paf_201012 sf_72 (cost=0.30..2.33 rows=1 width=44) (actual time=0.007..0.007 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
91. 0.160 0.160 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201101_belongs_to_idx on sales_paf_201101 sf_73 (cost=0.30..2.26 rows=1 width=44) (actual time=0.008..0.008 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
92. 0.140 0.140 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201102_belongs_to_idx on sales_paf_201102 sf_74 (cost=0.30..2.33 rows=1 width=44) (actual time=0.007..0.007 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
93. 0.200 0.200 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201103_belongs_to_idx on sales_paf_201103 sf_75 (cost=0.30..2.12 rows=1 width=44) (actual time=0.010..0.010 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
94. 0.120 0.120 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201104_belongs_to_idx on sales_paf_201104 sf_76 (cost=0.30..2.01 rows=1 width=44) (actual time=0.006..0.006 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
95. 0.120 0.120 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201105_belongs_to_idx on sales_paf_201105 sf_77 (cost=0.30..2.33 rows=1 width=44) (actual time=0.006..0.006 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
96. 0.100 0.100 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201106_belongs_to_idx on sales_paf_201106 sf_78 (cost=0.30..2.01 rows=1 width=44) (actual time=0.005..0.005 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
97. 0.100 0.100 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201107_belongs_to_idx on sales_paf_201107 sf_79 (cost=0.30..2.01 rows=1 width=44) (actual time=0.005..0.005 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
98. 0.180 0.180 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201108_belongs_to_idx on sales_paf_201108 sf_80 (cost=0.30..2.33 rows=1 width=44) (actual time=0.009..0.009 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
99. 0.180 0.180 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201109_belongs_to_idx on sales_paf_201109 sf_81 (cost=0.30..2.00 rows=1 width=44) (actual time=0.009..0.009 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
100. 0.140 0.140 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201110_belongs_to_idx on sales_paf_201110 sf_82 (cost=0.30..1.97 rows=1 width=44) (actual time=0.007..0.007 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
101. 0.100 0.100 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201111_belongs_to_idx on sales_paf_201111 sf_83 (cost=0.30..1.87 rows=1 width=44) (actual time=0.005..0.005 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
102. 0.120 0.120 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201112_belongs_to_idx on sales_paf_201112 sf_84 (cost=0.30..1.86 rows=1 width=44) (actual time=0.006..0.006 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
103. 0.160 0.160 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201201_belongs_to_idx on sales_paf_201201 sf_85 (cost=0.30..2.06 rows=1 width=44) (actual time=0.008..0.008 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
104. 0.140 0.140 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201202_belongs_to_idx on sales_paf_201202 sf_86 (cost=0.30..2.33 rows=1 width=44) (actual time=0.007..0.007 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
105. 0.160 0.160 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201203_belongs_to_idx on sales_paf_201203 sf_87 (cost=0.30..1.91 rows=1 width=44) (actual time=0.008..0.008 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
106. 0.140 0.140 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201204_belongs_to_idx on sales_paf_201204 sf_88 (cost=0.30..1.91 rows=1 width=44) (actual time=0.007..0.007 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
107. 0.160 0.160 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201205_belongs_to_idx on sales_paf_201205 sf_89 (cost=0.30..1.97 rows=1 width=44) (actual time=0.008..0.008 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
108. 0.140 0.140 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201206_belongs_to_idx on sales_paf_201206 sf_90 (cost=0.30..2.15 rows=1 width=44) (actual time=0.007..0.007 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
109. 0.100 0.100 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201207_belongs_to_idx on sales_paf_201207 sf_91 (cost=0.30..2.33 rows=1 width=44) (actual time=0.005..0.005 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
110. 0.160 0.160 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201208_belongs_to_idx on sales_paf_201208 sf_92 (cost=0.30..2.13 rows=1 width=44) (actual time=0.008..0.008 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
111. 0.120 0.120 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201209_belongs_to_idx on sales_paf_201209 sf_93 (cost=0.30..2.17 rows=1 width=44) (actual time=0.006..0.006 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
112. 0.120 0.120 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201210_belongs_to_idx on sales_paf_201210 sf_94 (cost=0.30..2.16 rows=1 width=44) (actual time=0.006..0.006 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
113. 0.180 0.180 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201211_belongs_to_idx on sales_paf_201211 sf_95 (cost=0.30..2.17 rows=1 width=44) (actual time=0.009..0.009 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
114. 0.160 0.160 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201212_belongs_to_idx on sales_paf_201212 sf_96 (cost=0.30..2.18 rows=1 width=44) (actual time=0.008..0.008 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
115. 0.120 0.120 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201301_belongs_to_idx on sales_paf_201301 sf_97 (cost=0.30..2.33 rows=1 width=44) (actual time=0.006..0.006 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
116. 0.160 0.160 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201302_belongs_to_idx on sales_paf_201302 sf_98 (cost=0.30..2.29 rows=1 width=44) (actual time=0.008..0.008 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
117. 0.160 0.160 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201303_belongs_to_idx on sales_paf_201303 sf_99 (cost=0.30..2.33 rows=1 width=44) (actual time=0.008..0.008 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
118. 0.140 0.140 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201304_belongs_to_idx on sales_paf_201304 sf_100 (cost=0.30..2.32 rows=1 width=44) (actual time=0.007..0.007 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
119. 0.140 0.140 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201305_belongs_to_idx on sales_paf_201305 sf_101 (cost=0.30..2.32 rows=1 width=44) (actual time=0.007..0.007 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
120. 0.120 0.120 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201306_belongs_to_idx on sales_paf_201306 sf_102 (cost=0.30..2.33 rows=1 width=44) (actual time=0.006..0.006 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
121. 0.140 0.140 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201307_belongs_to_idx on sales_paf_201307 sf_103 (cost=0.42..2.45 rows=1 width=44) (actual time=0.007..0.007 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
122. 0.140 0.140 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201308_belongs_to_idx on sales_paf_201308 sf_104 (cost=0.42..2.45 rows=1 width=44) (actual time=0.007..0.007 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
123. 0.180 0.180 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201309_belongs_to_idx on sales_paf_201309 sf_105 (cost=0.42..2.45 rows=1 width=44) (actual time=0.009..0.009 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
124. 0.200 0.200 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201310_belongs_to_idx on sales_paf_201310 sf_106 (cost=0.42..2.45 rows=1 width=44) (actual time=0.010..0.010 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
125. 0.120 0.120 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201311_belongs_to_idx on sales_paf_201311 sf_107 (cost=0.42..2.45 rows=1 width=44) (actual time=0.006..0.006 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
126. 0.180 0.180 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201312_belongs_to_idx on sales_paf_201312 sf_108 (cost=0.43..2.45 rows=1 width=44) (actual time=0.009..0.009 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
127. 0.140 0.140 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201401_belongs_to_idx on sales_paf_201401 sf_109 (cost=0.43..2.46 rows=1 width=44) (actual time=0.007..0.007 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
128. 0.140 0.140 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201402_belongs_to_idx on sales_paf_201402 sf_110 (cost=0.43..2.45 rows=1 width=44) (actual time=0.007..0.007 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
129. 0.180 0.180 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201403_belongs_to_idx on sales_paf_201403 sf_111 (cost=0.43..2.46 rows=1 width=44) (actual time=0.009..0.009 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
130. 0.220 0.220 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201404_belongs_to_idx on sales_paf_201404 sf_112 (cost=0.43..2.45 rows=1 width=44) (actual time=0.011..0.011 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
131. 0.180 0.180 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201405_belongs_to_idx on sales_paf_201405 sf_113 (cost=0.43..2.45 rows=1 width=44) (actual time=0.009..0.009 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
132. 0.180 0.180 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201406_belongs_to_idx on sales_paf_201406 sf_114 (cost=0.43..2.46 rows=1 width=44) (actual time=0.009..0.009 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
133. 0.140 0.140 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201407_belongs_to_idx on sales_paf_201407 sf_115 (cost=0.43..2.45 rows=1 width=44) (actual time=0.007..0.007 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
134. 0.140 0.140 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201408_belongs_to_idx on sales_paf_201408 sf_116 (cost=0.43..2.45 rows=1 width=44) (actual time=0.007..0.007 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
135. 0.180 0.180 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201409_belongs_to_idx on sales_paf_201409 sf_117 (cost=0.43..2.45 rows=1 width=44) (actual time=0.009..0.009 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
136. 0.240 0.240 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201410_belongs_to_idx on sales_paf_201410 sf_118 (cost=0.43..2.44 rows=1 width=44) (actual time=0.012..0.012 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
137. 0.160 0.160 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201411_belongs_to_idx on sales_paf_201411 sf_119 (cost=0.43..2.46 rows=1 width=44) (actual time=0.008..0.008 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
138. 0.120 0.120 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201412_belongs_to_idx on sales_paf_201412 sf_120 (cost=0.43..2.46 rows=1 width=44) (actual time=0.006..0.006 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
139. 0.160 0.160 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201501_belongs_to_idx on sales_paf_201501 sf_121 (cost=0.43..2.46 rows=1 width=44) (actual time=0.008..0.008 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
140. 0.140 0.140 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201502_belongs_to_idx on sales_paf_201502 sf_122 (cost=0.43..2.45 rows=1 width=44) (actual time=0.007..0.007 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
141. 0.180 0.180 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201503_belongs_to_idx on sales_paf_201503 sf_123 (cost=0.43..2.44 rows=1 width=44) (actual time=0.009..0.009 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
142. 0.160 0.160 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201504_belongs_to_idx on sales_paf_201504 sf_124 (cost=0.43..2.46 rows=1 width=44) (actual time=0.008..0.008 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
143. 0.180 0.180 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201505_belongs_to_idx on sales_paf_201505 sf_125 (cost=0.43..2.46 rows=1 width=44) (actual time=0.009..0.009 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
144. 0.160 0.160 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201506_belongs_to_idx on sales_paf_201506 sf_126 (cost=0.43..2.46 rows=1 width=44) (actual time=0.008..0.008 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
145. 0.140 0.140 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201507_belongs_to_idx on sales_paf_201507 sf_127 (cost=0.43..2.46 rows=1 width=44) (actual time=0.007..0.007 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
146. 0.160 0.160 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201508_belongs_to_idx on sales_paf_201508 sf_128 (cost=0.43..2.45 rows=1 width=44) (actual time=0.008..0.008 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
147. 0.140 0.140 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201509_belongs_to_idx on sales_paf_201509 sf_129 (cost=0.43..2.46 rows=1 width=44) (actual time=0.007..0.007 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
148. 0.160 0.160 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201510_belongs_to_idx on sales_paf_201510 sf_130 (cost=0.43..2.46 rows=1 width=44) (actual time=0.008..0.008 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
149. 0.200 0.200 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201511_belongs_to_idx on sales_paf_201511 sf_131 (cost=0.43..2.44 rows=1 width=44) (actual time=0.010..0.010 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
150. 0.140 0.140 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201512_belongs_to_idx on sales_paf_201512 sf_132 (cost=0.43..2.46 rows=1 width=44) (actual time=0.007..0.007 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
151. 0.200 0.200 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201601_belongs_to_idx on sales_paf_201601 sf_133 (cost=0.43..2.42 rows=1 width=44) (actual time=0.010..0.010 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
152. 0.180 0.180 ↓ 0.0 0 20

Index Scan Backward using sales_paf_201602_belongs_to_idx on sales_paf_201602 sf_134 (cost=0.43..2.46 rows=1 width=44) (actual time=0.009..0.009 rows=0 loops=20)

  • Index Cond: (belongs_to >= (('now'::cstring)::date - '3 years'::interval))
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (department_roll_up.sales_department_id = department_id))
153. 518.120 518.120 ↓ 99.6 4,082 20

Index Scan using sales_paf_201603_comb_idx on sales_paf_201603 sf_135 (cost=0.43..42.98 rows=41 width=44) (actual time=0.203..25.906 rows=4,082 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 50
154. 663.140 663.140 ↓ 96.5 5,887 20

Index Scan using sales_paf_201604_comb_idx on sales_paf_201604 sf_136 (cost=0.43..64.14 rows=61 width=44) (actual time=0.699..33.157 rows=5,887 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 152
155. 802.900 802.900 ↓ 86.4 6,221 20

Index Scan using sales_paf_201605_test_idx on sales_paf_201605 sf_137 (cost=0.43..72.96 rows=72 width=44) (actual time=1.723..40.145 rows=6,221 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 650
156. 849.640 849.640 ↓ 87.2 6,106 20

Index Scan using sales_paf_201606_comb_idx on sales_paf_201606 sf_138 (cost=0.43..72.90 rows=70 width=44) (actual time=2.006..42.482 rows=6,106 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 1004
157. 883.760 883.760 ↓ 77.8 6,457 20

Index Scan using sales_paf_201607_comb_idx on sales_paf_201607 sf_139 (cost=0.43..85.70 rows=83 width=44) (actual time=2.202..44.188 rows=6,457 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 1169
158. 831.660 831.660 ↓ 81.6 6,531 20

Index Scan using sales_paf_201608_comb_idx on sales_paf_201608 sf_140 (cost=0.43..82.82 rows=80 width=44) (actual time=1.607..41.583 rows=6,531 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 749
159. 665.100 665.100 ↓ 85.8 6,435 20

Index Scan using sales_paf_201609_comb_idx on sales_paf_201609 sf_141 (cost=0.43..77.59 rows=75 width=44) (actual time=1.338..33.255 rows=6,435 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 587
160. 726.800 726.800 ↓ 81.9 6,714 20

Index Scan using sales_paf_201610_comb_idx on sales_paf_201610 sf_142 (cost=0.43..84.26 rows=82 width=44) (actual time=1.914..36.340 rows=6,714 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 639
161. 690.340 690.340 ↓ 83.4 6,589 20

Index Scan using sales_paf_201611_comb_idx on sales_paf_201611 sf_143 (cost=0.43..81.09 rows=79 width=44) (actual time=1.571..34.517 rows=6,589 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 639
162. 690.260 690.260 ↓ 77.7 6,608 20

Index Scan using sales_paf_201612_comb_idx on sales_paf_201612 sf_144 (cost=0.43..88.60 rows=85 width=44) (actual time=1.728..34.513 rows=6,608 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 886
163. 682.940 682.940 ↓ 77.8 6,849 20

Index Scan using sales_paf_201701_comb_idx on sales_paf_201701 sf_145 (cost=0.43..89.80 rows=88 width=44) (actual time=1.536..34.147 rows=6,849 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 706
164. 626.720 626.720 ↓ 78.0 6,239 20

Index Scan using sales_paf_201702_comb_idx on sales_paf_201702 sf_146 (cost=0.43..81.45 rows=80 width=44) (actual time=1.340..31.336 rows=6,239 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 586
165. 706.360 706.360 ↓ 79.7 7,013 20

Index Scan using sales_paf_201703_comb_idx on sales_paf_201703 sf_147 (cost=0.43..87.37 rows=88 width=44) (actual time=1.247..35.318 rows=7,013 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 613
166. 712.640 712.640 ↓ 79.4 6,907 20

Index Scan using sales_paf_201704_comb_idx on sales_paf_201704 sf_148 (cost=0.43..87.82 rows=87 width=44) (actual time=1.388..35.632 rows=6,907 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 642
167. 780.800 780.800 ↓ 81.6 7,261 20

Index Scan using sales_paf_201705_comb_idx on sales_paf_201705 sf_149 (cost=0.43..90.90 rows=89 width=44) (actual time=1.521..39.040 rows=7,261 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 704
168. 770.520 770.520 ↓ 73.2 7,105 20

Index Scan using sales_paf_201706_comb_idx on sales_paf_201706 sf_150 (cost=0.43..98.53 rows=97 width=44) (actual time=1.507..38.526 rows=7,105 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 735
169. 702.540 702.540 ↓ 69.1 7,458 20

Index Scan using sales_paf_201707_comb_idx on sales_paf_201707 sf_151 (cost=0.43..109.85 rows=108 width=44) (actual time=1.202..35.127 rows=7,458 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 745
170. 762.040 762.040 ↓ 67.2 7,521 20

Index Scan using sales_paf_201708_comb_idx on sales_paf_201708 sf_152 (cost=0.43..115.09 rows=112 width=44) (actual time=1.311..38.102 rows=7,521 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 726
171. 1,370.440 1,370.440 ↓ 68.4 7,317 20

Index Scan using sales_paf_201709_comb_idx on sales_paf_201709 sf_153 (cost=0.43..110.40 rows=107 width=44) (actual time=1.416..68.522 rows=7,317 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 685
172. 825.360 825.360 ↓ 68.4 7,659 20

Index Scan using sales_paf_201710_comb_idx on sales_paf_201710 sf_154 (cost=0.43..114.93 rows=112 width=44) (actual time=0.808..41.268 rows=7,659 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 768
173. 802.220 802.220 ↓ 66.8 7,479 20

Index Scan using sales_paf_201711_comb_idx on sales_paf_201711 sf_155 (cost=0.43..114.58 rows=112 width=44) (actual time=1.671..40.111 rows=7,479 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 807
174. 844.920 844.920 ↓ 62.4 7,489 20

Index Scan using sales_paf_201712_comb_idx on sales_paf_201712 sf_156 (cost=0.43..123.01 rows=120 width=44) (actual time=1.727..42.246 rows=7,489 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 1100
175. 822.600 822.600 ↓ 68.2 7,780 20

Index Scan using sales_paf_201801_comb_idx on sales_paf_201801 sf_157 (cost=0.43..116.98 rows=114 width=44) (actual time=1.827..41.130 rows=7,780 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 826
176. 791.120 791.120 ↓ 66.3 7,099 20

Index Scan using sales_paf_201802_comb_idx on sales_paf_201802 sf_158 (cost=0.43..104.92 rows=107 width=44) (actual time=1.508..39.556 rows=7,099 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 715
177. 844.560 844.560 ↓ 66.2 7,950 20

Index Scan using sales_paf_201803_comb_idx on sales_paf_201803 sf_159 (cost=0.43..121.32 rows=120 width=44) (actual time=1.625..42.228 rows=7,950 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 795
178. 818.480 818.480 ↓ 67.0 7,775 20

Index Scan using sales_paf_201804_comb_idx on sales_paf_201804 sf_160 (cost=0.43..117.33 rows=116 width=44) (actual time=1.400..40.924 rows=7,775 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 731
179. 896.740 896.740 ↓ 61.0 8,111 20

Index Scan using sales_paf_201805_comb_idx on sales_paf_201805 sf_161 (cost=0.43..134.00 rows=133 width=44) (actual time=1.552..44.837 rows=8,111 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 725
180. 895.240 895.240 ↓ 64.1 7,879 20

Index Scan using sales_paf_201806_comb_idx on sales_paf_201806 sf_162 (cost=0.43..124.79 rows=123 width=44) (actual time=1.535..44.762 rows=7,879 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 676
181. 2,755.000 2,755.000 ↓ 68.2 8,189 20

Index Scan using sales_paf_201807_comb_idx on sales_paf_201807 sf_163 (cost=0.43..121.72 rows=120 width=44) (actual time=1.568..137.750 rows=8,189 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 743
182. 887.860 887.860 ↓ 71.5 8,366 20

Index Scan using sales_paf_201808_comb_idx on sales_paf_201808 sf_164 (cost=0.43..118.42 rows=117 width=44) (actual time=1.435..44.393 rows=8,366 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 727
183. 1,063.280 1,063.280 ↓ 67.7 8,196 20

Index Scan using sales_paf_201809_comb_idx on sales_paf_201809 sf_165 (cost=0.43..122.59 rows=121 width=44) (actual time=1.786..53.164 rows=8,196 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 811
184. 896.920 896.920 ↓ 65.3 8,548 20

Index Scan using sales_paf_201810_comb_idx on sales_paf_201810 sf_166 (cost=0.43..131.79 rows=131 width=44) (actual time=1.854..44.846 rows=8,548 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 919
185. 916.280 916.280 ↓ 60.9 8,282 20

Index Scan using sales_paf_201811_comb_idx on sales_paf_201811 sf_167 (cost=0.43..136.79 rows=136 width=44) (actual time=2.101..45.814 rows=8,282 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 976
186. 1,102.440 1,102.440 ↓ 59.8 8,252 20

Index Scan using sales_paf_201812_comb_idx on sales_paf_201812 sf_168 (cost=0.43..142.71 rows=138 width=44) (actual time=2.174..55.122 rows=8,252 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 1278
187. 1,454.640 1,454.640 ↓ 59.6 8,580 20

Index Scan using sales_paf_201901_comb_idx on sales_paf_201901 sf_169 (cost=0.56..162.59 rows=144 width=44) (actual time=2.901..72.732 rows=8,580 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 1063
188. 1,392.140 1,392.140 ↓ 57.5 7,814 20

Index Scan using sales_paf_201902_comb_idx on sales_paf_201902 sf_170 (cost=0.56..157.14 rows=136 width=44) (actual time=2.765..69.607 rows=7,814 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 989
189. 1,477.360 1,477.360 ↓ 7.0 3,063 20

Index Scan using sales_paf_201903_comb_idx on sales_paf_201903 sf_171 (cost=0.56..441.97 rows=439 width=44) (actual time=1.672..73.868 rows=3,063 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 6269
190. 143.140 143.140 ↓ 0.0 0 20

Index Scan using sales_paf_201904_comb_idx on sales_paf_201904 sf_172 (cost=0.43..58.56 rows=58 width=44) (actual time=7.157..7.157 rows=0 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 3229
191. 1.320 1.320 ↓ 0.0 0 20

Index Scan using sales_paf_201905_comb_idx on sales_paf_201905 sf_173 (cost=0.29..3.70 rows=16 width=44) (actual time=0.066..0.066 rows=0 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 31
192. 0.860 0.860 ↓ 0.0 0 20

Index Scan using sales_paf_201906_comb_idx on sales_paf_201906 sf_174 (cost=0.28..2.68 rows=5 width=44) (actual time=0.043..0.043 rows=0 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 16
193. 1.240 1.240 ↓ 0.0 0 20

Index Scan using sales_paf_201907_comb_idx on sales_paf_201907 sf_175 (cost=0.29..3.67 rows=17 width=44) (actual time=0.062..0.062 rows=0 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 31
194. 0.700 0.700 ↓ 0.0 0 20

Index Scan using sales_paf_201908_comb_idx on sales_paf_201908 sf_176 (cost=0.28..2.02 rows=5 width=44) (actual time=0.035..0.035 rows=0 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 11
195. 0.260 0.260 ↓ 0.0 0 20

Index Scan using sales_paf_201909_dep_id_idx on sales_paf_201909 sf_177 (cost=0.14..0.69 rows=1 width=44) (actual time=0.013..0.013 rows=0 loops=20)

  • Index Cond: (department_id = department_roll_up.sales_department_id)
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)))
  • Rows Removed by Filter: 1
196. 0.460 0.460 ↓ 0.0 0 20

Index Scan using sales_paf_201910_dep_id_idx on sales_paf_201910 sf_178 (cost=0.14..0.80 rows=4 width=44) (actual time=0.023..0.023 rows=0 loops=20)

  • Index Cond: (department_id = department_roll_up.sales_department_id)
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)))
  • Rows Removed by Filter: 6
197. 0.360 0.360 ↓ 0.0 0 20

Index Scan using sales_paf_201911_dep_id_idx on sales_paf_201911 sf_179 (cost=0.14..1.01 rows=5 width=44) (actual time=0.018..0.018 rows=0 loops=20)

  • Index Cond: (department_id = department_roll_up.sales_department_id)
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)))
  • Rows Removed by Filter: 6
198. 0.360 0.360 ↓ 0.0 0 20

Index Scan using sales_paf_201912_comb_idx on sales_paf_201912 sf_180 (cost=0.15..0.49 rows=2 width=44) (actual time=0.018..0.018 rows=0 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 3
199. 0.460 0.460 ↓ 0.0 0 20

Index Scan using sales_paf_202001_comb_idx on sales_paf_202001 sf_181 (cost=0.15..0.66 rows=4 width=44) (actual time=0.023..0.023 rows=0 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
  • Rows Removed by Filter: 5
200. 0.160 0.160 ↓ 0.0 0 20

Index Scan using sales_paf_202002_comb_idx on sales_paf_202002 sf_182 (cost=0.14..0.26 rows=1 width=44) (actual time=0.008..0.008 rows=0 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
201. 0.160 0.160 ↓ 0.0 0 20

Index Scan using sales_paf_202003_comb_idx on sales_paf_202003 sf_183 (cost=0.14..0.26 rows=1 width=44) (actual time=0.008..0.008 rows=0 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
202. 0.200 0.200 ↓ 0.0 0 20

Index Scan using sales_paf_202004_comb_idx on sales_paf_202004 sf_184 (cost=0.14..0.26 rows=1 width=44) (actual time=0.010..0.010 rows=0 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
203. 0.200 0.200 ↓ 0.0 0 20

Index Scan using sales_paf_202005_comb_idx on sales_paf_202005 sf_185 (cost=0.14..0.26 rows=1 width=44) (actual time=0.010..0.010 rows=0 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
204. 0.120 0.120 ↓ 0.0 0 20

Index Scan using sales_paf_202006_comb_idx on sales_paf_202006 sf_186 (cost=0.14..0.26 rows=1 width=44) (actual time=0.006..0.006 rows=0 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
205. 0.160 0.160 ↓ 0.0 0 20

Index Scan using sales_paf_202007_comb_idx on sales_paf_202007 sf_187 (cost=0.14..0.26 rows=1 width=44) (actual time=0.008..0.008 rows=0 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
206. 0.160 0.160 ↓ 0.0 0 20

Index Scan using sales_paf_202008_comb_idx on sales_paf_202008 sf_188 (cost=0.14..0.26 rows=1 width=44) (actual time=0.008..0.008 rows=0 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
207. 0.140 0.140 ↓ 0.0 0 20

Index Scan using sales_paf_202009_comb_idx on sales_paf_202009 sf_189 (cost=0.14..0.23 rows=1 width=44) (actual time=0.007..0.007 rows=0 loops=20)

  • Index Cond: ((sales_type_id = 67925) AND (department_id = department_roll_up.sales_department_id) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)) AND (deleted = 'N'::bpchar))
  • Filter: (totala <> '0'::double precision)
208. 0.160 0.160 ↓ 0.0 0 20

Index Scan using sales_paf_202010_dep_id_idx on sales_paf_202010 sf_190 (cost=0.14..0.46 rows=1 width=44) (actual time=0.008..0.008 rows=0 loops=20)

  • Index Cond: (department_id = department_roll_up.sales_department_id)
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)))
209. 0.100 0.100 ↓ 0.0 0 20

Index Scan using sales_paf_202011_dep_id_idx on sales_paf_202011 sf_191 (cost=0.14..0.46 rows=1 width=44) (actual time=0.005..0.005 rows=0 loops=20)

  • Index Cond: (department_id = department_roll_up.sales_department_id)
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)))
210. 0.100 0.100 ↓ 0.0 0 20

Index Scan using sales_paf_202012_dep_id_idx on sales_paf_202012 sf_192 (cost=0.14..0.46 rows=1 width=44) (actual time=0.005..0.005 rows=0 loops=20)

  • Index Cond: (department_id = department_roll_up.sales_department_id)
  • Filter: ((totala <> '0'::double precision) AND (deleted = 'N'::bpchar) AND (sales_type_id = 67925) AND (belongs_to >= (('now'::cstring)::date - '3 years'::interval)))
211. 0.061 3.024 ↑ 1.2 333 1

Hash (cost=305.45..305.45 rows=412 width=8) (actual time=3.024..3.024 rows=333 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 22kB
212. 2.963 2.963 ↑ 1.2 333 1

Index Scan using i_loc_corp_id on location l (cost=0.29..305.45 rows=412 width=8) (actual time=0.031..2.963 rows=333 loops=1)

  • Index Cond: (corporation_id = 70683)
213. 10,552.504 10,552.504 ↓ 0.0 0 5,276,252

Index Scan using idx_loc_flag_del on location_flag lf (cost=0.56..2.58 rows=1 width=33) (actual time=0.002..0.002 rows=0 loops=5,276,252)

  • Index Cond: ((l.id = location_id) AND (flag_id = 336))