explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8U1L

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 40.035 ↑ 2.9 7 1

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

2. 4.619 40.026 ↑ 202.1 7 1

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

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

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

  • Sort Key: ct.contract_id DESC
4. 0.007 0.013 ↓ 0.0 0 1

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

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

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

  • Filter: (minutes_online > 0)
6. 0.002 0.002 ↓ 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.002..0.002 rows=0 loops=1)

  • Filter: (minutes_online > 0)
7. 0.002 0.002 ↓ 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.001..0.002 rows=0 loops=1)

  • Filter: (minutes_online > 0)
8. 0.001 0.001 ↓ 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.001..0.001 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_200604_contract_id_idx on part_data_contracttime_days_200604 ct_4 (cost=0.15..49.57 rows=103 width=42) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (minutes_online > 0)
10. 0.001 0.001 ↓ 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.001..0.001 rows=0 loops=1)

  • Filter: (minutes_online > 0)
11. 0.012 0.012 ↓ 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.012 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1
12. 0.011 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 23
13. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 16
14. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 23
15. 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.011..0.011 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 30
16. 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
17. 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)
18. 0.005 0.005 ↓ 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.005..0.005 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 2
19. 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
20. 0.022 0.022 ↓ 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.022..0.022 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 56
21. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 10
22. 0.012 0.012 ↓ 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.012..0.012 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 25
23. 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
24. 0.018 0.018 ↓ 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.017..0.018 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 49
25. 0.011 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 27
26. 0.013 0.013 ↓ 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.013..0.013 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 15
27. 0.009 0.009 ↓ 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.008..0.009 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 9
28. 0.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 15
29. 0.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 15
30. 0.012 0.012 ↓ 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.012..0.012 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 35
31. 0.019 0.019 ↓ 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.019..0.019 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 57
32. 0.011 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 29
33. 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.012..0.012 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 43
34. 0.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 19
35. 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)
36. 0.001 0.001 ↓ 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.001..0.001 rows=0 loops=1)

  • Filter: (minutes_online > 0)
37. 0.001 0.001 ↓ 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.001..0.001 rows=0 loops=1)

  • Filter: (minutes_online > 0)
38. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 9
39. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 8
40. 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.009..0.009 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 19
41. 0.007 0.007 ↓ 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.006..0.007 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 8
42. 0.004 0.004 ↓ 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.004..0.004 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1
43. 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
44. 0.012 0.012 ↓ 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.012..0.012 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 27
45. 0.013 0.013 ↓ 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.013..0.013 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 42
46. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 10
47. 0.006 0.006 ↓ 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.005..0.006 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 2
48. 0.011 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 19
49. 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
50. 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
51. 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
52. 0.005 0.005 ↓ 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.005..0.005 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 4
53. 0.006 0.006 ↓ 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.005..0.006 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 3
54. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 8
55. 0.011 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 19
56. 0.008 0.008 ↓ 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.007..0.008 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 14
57. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 4
58. 0.005 0.005 ↓ 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.005..0.005 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 3
59. 0.002 0.002 ↓ 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.002 rows=0 loops=1)

  • Filter: (minutes_online > 0)
60. 0.005 0.005 ↓ 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.005..0.005 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 2
61. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 2
62. 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)
63. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1
64. 0.004 0.004 ↓ 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.004..0.004 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1
65. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 3
66. 0.005 0.005 ↓ 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.005..0.005 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 6
67. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 15
68. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 13
69. 0.011 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 30
70. 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.005..0.005 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 3
71. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 29
72. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 12
73. 0.010 0.010 ↓ 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.009..0.010 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 22
74. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 6
75. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 19
76. 0.012 0.012 ↓ 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.012..0.012 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 36
77. 0.013 0.013 ↓ 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.013..0.013 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 27
78. 0.010 0.010 ↓ 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.010 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 32
79. 0.018 0.018 ↓ 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.017..0.018 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 38
80. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 26
81. 0.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 7
82. 0.008 0.008 ↓ 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.007..0.008 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 17
83. 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.009..0.009 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 25
84. 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
85. 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.009..0.009 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 27
86. 0.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 23
87. 0.076 0.076 ↓ 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.076..0.076 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 209
88. 0.094 0.094 ↓ 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.093..0.094 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 253
89. 0.021 0.021 ↓ 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.021 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 44
90. 0.030 0.030 ↓ 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.030..0.030 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 60
91. 0.110 0.110 ↓ 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.110..0.110 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 141
92. 0.249 0.249 ↓ 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.249..0.249 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 489
93. 0.185 0.185 ↓ 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.185..0.185 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 401
94. 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.126..0.127 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 294
95. 0.146 0.146 ↓ 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.146..0.146 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 393
96. 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
97. 0.139 0.139 ↓ 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.139..0.139 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 202
98. 0.090 0.090 ↓ 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.090..0.090 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 190
99. 0.135 0.135 ↓ 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.135..0.135 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 259
100. 0.084 0.084 ↓ 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.083..0.084 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 147
101. 0.122 0.122 ↓ 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.122..0.122 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 239
102. 0.087 0.087 ↓ 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.087..0.087 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 152
103. 0.091 0.091 ↓ 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.091..0.091 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 262
104. 0.101 0.101 ↓ 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.101..0.101 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 236
105. 0.129 0.129 ↓ 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.129..0.129 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 345
106. 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.166..0.166 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 490
107. 0.251 0.251 ↓ 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.251..0.251 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 830
108. 1.813 1.813 ↓ 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.813..1.813 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 9141
109. 0.002 0.002 ↓ 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.002 rows=0 loops=1)

  • Filter: (minutes_online > 0)
