explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TMJF

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 36.854 ↑ 2.9 7 1

Group (cost=345.06..345.31 rows=20 width=32) (actual time=36.847..36.854 rows=7 loops=1)

  • Group Key: ct.contract_id, (sum(ct.minutes_online)), (count(*)), (count(DISTINCT ct.task_nid))
2. 0.015 36.848 ↑ 2.9 7 1

Sort (cost=345.06..345.11 rows=20 width=32) (actual time=36.845..36.848 rows=7 loops=1)

  • Sort Key: ct.contract_id, (sum(ct.minutes_online)), (count(*)), (count(DISTINCT ct.task_nid))
  • Sort Method: quicksort Memory: 25kB
3. 0.006 36.833 ↑ 2.9 7 1

Limit (cost=38.88..344.43 rows=20 width=32) (actual time=22.764..36.833 rows=7 loops=1)

4. 4.492 36.827 ↑ 202.1 7 1

GroupAggregate (cost=38.88..21,656.61 rows=1,415 width=32) (actual time=22.762..36.827 rows=7 loops=1)

  • Group Key: ct.contract_id
  • Filter: (count(DISTINCT ct.task_nid) > 2)
  • Rows Removed by Filter: 2058
5. 1.595 32.335 ↑ 1.5 3,027 1

Merge Append (cost=38.88..21,585.36 rows=4,568 width=25) (actual time=20.334..32.335 rows=3,027 loops=1)

  • Sort Key: ct.contract_id DESC
6. 0.006 0.009 ↓ 0.0 0 1

Sort (cost=0.01..0.02 rows=1 width=42) (actual time=0.009..0.009 rows=0 loops=1)

  • Sort Key: ct.contract_id DESC
  • Sort Method: quicksort Memory: 25kB
7. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on data_contracttime_days ct (cost=0.00..0.00 rows=1 width=42) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (minutes_online > 0)
8. 0.003 0.003 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200601_contract_id_idx on part_data_contracttime_days_200601 ct_1 (cost=0.15..49.57 rows=103 width=42) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (minutes_online > 0)
9. 0.001 0.001 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200602_contract_id_idx on part_data_contracttime_days_200602 ct_2 (cost=0.15..49.57 rows=103 width=42) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (minutes_online > 0)
10. 0.000 0.000 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200603_contract_id_idx on part_data_contracttime_days_200603 ct_3 (cost=0.15..49.57 rows=103 width=42) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (minutes_online > 0)
11. 0.000 0.000 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200604_contract_id_idx on part_data_contracttime_days_200604 ct_4 (cost=0.15..49.57 rows=103 width=42) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (minutes_online > 0)
12. 0.000 0.000 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200605_contract_id_idx on part_data_contracttime_days_200605 ct_5 (cost=0.15..49.57 rows=103 width=42) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (minutes_online > 0)
13. 0.011 0.011 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200606_contract_id_idx on part_data_contracttime_days_200606 ct_6 (cost=0.12..8.14 rows=1 width=11) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1
14. 0.010 0.010 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200607_contract_id_idx on part_data_contracttime_days_200607 ct_7 (cost=0.14..12.54 rows=1 width=11) (actual time=0.010..0.010 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 23
15. 0.007 0.007 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200608_contract_id_idx on part_data_contracttime_days_200608 ct_8 (cost=0.14..12.41 rows=1 width=11) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 16
16. 0.008 0.008 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200609_contract_id_idx on part_data_contracttime_days_200609 ct_9 (cost=0.14..12.54 rows=1 width=11) (actual time=0.008..0.008 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 23
17. 0.011 0.011 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200610_contract_id_idx on part_data_contracttime_days_200610 ct_10 (cost=0.14..12.66 rows=1 width=11) (actual time=0.010..0.011 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 30
18. 0.007 0.007 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200611_contract_id_idx on part_data_contracttime_days_200611 ct_11 (cost=0.14..12.36 rows=1 width=11) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 13
19. 0.001 0.001 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200612_contract_id_idx on part_data_contracttime_days_200612 ct_12 (cost=0.15..49.57 rows=103 width=42) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (minutes_online > 0)
20. 0.008 0.008 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200701_contract_id_idx on part_data_contracttime_days_200701 ct_13 (cost=0.13..12.16 rows=1 width=11) (actual time=0.008..0.008 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 2
21. 0.012 0.012 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200702_contract_id_idx on part_data_contracttime_days_200702 ct_14 (cost=0.14..12.95 rows=1 width=11) (actual time=0.012..0.012 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 46
22. 0.018 0.018 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200703_contract_id_idx on part_data_contracttime_days_200703 ct_15 (cost=0.14..17.03 rows=1 width=11) (actual time=0.018..0.018 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 56
23. 0.007 0.007 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200704_contract_id_idx on part_data_contracttime_days_200704 ct_16 (cost=0.14..12.31 rows=1 width=11) (actual time=0.006..0.007 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 10
24. 0.009 0.009 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200705_contract_id_idx on part_data_contracttime_days_200705 ct_17 (cost=0.14..12.57 rows=1 width=11) (actual time=0.009..0.009 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 25
25. 0.022 0.022 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200706_contract_id_idx on part_data_contracttime_days_200706 ct_18 (cost=0.14..17.27 rows=1 width=11) (actual time=0.022..0.022 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 66
26. 0.013 0.013 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200707_contract_id_idx on part_data_contracttime_days_200707 ct_19 (cost=0.14..13.00 rows=1 width=11) (actual time=0.013..0.013 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 49
27. 0.010 0.010 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200708_contract_id_idx on part_data_contracttime_days_200708 ct_20 (cost=0.14..12.61 rows=1 width=11) (actual time=0.009..0.010 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 27
28. 0.008 0.008 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200709_contract_id_idx on part_data_contracttime_days_200709 ct_21 (cost=0.14..12.40 rows=1 width=11) (actual time=0.007..0.008 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 15
29. 0.006 0.006 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200710_contract_id_idx on part_data_contracttime_days_200710 ct_22 (cost=0.14..12.29 rows=1 width=11) (actual time=0.006..0.006 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 9
30. 0.006 0.006 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200711_contract_id_idx on part_data_contracttime_days_200711 ct_23 (cost=0.14..12.40 rows=1 width=11) (actual time=0.006..0.006 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 15
31. 0.007 0.007 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200712_contract_id_idx on part_data_contracttime_days_200712 ct_24 (cost=0.14..12.40 rows=1 width=11) (actual time=0.006..0.007 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 15
32. 0.010 0.010 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200801_contract_id_idx on part_data_contracttime_days_200801 ct_25 (cost=0.14..12.75 rows=1 width=11) (actual time=0.010..0.010 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 35
33. 0.015 0.015 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200802_contract_id_idx on part_data_contracttime_days_200802 ct_26 (cost=0.14..16.12 rows=1 width=11) (actual time=0.015..0.015 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 57
34. 0.010 0.010 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200803_contract_id_idx on part_data_contracttime_days_200803 ct_27 (cost=0.14..12.64 rows=1 width=11) (actual time=0.010..0.010 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 29
35. 0.012 0.012 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200804_contract_id_idx on part_data_contracttime_days_200804 ct_28 (cost=0.14..12.89 rows=1 width=11) (actual time=0.011..0.012 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 43
36. 0.008 0.008 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200805_contract_id_idx on part_data_contracttime_days_200805 ct_29 (cost=0.14..12.47 rows=1 width=11) (actual time=0.008..0.008 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 19
37. 0.001 0.001 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200806_contract_id_idx on part_data_contracttime_days_200806 ct_30 (cost=0.15..49.57 rows=103 width=42) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (minutes_online > 0)
38. 0.000 0.000 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200807_contract_id_idx on part_data_contracttime_days_200807 ct_31 (cost=0.15..49.57 rows=103 width=42) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (minutes_online > 0)
39. 0.000 0.000 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200808_contract_id_idx on part_data_contracttime_days_200808 ct_32 (cost=0.15..49.57 rows=103 width=42) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (minutes_online > 0)
40. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200809_contract_id_idx on part_data_contracttime_days_200809 ct_33 (cost=0.14..12.29 rows=1 width=11) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 9
41. 0.005 0.005 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200810_contract_id_idx on part_data_contracttime_days_200810 ct_34 (cost=0.13..12.27 rows=1 width=11) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 8
42. 0.009 0.009 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200811_contract_id_idx on part_data_contracttime_days_200811 ct_35 (cost=0.14..12.47 rows=1 width=11) (actual time=0.008..0.009 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 19
43. 0.005 0.005 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200812_contract_id_idx on part_data_contracttime_days_200812 ct_36 (cost=0.13..12.27 rows=1 width=11) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 8
44. 0.003 0.003 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200901_contract_id_idx on part_data_contracttime_days_200901 ct_37 (cost=0.12..8.14 rows=1 width=11) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1
45. 0.011 0.011 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200902_contract_id_idx on part_data_contracttime_days_200902 ct_38 (cost=0.14..12.77 rows=1 width=32) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 36
46. 0.011 0.011 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200903_contract_id_idx on part_data_contracttime_days_200903 ct_39 (cost=0.14..16.33 rows=1 width=29) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 27
47. 0.014 0.014 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200904_contract_id_idx on part_data_contracttime_days_200904 ct_40 (cost=0.14..16.46 rows=1 width=27) (actual time=0.014..0.014 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 42
48. 0.006 0.006 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200905_contract_id_idx on part_data_contracttime_days_200905 ct_41 (cost=0.14..12.31 rows=1 width=53) (actual time=0.006..0.006 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 10
49. 0.003 0.003 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200906_contract_id_idx on part_data_contracttime_days_200906 ct_42 (cost=0.13..12.16 rows=1 width=11) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 2
50. 0.007 0.007 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200907_contract_id_idx on part_data_contracttime_days_200907 ct_43 (cost=0.14..12.47 rows=1 width=11) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 19
51. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200908_contract_id_idx on part_data_contracttime_days_200908 ct_44 (cost=0.13..12.16 rows=1 width=11) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 2
52. 0.006 0.006 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200909_contract_id_idx on part_data_contracttime_days_200909 ct_45 (cost=0.14..12.33 rows=1 width=14) (actual time=0.006..0.006 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 11
53. 0.005 0.005 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200910_contract_id_idx on part_data_contracttime_days_200910 ct_46 (cost=0.13..12.24 rows=1 width=11) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 6
54. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200911_contract_id_idx on part_data_contracttime_days_200911 ct_47 (cost=0.13..12.20 rows=1 width=11) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 4
55. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_200912_contract_id_idx on part_data_contracttime_days_200912 ct_48 (cost=0.13..12.18 rows=1 width=11) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 3
56. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201001_contract_id_idx on part_data_contracttime_days_201001 ct_49 (cost=0.13..12.27 rows=1 width=11) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 8
57. 0.008 0.008 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201002_contract_id_idx on part_data_contracttime_days_201002 ct_50 (cost=0.14..12.47 rows=1 width=11) (actual time=0.007..0.008 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 19
58. 0.006 0.006 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201003_contract_id_idx on part_data_contracttime_days_201003 ct_51 (cost=0.14..12.38 rows=1 width=11) (actual time=0.006..0.006 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 14
59. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201004_contract_id_idx on part_data_contracttime_days_201004 ct_52 (cost=0.13..12.20 rows=1 width=11) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 4
60. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201005_contract_id_idx on part_data_contracttime_days_201005 ct_53 (cost=0.13..12.18 rows=1 width=11) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 3
61. 0.001 0.001 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201006_contract_id_idx on part_data_contracttime_days_201006 ct_54 (cost=0.15..49.57 rows=103 width=42) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (minutes_online > 0)
62. 0.003 0.003 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201007_contract_id_idx on part_data_contracttime_days_201007 ct_55 (cost=0.13..12.16 rows=1 width=11) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 2
63. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201008_contract_id_idx on part_data_contracttime_days_201008 ct_56 (cost=0.13..12.16 rows=1 width=11) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 2
64. 0.002 0.002 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201009_contract_id_idx on part_data_contracttime_days_201009 ct_57 (cost=0.15..49.57 rows=103 width=42) (actual time=0.001..0.002 rows=0 loops=1)

  • Filter: (minutes_online > 0)
65. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201010_contract_id_idx on part_data_contracttime_days_201010 ct_58 (cost=0.12..8.14 rows=1 width=15) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1
66. 0.003 0.003 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201011_contract_id_idx on part_data_contracttime_days_201011 ct_59 (cost=0.12..8.14 rows=1 width=11) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1
67. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201012_contract_id_idx on part_data_contracttime_days_201012 ct_60 (cost=0.13..12.18 rows=1 width=11) (actual time=0.003..0.004 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 3
68. 0.003 0.003 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201101_contract_id_idx on part_data_contracttime_days_201101 ct_61 (cost=0.13..12.24 rows=1 width=23) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 6
69. 0.005 0.005 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201102_contract_id_idx on part_data_contracttime_days_201102 ct_62 (cost=0.14..12.40 rows=1 width=29) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 15
70. 0.005 0.005 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201103_contract_id_idx on part_data_contracttime_days_201103 ct_63 (cost=0.14..12.36 rows=1 width=36) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 13
71. 0.009 0.009 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201104_contract_id_idx on part_data_contracttime_days_201104 ct_64 (cost=0.14..12.66 rows=1 width=13) (actual time=0.009..0.009 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 30
72. 0.005 0.005 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201105_contract_id_idx on part_data_contracttime_days_201105 ct_65 (cost=0.13..12.18 rows=1 width=11) (actual time=0.004..0.005 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 3
73. 0.009 0.009 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201106_contract_id_idx on part_data_contracttime_days_201106 ct_66 (cost=0.14..12.64 rows=1 width=11) (actual time=0.009..0.009 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 29
74. 0.005 0.005 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201107_contract_id_idx on part_data_contracttime_days_201107 ct_67 (cost=0.14..12.35 rows=1 width=23) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 12
75. 0.008 0.008 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201108_contract_id_idx on part_data_contracttime_days_201108 ct_68 (cost=0.14..12.52 rows=1 width=19) (actual time=0.007..0.008 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 22
76. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201109_contract_id_idx on part_data_contracttime_days_201109 ct_69 (cost=0.13..12.24 rows=1 width=11) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 6
77. 0.007 0.007 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201110_contract_id_idx on part_data_contracttime_days_201110 ct_70 (cost=0.14..12.47 rows=1 width=29) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 19
78. 0.010 0.010 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201111_contract_id_idx on part_data_contracttime_days_201111 ct_71 (cost=0.14..12.77 rows=1 width=17) (actual time=0.010..0.010 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 36
79. 0.012 0.012 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201112_contract_id_idx on part_data_contracttime_days_201112 ct_72 (cost=0.14..16.49 rows=1 width=23) (actual time=0.011..0.012 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 27
80. 0.011 0.011 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201201_contract_id_idx on part_data_contracttime_days_201201 ct_73 (cost=0.14..12.70 rows=1 width=11) (actual time=0.010..0.011 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 32
81. 0.016 0.016 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201202_contract_id_idx on part_data_contracttime_days_201202 ct_74 (cost=0.14..20.80 rows=1 width=29) (actual time=0.016..0.016 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 38
82. 0.009 0.009 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201203_contract_id_idx on part_data_contracttime_days_201203 ct_75 (cost=0.14..16.56 rows=1 width=11) (actual time=0.009..0.009 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 26
83. 0.005 0.005 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201204_contract_id_idx on part_data_contracttime_days_201204 ct_76 (cost=0.13..12.26 rows=1 width=11) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 7
84. 0.006 0.006 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201205_contract_id_idx on part_data_contracttime_days_201205 ct_77 (cost=0.14..12.44 rows=1 width=25) (actual time=0.006..0.006 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 17
85. 0.009 0.009 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201206_contract_id_idx on part_data_contracttime_days_201206 ct_78 (cost=0.14..12.57 rows=1 width=31) (actual time=0.008..0.009 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 25
86. 0.006 0.006 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201207_contract_id_idx on part_data_contracttime_days_201207 ct_79 (cost=0.14..12.35 rows=1 width=41) (actual time=0.006..0.006 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 12
87. 0.009 0.009 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201208_contract_id_idx on part_data_contracttime_days_201208 ct_80 (cost=0.14..12.61 rows=1 width=31) (actual time=0.008..0.009 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 27
88. 0.007 0.007 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201209_contract_id_idx on part_data_contracttime_days_201209 ct_81 (cost=0.14..12.54 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 23
89. 0.072 0.072 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201210_contract_id_idx on part_data_contracttime_days_201210 ct_82 (cost=0.14..31.80 rows=1 width=11) (actual time=0.072..0.072 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 209
90. 0.095 0.095 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201211_contract_id_idx on part_data_contracttime_days_201211 ct_83 (cost=0.14..44.56 rows=1 width=14) (actual time=0.094..0.095 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 253
91. 0.022 0.022 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201212_contract_id_idx on part_data_contracttime_days_201212 ct_84 (cost=0.14..28.66 rows=1 width=11) (actual time=0.021..0.022 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 44
92. 0.029 0.029 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201301_contract_id_idx on part_data_contracttime_days_201301 ct_85 (cost=0.14..44.87 rows=1 width=13) (actual time=0.029..0.029 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 60
93. 0.107 0.107 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201302_contract_id_idx on part_data_contracttime_days_201302 ct_86 (cost=0.27..433.84 rows=1 width=26) (actual time=0.107..0.107 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 141
94. 0.259 0.259 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201303_contract_id_idx on part_data_contracttime_days_201303 ct_87 (cost=0.27..503.25 rows=1 width=14) (actual time=0.259..0.259 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 489
95. 0.175 0.175 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201304_contract_id_idx on part_data_contracttime_days_201304 ct_88 (cost=0.27..203.28 rows=1 width=13) (actual time=0.175..0.175 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 401
96. 0.127 0.127 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201305_contract_id_idx on part_data_contracttime_days_201305 ct_89 (cost=0.27..132.92 rows=1 width=12) (actual time=0.127..0.127 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 294
97. 0.151 0.151 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201306_contract_id_idx on part_data_contracttime_days_201306 ct_90 (cost=0.27..151.79 rows=1 width=13) (actual time=0.151..0.151 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 393
98. 0.142 0.142 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201307_contract_id_idx on part_data_contracttime_days_201307 ct_91 (cost=0.27..250.93 rows=1 width=11) (actual time=0.142..0.142 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 307
99. 0.140 0.140 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201308_contract_id_idx on part_data_contracttime_days_201308 ct_92 (cost=0.27..535.78 rows=1 width=13) (actual time=0.140..0.140 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 202
100. 0.084 0.084 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201309_contract_id_idx on part_data_contracttime_days_201309 ct_93 (cost=0.27..230.59 rows=1 width=12) (actual time=0.084..0.084 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 190
101. 0.133 0.133 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201310_contract_id_idx on part_data_contracttime_days_201310 ct_94 (cost=0.27..264.72 rows=1 width=16) (actual time=0.133..0.133 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 259
102. 0.083 0.083 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201311_contract_id_idx on part_data_contracttime_days_201311 ct_95 (cost=0.27..177.84 rows=1 width=14) (actual time=0.082..0.083 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 147
103. 0.120 0.120 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201312_contract_id_idx on part_data_contracttime_days_201312 ct_96 (cost=0.27..208.30 rows=1 width=14) (actual time=0.120..0.120 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 239
104. 0.084 0.084 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201401_contract_id_idx on part_data_contracttime_days_201401 ct_97 (cost=0.27..199.88 rows=1 width=15) (actual time=0.084..0.084 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 152
105. 0.086 0.086 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201402_contract_id_idx on part_data_contracttime_days_201402 ct_98 (cost=0.27..249.05 rows=1 width=11) (actual time=0.086..0.086 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 262
106. 0.096 0.096 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201403_contract_id_idx on part_data_contracttime_days_201403 ct_99 (cost=0.27..629.51 rows=1 width=11) (actual time=0.096..0.096 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 236
107. 0.128 0.128 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201404_contract_id_idx on part_data_contracttime_days_201404 ct_100 (cost=0.27..592.87 rows=1 width=14) (actual time=0.128..0.128 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 345
108. 0.166 0.166 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201405_contract_id_idx on part_data_contracttime_days_201405 ct_101 (cost=0.27..703.09 rows=1 width=14) (actual time=0.165..0.166 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 490
109. 0.278 0.278 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201406_contract_id_idx on part_data_contracttime_days_201406 ct_102 (cost=0.28..979.98 rows=1 width=11) (actual time=0.278..0.278 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 830
110. 1.815 1.815 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201407_contract_id_idx on part_data_contracttime_days_201407 ct_103 (cost=0.29..1,113.81 rows=1 width=11) (actual time=1.815..1.815 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 9141
111. 0.003 0.003 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201408_contract_id_idx on part_data_contracttime_days_201408 ct_104 (cost=0.15..49.57 rows=103 width=42) (actual time=0.002..0.003 rows=0 loops=1)

  • Filter: (minutes_online > 0)
112. 0.007 0.007 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201409_contract_id_idx on part_data_contracttime_days_201409 ct_105 (cost=0.13..12.16 rows=1 width=53) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 2
113. 0.001 0.001 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201410_contract_id_idx on part_data_contracttime_days_201410 ct_106 (cost=0.15..49.57 rows=103 width=42) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (minutes_online > 0)
114. 0.003 0.003 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201411_contract_id_idx on part_data_contracttime_days_201411 ct_107 (cost=0.15..49.57 rows=103 width=42) (actual time=0.002..0.003 rows=0 loops=1)

  • Filter: (minutes_online > 0)
115. 0.058 0.058 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201412_contract_id_idx on part_data_contracttime_days_201412 ct_108 (cost=0.27..173.75 rows=1 width=11) (actual time=0.058..0.058 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 96
116. 0.345 0.345 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201501_contract_id_idx on part_data_contracttime_days_201501 ct_109 (cost=0.28..461.65 rows=1 width=11) (actual time=0.345..0.345 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1215
117. 0.399 0.399 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201502_contract_id_idx on part_data_contracttime_days_201502 ct_110 (cost=0.28..521.89 rows=1 width=11) (actual time=0.398..0.399 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1390
118. 0.325 0.325 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201503_contract_id_idx on part_data_contracttime_days_201503 ct_111 (cost=0.28..262.51 rows=1 width=11) (actual time=0.324..0.325 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1262
119. 0.142 0.142 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201504_contract_id_idx on part_data_contracttime_days_201504 ct_112 (cost=0.27..277.15 rows=1 width=11) (actual time=0.142..0.142 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 280
120. 0.167 0.167 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201505_contract_id_idx on part_data_contracttime_days_201505 ct_113 (cost=0.27..265.97 rows=1 width=11) (actual time=0.167..0.167 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 337
121. 0.187 0.187 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201506_contract_id_idx on part_data_contracttime_days_201506 ct_114 (cost=0.27..417.69 rows=1 width=11) (actual time=0.187..0.187 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 343
122. 0.213 0.213 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201507_contract_id_idx on part_data_contracttime_days_201507 ct_115 (cost=0.27..565.98 rows=1 width=11) (actual time=0.213..0.213 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 355
123. 0.326 0.326 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201508_contract_id_idx on part_data_contracttime_days_201508 ct_116 (cost=0.28..492.96 rows=1 width=11) (actual time=0.326..0.326 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 667
124. 0.277 0.277 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201509_contract_id_idx on part_data_contracttime_days_201509 ct_117 (cost=0.28..245.92 rows=1 width=11) (actual time=0.277..0.277 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 651
125. 0.439 0.439 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201510_contract_id_idx on part_data_contracttime_days_201510 ct_118 (cost=0.28..380.54 rows=1 width=11) (actual time=0.438..0.439 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 982
126. 0.406 0.406 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201511_contract_id_idx on part_data_contracttime_days_201511 ct_119 (cost=0.28..446.15 rows=1 width=11) (actual time=0.406..0.406 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 874
127. 0.261 0.261 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201512_contract_id_idx on part_data_contracttime_days_201512 ct_120 (cost=0.28..222.60 rows=1 width=11) (actual time=0.261..0.261 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 606
128. 0.469 0.469 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201601_contract_id_idx on part_data_contracttime_days_201601 ct_121 (cost=0.28..188.64 rows=1 width=11) (actual time=0.468..0.469 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1263
129. 0.864 0.864 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201602_contract_id_idx on part_data_contracttime_days_201602 ct_122 (cost=0.28..310.88 rows=1 width=11) (actual time=0.864..0.864 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 2232
130. 0.683 0.683 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201603_contract_id_idx on part_data_contracttime_days_201603 ct_123 (cost=0.28..299.39 rows=1 width=11) (actual time=0.683..0.683 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1837
131. 1.446 1.446 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201604_contract_id_idx on part_data_contracttime_days_201604 ct_124 (cost=0.28..607.33 rows=1 width=11) (actual time=1.446..1.446 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 3631
132. 0.677 0.677 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201605_contract_id_idx on part_data_contracttime_days_201605 ct_125 (cost=0.28..259.49 rows=1 width=11) (actual time=0.677..0.677 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1789
133. 0.348 0.348 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201606_contract_id_idx on part_data_contracttime_days_201606 ct_126 (cost=0.28..132.42 rows=1 width=11) (actual time=0.347..0.348 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 924
134. 0.850 0.850 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201607_contract_id_idx on part_data_contracttime_days_201607 ct_127 (cost=0.28..273.60 rows=1 width=11) (actual time=0.850..0.850 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 2171
135. 0.721 0.721 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201608_contract_id_idx on part_data_contracttime_days_201608 ct_128 (cost=0.28..265.57 rows=1 width=11) (actual time=0.721..0.721 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1919
136. 0.410 0.410 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201609_contract_id_idx on part_data_contracttime_days_201609 ct_129 (cost=0.28..151.21 rows=1 width=11) (actual time=0.409..0.410 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1082
137. 0.444 0.444 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201610_contract_id_idx on part_data_contracttime_days_201610 ct_130 (cost=0.28..160.39 rows=1 width=11) (actual time=0.444..0.444 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1157
138. 0.593 0.593 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201611_contract_id_idx on part_data_contracttime_days_201611 ct_131 (cost=0.28..182.96 rows=1 width=11) (actual time=0.593..0.593 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1533
139. 0.900 0.900 ↓ 0.0 0 1

Index Scan Backward using part_data_contracttime_days_201612_contract_id_idx on part_data_contracttime_days_201612 ct_132 (cost=0.28..275.62 rows=1 width=11) (actual time=0.900..0.900 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 2253
140. 0.178 0.178 ↓ 1.2 5 1

Index Scan Backward using part_data_contracttime_days_201702_contract_id_idx on part_data_contracttime_days_201702 ct_133 (cost=0.28..65.20 rows=4 width=38) (actual time=0.042..0.178 rows=5 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 726
141. 0.162 0.162 ↑ 1.0 9 1

Index Scan Backward using part_data_contracttime_days_201703_contract_id_idx on part_data_contracttime_days_201703 ct_134 (cost=0.28..95.89 rows=9 width=33) (actual time=0.131..0.162 rows=9 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 658
142. 0.199 0.199 ↓ 1.0 45 1

Index Scan Backward using part_data_contracttime_days_201704_contract_id_idx on part_data_contracttime_days_201704 ct_135 (cost=0.28..94.98 rows=44 width=30) (actual time=0.043..0.199 rows=45 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 565
143. 0.382 0.382 ↑ 1.0 211 1

Index Scan Backward using part_data_contracttime_days_201705_contract_id_idx on part_data_contracttime_days_201705 ct_136 (cost=0.28..127.08 rows=211 width=26) (actual time=0.054..0.382 rows=211 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 681
144. 0.582 0.582 ↓ 1.0 230 1

Index Scan Backward using part_data_contracttime_days_201706_contract_id_idx on part_data_contracttime_days_201706 ct_137 (cost=0.28..117.61 rows=225 width=13) (actual time=0.059..0.582 rows=230 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1314
145. 0.476 0.476 ↓ 1.0 164 1

Index Scan Backward using part_data_contracttime_days_201707_contract_id_idx on part_data_contracttime_days_201707 ct_138 (cost=0.28..119.70 rows=159 width=12) (actual time=0.046..0.476 rows=164 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1310
146. 0.517 0.517 ↓ 1.0 208 1

Index Scan Backward using part_data_contracttime_days_201708_contract_id_idx on part_data_contracttime_days_201708 ct_139 (cost=0.28..135.18 rows=205 width=14) (actual time=0.074..0.517 rows=208 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1265
147. 1.481 1.481 ↓ 1.0 298 1

Index Scan Backward using part_data_contracttime_days_201701_contract_id_idx on part_data_contracttime_days_201701 ct_140 (cost=0.28..280.56 rows=296 width=11) (actual time=0.103..1.481 rows=298 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 2055
148. 1.009 1.009 ↓ 1.0 165 1

Index Scan Backward using part_data_contracttime_days_201709_contract_id_idx on part_data_contracttime_days_201709 ct_141 (cost=0.28..226.84 rows=163 width=13) (actual time=0.410..1.009 rows=165 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 2087
149. 1.122 1.122 ↑ 1.0 167 1

Index Scan Backward using part_data_contracttime_days_201710_contract_id_idx on part_data_contracttime_days_201710 ct_142 (cost=0.28..292.15 rows=167 width=14) (actual time=0.328..1.122 rows=167 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 2094
150. 0.778 0.778 ↑ 1.0 149 1

Index Scan Backward using part_data_contracttime_days_201711_contract_id_idx on part_data_contracttime_days_201711 ct_143 (cost=0.28..290.40 rows=149 width=14) (actual time=0.184..0.778 rows=149 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1473
151. 0.345 0.345 ↑ 1.0 74 1

Index Scan Backward using part_data_contracttime_days_201712_contract_id_idx on part_data_contracttime_days_201712 ct_144 (cost=0.28..104.45 rows=74 width=15) (actual time=0.074..0.345 rows=74 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 749
152. 0.808 0.808 ↑ 1.0 135 1

Index Scan Backward using part_data_contracttime_days_201801_contract_id_idx on part_data_contracttime_days_201801 ct_145 (cost=0.28..233.22 rows=135 width=13) (actual time=0.313..0.808 rows=135 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1730
153. 0.875 0.875 ↑ 1.0 201 1

Index Scan Backward using part_data_contracttime_days_201802_contract_id_idx on part_data_contracttime_days_201802 ct_146 (cost=0.28..225.21 rows=201 width=14) (actual time=0.077..0.875 rows=201 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1667
154. 0.577 0.577 ↑ 1.0 126 1

Index Scan Backward using part_data_contracttime_days_201803_contract_id_idx on part_data_contracttime_days_201803 ct_147 (cost=0.28..169.50 rows=126 width=14) (actual time=0.128..0.577 rows=126 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1244
155. 0.477 0.477 ↑ 1.0 61 1

Index Scan Backward using part_data_contracttime_days_201804_contract_id_idx on part_data_contracttime_days_201804 ct_148 (cost=0.28..132.78 rows=61 width=13) (actual time=0.112..0.477 rows=61 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1076
156. 0.626 0.626 ↑ 1.0 70 1

Index Scan Backward using part_data_contracttime_days_201805_contract_id_idx on part_data_contracttime_days_201805 ct_149 (cost=0.28..170.16 rows=70 width=14) (actual time=0.357..0.626 rows=70 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1641
157. 0.366 0.366 ↑ 1.0 50 1

Index Scan Backward using part_data_contracttime_days_201806_contract_id_idx on part_data_contracttime_days_201806 ct_150 (cost=0.28..130.40 rows=50 width=21) (actual time=0.031..0.366 rows=50 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 708
158. 0.240 0.240 ↑ 1.0 48 1

Index Scan Backward using part_data_contracttime_days_201807_contract_id_idx on part_data_contracttime_days_201807 ct_151 (cost=0.28..83.18 rows=48 width=14) (actual time=0.061..0.240 rows=48 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 537
159. 0.343 0.343 ↑ 1.0 57 1

Index Scan Backward using part_data_contracttime_days_201808_contract_id_idx on part_data_contracttime_days_201808 ct_152 (cost=0.28..104.10 rows=57 width=14) (actual time=0.016..0.343 rows=57 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 854
160. 0.213 0.213 ↑ 1.0 67 1

Index Scan Backward using part_data_contracttime_days_201809_contract_id_idx on part_data_contracttime_days_201809 ct_153 (cost=0.27..60.08 rows=67 width=26) (actual time=0.037..0.213 rows=67 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 379
161. 0.373 0.373 ↑ 1.0 51 1

Index Scan Backward using part_data_contracttime_days_201810_contract_id_idx on part_data_contracttime_days_201810 ct_154 (cost=0.28..116.13 rows=51 width=22) (actual time=0.122..0.373 rows=51 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 718
162. 0.178 0.178 ↑ 1.0 67 1

Index Scan Backward using part_data_contracttime_days_201811_contract_id_idx on part_data_contracttime_days_201811 ct_155 (cost=0.15..60.22 rows=67 width=23) (actual time=0.022..0.178 rows=67 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 282
163. 0.092 0.092 ↑ 1.0 44 1

Index Scan Backward using part_data_contracttime_days_201812_contract_id_idx on part_data_contracttime_days_201812 ct_156 (cost=0.14..29.63 rows=44 width=26) (actual time=0.030..0.092 rows=44 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 105
164. 0.146 0.146 ↑ 1.0 53 1

Index Scan Backward using part_data_contracttime_days_201901_contract_id_idx on part_data_contracttime_days_201901 ct_157 (cost=0.14..48.08 rows=53 width=26) (actual time=0.062..0.146 rows=53 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 138
165. 0.094 0.094 ↑ 1.0 45 1

Index Scan Backward using part_data_contracttime_days_201902_contract_id_idx on part_data_contracttime_days_201902 ct_158 (cost=0.14..30.33 rows=45 width=30) (actual time=0.018..0.094 rows=45 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 101
166. 0.059 0.059 ↑ 1.0 21 1

Index Scan Backward using part_data_contracttime_days_201903_contract_id_idx on part_data_contracttime_days_201903 ct_159 (cost=0.14..24.51 rows=21 width=27) (actual time=0.027..0.059 rows=21 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 83
167. 0.160 0.160 ↑ 1.0 38 1

Index Scan Backward using part_data_contracttime_days_201904_contract_id_idx on part_data_contracttime_days_201904 ct_160 (cost=0.15..75.84 rows=38 width=31) (actual time=0.012..0.160 rows=38 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 225
168. 0.081 0.081 ↑ 1.0 17 1

Index Scan Backward using part_data_contracttime_days_201905_contract_id_idx on part_data_contracttime_days_201905 ct_161 (cost=0.14..31.70 rows=17 width=32) (actual time=0.031..0.081 rows=17 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 104
169. 0.092 0.092 ↑ 1.0 25 1

Index Scan Backward using part_data_contracttime_days_201906_contract_id_idx on part_data_contracttime_days_201906 ct_162 (cost=0.14..30.90 rows=25 width=40) (actual time=0.021..0.092 rows=25 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 117
170. 0.085 0.085 ↑ 1.0 28 1

Index Scan Backward using part_data_contracttime_days_201907_contract_id_idx on part_data_contracttime_days_201907 ct_163 (cost=0.14..30.30 rows=28 width=24) (actual time=0.020..0.085 rows=28 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 120
171. 0.066 0.066 ↓ 1.1 13 1

Index Scan Backward using part_data_contracttime_days_201908_contract_id_idx on part_data_contracttime_days_201908 ct_164 (cost=0.14..32.26 rows=12 width=23) (actual time=0.028..0.066 rows=13 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 82
172. 0.100 0.100 ↑ 1.0 28 1

Index Scan Backward using part_data_contracttime_days_201909_contract_id_idx on part_data_contracttime_days_201909 ct_165 (cost=0.14..51.45 rows=28 width=27) (actual time=0.057..0.100 rows=28 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 148
173. 0.293 0.293 ↑ 1.0 22 1

Index Scan Backward using part_data_contracttime_days_201910_contract_id_idx on part_data_contracttime_days_201910 ct_166 (cost=0.28..110.80 rows=22 width=16) (actual time=0.085..0.293 rows=22 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 543
174. 0.123 0.123 ↑ 1.0 17 1

Index Scan Backward using part_data_contracttime_days_201911_contract_id_idx on part_data_contracttime_days_201911 ct_167 (cost=0.14..49.05 rows=17 width=21) (actual time=0.061..0.123 rows=17 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 206
175. 0.035 0.035 ↑ 1.0 12 1

Index Scan Backward using part_data_contracttime_days_201912_contract_id_idx on part_data_contracttime_days_201912 ct_168 (cost=0.14..20.26 rows=12 width=25) (actual time=0.011..0.035 rows=12 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 38
176. 0.055 0.055 ↑ 1.0 5 1

Index Scan Backward using part_data_contracttime_days_202001_contract_id_idx on part_data_contracttime_days_202001 ct_169 (cost=0.14..47.25 rows=5 width=20) (actual time=0.040..0.055 rows=5 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 88
177. 0.038 0.038 ↑ 1.0 1 1

Index Scan Backward using part_data_contracttime_days_202002_contract_id_idx on part_data_contracttime_days_202002 ct_170 (cost=0.14..31.12 rows=1 width=21) (actual time=0.036..0.038 rows=1 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 83
Planning time : 7.166 ms
Execution time : 38.072 ms