110. 0.012 0.012 ↓ 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.012..0.012 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 2
111. 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)
112. 0.001 0.001 ↓ 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.001..0.001 rows=0 loops=1)

  • Filter: (minutes_online > 0)
113. 0.062 0.062 ↓ 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.062..0.062 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 96
114. 0.331 0.331 ↓ 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.331..0.331 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1215
115. 0.393 0.393 ↓ 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.392..0.393 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1390
116. 0.317 0.317 ↓ 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.317..0.317 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1262
117. 0.139 0.139 ↓ 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.139..0.139 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 280
118. 0.163 0.163 ↓ 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.163..0.163 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 337
119. 0.192 0.192 ↓ 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.192..0.192 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 343
120. 0.229 0.229 ↓ 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.229..0.229 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 355
121. 0.317 0.317 ↓ 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.316..0.317 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 667
122. 0.287 0.287 ↓ 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.287..0.287 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 651
123. 0.423 0.423 ↓ 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.423..0.423 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 982
124. 0.389 0.389 ↓ 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.388..0.389 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 874
125. 0.258 0.258 ↓ 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.258..0.258 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 606
126. 0.465 0.465 ↓ 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.465..0.465 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1263
127. 0.913 0.913 ↓ 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.913..0.913 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 2232
128. 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
129. 1.489 1.489 ↓ 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.489..1.489 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 3631
130. 0.678 0.678 ↓ 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.678..0.678 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1789
131. 0.350 0.350 ↓ 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.350..0.350 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 924
132. 0.824 0.824 ↓ 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.823..0.824 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 2171
133. 0.705 0.705 ↓ 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.705..0.705 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1919
134. 0.404 0.404 ↓ 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.404..0.404 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1082
135. 0.452 0.452 ↓ 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.452..0.452 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1157
136. 0.575 0.575 ↓ 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.575..0.575 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1533
137. 0.852 0.852 ↓ 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.852..0.852 rows=0 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 2253
138. 0.175 0.175 ↓ 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.175 rows=5 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 726
139. 0.166 0.166 ↑ 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.132..0.166 rows=9 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 658
140. 0.200 0.200 ↓ 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.041..0.200 rows=45 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 565
141. 0.392 0.392 ↑ 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.053..0.392 rows=211 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 681
142. 0.580 0.580 ↓ 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.063..0.580 rows=230 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1314
143. 0.489 0.489 ↓ 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.049..0.489 rows=164 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1310
144. 0.558 0.558 ↓ 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.072..0.558 rows=208 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1265
145. 1.468 1.468 ↓ 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.108..1.468 rows=298 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 2055
146. 3.565 3.565 ↓ 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=2.988..3.565 rows=165 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 2087
147. 1.214 1.214 ↑ 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.354..1.214 rows=167 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 2094
148. 0.771 0.771 ↑ 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.178..0.771 rows=149 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1473
149. 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.072..0.345 rows=74 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 749
150. 0.818 0.818 ↑ 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.323..0.818 rows=135 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1730
151. 1.072 1.072 ↑ 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.083..1.072 rows=201 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1667
152. 0.569 0.569 ↑ 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.130..0.569 rows=126 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1244
153. 0.481 0.481 ↑ 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.114..0.481 rows=61 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1076
154. 0.625 0.625 ↑ 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.353..0.625 rows=70 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 1641
155. 0.359 0.359 ↑ 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.029..0.359 rows=50 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 708
156. 0.232 0.232 ↑ 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.058..0.232 rows=48 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 537
157. 0.346 0.346 ↑ 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.018..0.346 rows=57 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 854
158. 0.208 0.208 ↑ 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.034..0.208 rows=67 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 379
159. 0.379 0.379 ↑ 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.120..0.379 rows=51 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 718
160. 0.184 0.184 ↑ 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.023..0.184 rows=67 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 282
161. 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.029..0.092 rows=44 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 105
162. 0.130 0.130 ↑ 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.053..0.130 rows=53 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 138
163. 0.099 0.099 ↑ 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.021..0.099 rows=45 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 101
164. 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.028..0.059 rows=21 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 83
165. 0.162 0.162 ↑ 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.011..0.162 rows=38 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 225
166. 0.077 0.077 ↑ 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.030..0.077 rows=17 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 104
167. 0.083 0.083 ↑ 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.019..0.083 rows=25 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 117
168. 0.280 0.280 ↑ 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.021..0.280 rows=28 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 120
169. 0.061 0.061 ↓ 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.061 rows=13 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 82
170. 0.102 0.102 ↑ 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.102 rows=28 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 148
171. 0.298 0.298 ↑ 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.088..0.298 rows=22 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 543
172. 0.121 0.121 ↑ 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.060..0.121 rows=17 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 206
173. 0.039 0.039 ↑ 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.013..0.039 rows=12 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 38
174. 0.059 0.059 ↑ 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.043..0.059 rows=5 loops=1)

  • Filter: (minutes_online > 0)
  • Rows Removed by Filter: 88
175. 0.042 0.042 ↑ 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.039..0.042 rows=1 loops=1)

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