explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ghPi

Settings
# exclusive inclusive rows x rows loops node
1. 0.033 32.462 ↑ 222.5 2 1

GroupAggregate (cost=12,263.76..12,287.12 rows=445 width=108) (actual time=32.460..32.462 rows=2 loops=1)

  • Group Key: c.team_company, a.odesk_team_user_id, d.contract_id
2. 0.024 32.429 ↑ 222.5 2 1

Sort (cost=12,263.76..12,264.87 rows=445 width=103) (actual time=32.428..32.429 rows=2 loops=1)

  • Sort Key: c.team_company, a.odesk_team_user_id, d.contract_id
  • Sort Method: quicksort Memory: 25kB
3. 0.002 32.405 ↑ 222.5 2 1

Nested Loop (cost=0.85..12,244.19 rows=445 width=103) (actual time=32.371..32.405 rows=2 loops=1)

4. 0.009 32.387 ↑ 222.5 2 1

Nested Loop (cost=0.42..11,876.64 rows=445 width=89) (actual time=32.360..32.387 rows=2 loops=1)

5. 0.056 32.356 ↑ 222.5 2 1

Append (cost=0.00..8,224.39 rows=445 width=65) (actual time=32.338..32.356 rows=2 loops=1)

6. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on data_contracttime_days d (cost=0.00..0.00 rows=1 width=48) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
7. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200601 d_1 (cost=0.00..15.43 rows=2 width=48) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
8. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200602 d_2 (cost=0.00..15.43 rows=2 width=48) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
9. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200603 d_3 (cost=0.00..15.43 rows=2 width=48) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
10. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200604 d_4 (cost=0.00..15.43 rows=2 width=48) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
11. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200605 d_5 (cost=0.00..15.43 rows=2 width=48) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
12. 0.019 0.019 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200606 d_6 (cost=0.00..1.02 rows=1 width=29) (actual time=0.019..0.019 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 1
13. 0.020 0.020 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200607 d_7 (cost=0.00..1.40 rows=1 width=182) (actual time=0.020..0.020 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 23
14. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200608 d_8 (cost=0.00..1.28 rows=1 width=87) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 16
15. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200609 d_9 (cost=0.00..1.40 rows=1 width=92) (actual time=0.013..0.013 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 23
16. 0.015 0.015 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200610 d_10 (cost=0.00..1.52 rows=1 width=67) (actual time=0.015..0.015 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 30
17. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200611 d_11 (cost=0.00..1.23 rows=1 width=55) (actual time=0.009..0.009 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 13
18. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200612 d_12 (cost=0.00..15.43 rows=2 width=48) (actual time=0.002..0.003 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
19. 0.014 0.014 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200701 d_13 (cost=0.00..1.03 rows=1 width=34) (actual time=0.014..0.014 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 2
20. 0.022 0.022 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200702 d_14 (cost=0.00..1.81 rows=1 width=56) (actual time=0.022..0.022 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 46
21. 0.024 0.024 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200703 d_15 (cost=0.00..2.98 rows=1 width=36) (actual time=0.023..0.024 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 56
22. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200704 d_16 (cost=0.00..1.18 rows=1 width=74) (actual time=0.010..0.010 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 10
23. 0.017 0.017 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200705 d_17 (cost=0.00..1.44 rows=1 width=75) (actual time=0.017..0.017 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 25
24. 0.026 0.026 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200706 d_18 (cost=0.00..3.16 rows=1 width=35) (actual time=0.026..0.026 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 66
25. 0.018 0.018 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200707 d_19 (cost=0.00..1.86 rows=1 width=33) (actual time=0.018..0.018 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 49
26. 0.019 0.019 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200708 d_20 (cost=0.00..1.47 rows=1 width=68) (actual time=0.018..0.019 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 27
27. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200709 d_21 (cost=0.00..1.26 rows=1 width=29) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 15
28. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200710 d_22 (cost=0.00..1.16 rows=1 width=32) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 9
29. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200711 d_23 (cost=0.00..1.26 rows=1 width=62) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 15
30. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200712 d_24 (cost=0.00..1.26 rows=1 width=45) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 15
31. 0.017 0.017 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200801 d_25 (cost=0.00..1.61 rows=1 width=33) (actual time=0.017..0.017 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 35
32. 0.021 0.021 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200802 d_26 (cost=0.00..3.00 rows=1 width=32) (actual time=0.021..0.021 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 57
33. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200803 d_27 (cost=0.00..1.51 rows=1 width=36) (actual time=0.013..0.013 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 29
34. 0.016 0.016 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200804 d_28 (cost=0.00..1.75 rows=1 width=30) (actual time=0.016..0.016 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 43
35. 0.014 0.014 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200805 d_29 (cost=0.00..1.33 rows=1 width=35) (actual time=0.013..0.014 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 19
36. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200806 d_30 (cost=0.00..15.43 rows=2 width=48) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
37. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200807 d_31 (cost=0.00..15.43 rows=2 width=48) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
38. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200808 d_32 (cost=0.00..15.43 rows=2 width=48) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
39. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200809 d_33 (cost=0.00..1.16 rows=1 width=34) (actual time=0.010..0.011 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 9
40. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200810 d_34 (cost=0.00..1.14 rows=1 width=179) (actual time=0.008..0.008 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 8
41. 0.014 0.014 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200811 d_35 (cost=0.00..1.33 rows=1 width=81) (actual time=0.014..0.014 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 19
42. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200812 d_36 (cost=0.00..1.14 rows=1 width=37) (actual time=0.008..0.009 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 8
43. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200901 d_37 (cost=0.00..1.02 rows=1 width=59) (actual time=0.009..0.009 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 1
44. 0.017 0.017 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200902 d_38 (cost=0.00..1.63 rows=1 width=33) (actual time=0.017..0.017 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 36
45. 0.014 0.014 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200903 d_39 (cost=0.00..2.47 rows=1 width=35) (actual time=0.014..0.014 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 27
46. 0.024 0.024 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200904 d_40 (cost=0.00..2.74 rows=1 width=50) (actual time=0.024..0.024 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 42
47. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200905 d_41 (cost=0.00..1.18 rows=1 width=37) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 10
48. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200906 d_42 (cost=0.00..1.03 rows=1 width=34) (actual time=0.006..0.006 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 2
49. 0.012 0.012 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200907 d_43 (cost=0.00..1.33 rows=1 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 19
50. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200908 d_44 (cost=0.00..1.03 rows=1 width=29) (actual time=0.005..0.006 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 2
51. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200909 d_45 (cost=0.00..1.19 rows=1 width=55) (actual time=0.010..0.010 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 11
52. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200910 d_46 (cost=0.00..1.10 rows=1 width=157) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 6
53. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200911 d_47 (cost=0.00..1.07 rows=1 width=31) (actual time=0.008..0.009 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 4
54. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_200912 d_48 (cost=0.00..1.05 rows=1 width=39) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 3
55. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201001 d_49 (cost=0.00..1.14 rows=1 width=39) (actual time=0.010..0.010 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 8
56. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201002 d_50 (cost=0.00..1.33 rows=1 width=36) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 19
57. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201003 d_51 (cost=0.00..1.25 rows=1 width=35) (actual time=0.010..0.010 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 14
58. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201004 d_52 (cost=0.00..1.07 rows=1 width=34) (actual time=0.009..0.009 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 4
59. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201005 d_53 (cost=0.00..1.05 rows=1 width=36) (actual time=0.006..0.006 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 3
60. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201006 d_54 (cost=0.00..15.43 rows=2 width=48) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
61. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201007 d_55 (cost=0.00..1.03 rows=1 width=29) (actual time=0.006..0.006 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 2
62. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201008 d_56 (cost=0.00..1.03 rows=1 width=39) (actual time=0.008..0.009 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 2
63. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201009 d_57 (cost=0.00..15.43 rows=2 width=48) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
64. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201010 d_58 (cost=0.00..1.02 rows=1 width=59) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 1
65. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201011 d_59 (cost=0.00..1.02 rows=1 width=29) (actual time=0.005..0.006 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 1
66. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201012 d_60 (cost=0.00..1.05 rows=1 width=40) (actual time=0.008..0.008 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 3
67. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201101 d_61 (cost=0.00..1.10 rows=1 width=40) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 6
68. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201102 d_62 (cost=0.00..1.26 rows=1 width=51) (actual time=0.010..0.011 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 15
69. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201103 d_63 (cost=0.00..1.23 rows=1 width=29) (actual time=0.009..0.009 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 13
70. 0.016 0.016 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201104 d_64 (cost=0.00..1.52 rows=1 width=43) (actual time=0.016..0.016 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 30
71. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201105 d_65 (cost=0.00..1.05 rows=1 width=34) (actual time=0.006..0.006 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 3
72. 0.019 0.019 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201106 d_66 (cost=0.00..1.51 rows=1 width=68) (actual time=0.019..0.019 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 29
73. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201107 d_67 (cost=0.00..1.21 rows=1 width=65) (actual time=0.009..0.009 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 12
74. 0.014 0.014 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201108 d_68 (cost=0.00..1.39 rows=1 width=83) (actual time=0.014..0.014 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 22
75. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201109 d_69 (cost=0.00..1.10 rows=1 width=52) (actual time=0.009..0.010 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 6
76. 0.012 0.012 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201110 d_70 (cost=0.00..1.33 rows=1 width=60) (actual time=0.012..0.012 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 19
77. 0.016 0.016 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201111 d_71 (cost=0.00..1.63 rows=1 width=50) (actual time=0.016..0.016 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 36
78. 0.018 0.018 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201112 d_72 (cost=0.00..2.47 rows=1 width=39) (actual time=0.018..0.018 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 27
79. 0.016 0.016 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201201 d_73 (cost=0.00..1.56 rows=1 width=36) (actual time=0.015..0.016 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 32
80. 0.021 0.021 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201202 d_74 (cost=0.00..3.67 rows=1 width=70) (actual time=0.021..0.021 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 38
81. 0.016 0.016 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201203 d_75 (cost=0.00..2.46 rows=1 width=60) (actual time=0.016..0.016 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 26
82. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201204 d_76 (cost=0.00..1.12 rows=1 width=103) (actual time=0.009..0.009 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 7
83. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201205 d_77 (cost=0.00..1.30 rows=1 width=121) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 17
84. 0.014 0.014 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201206 d_78 (cost=0.00..1.44 rows=1 width=100) (actual time=0.014..0.014 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 25
85. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201207 d_79 (cost=0.00..1.21 rows=1 width=77) (actual time=0.010..0.010 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 12
86. 0.016 0.016 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201208 d_80 (cost=0.00..1.47 rows=1 width=33) (actual time=0.015..0.016 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 27
87. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201209 d_81 (cost=0.00..1.40 rows=1 width=79) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 23
88. 0.080 0.080 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201210 d_82 (cost=0.00..8.66 rows=1 width=78) (actual time=0.080..0.080 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 209
89. 0.102 0.102 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201211 d_83 (cost=0.00..12.43 rows=1 width=80) (actual time=0.101..0.102 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 253
90. 0.030 0.030 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201212 d_84 (cost=0.00..5.77 rows=1 width=77) (actual time=0.030..0.030 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 44
91. 0.038 0.038 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201301 d_85 (cost=0.00..10.05 rows=1 width=88) (actual time=0.038..0.038 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 60
92. 0.183 0.183 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201302 d_86 (cost=0.00..116.47 rows=1 width=89) (actual time=0.182..0.183 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 141
93. 0.311 0.311 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201303 d_87 (cost=0.00..113.56 rows=2 width=84) (actual time=0.311..0.311 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 489
94. 0.199 0.199 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201304 d_88 (cost=0.00..47.02 rows=2 width=72) (actual time=0.199..0.199 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 401
95. 0.139 0.139 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201305 d_89 (cost=0.00..30.14 rows=1 width=74) (actual time=0.138..0.139 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 294
96. 0.185 0.185 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201306 d_90 (cost=0.00..36.88 rows=2 width=69) (actual time=0.185..0.185 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 393
97. 0.201 0.201 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201307 d_91 (cost=0.00..57.37 rows=1 width=71) (actual time=0.201..0.201 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 307
98. 0.208 0.208 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201308 d_92 (cost=0.00..128.53 rows=1 width=82) (actual time=0.207..0.208 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 202
99. 0.202 0.202 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201309 d_93 (cost=0.00..143.32 rows=1 width=73) (actual time=0.202..0.202 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 190
100. 0.153 0.153 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201310 d_94 (cost=0.00..58.53 rows=1 width=70) (actual time=0.153..0.153 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 259
101. 0.095 0.095 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201311 d_95 (cost=0.00..38.57 rows=1 width=65) (actual time=0.095..0.095 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 147
102. 0.142 0.142 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201312 d_96 (cost=0.00..46.18 rows=1 width=77) (actual time=0.142..0.142 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 239
103. 0.103 0.103 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201401 d_97 (cost=0.00..43.66 rows=1 width=64) (actual time=0.103..0.103 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 152
104. 0.237 0.237 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201402 d_98 (cost=0.00..157.59 rows=1 width=67) (actual time=0.237..0.237 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 262
105. 0.436 0.436 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201403 d_99 (cost=0.00..376.13 rows=1 width=68) (actual time=0.435..0.436 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 236
106. 0.433 0.433 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201404 d_100 (cost=0.00..357.04 rows=1 width=68) (actual time=0.433..0.433 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 345
107. 0.511 0.511 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201405 d_101 (cost=0.00..427.57 rows=2 width=75) (actual time=0.511..0.511 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 490
108. 0.764 0.764 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201406 d_102 (cost=0.00..664.52 rows=4 width=80) (actual time=0.763..0.764 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 830
109. 3.621 3.621 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201407 d_103 (cost=0.00..807.97 rows=46 width=112) (actual time=3.621..3.621 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 9,141
110. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201408 d_104 (cost=0.00..15.43 rows=2 width=48) (actual time=0.006..0.006 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
111. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201409 d_105 (cost=0.00..1.03 rows=1 width=29) (actual time=0.009..0.009 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 2
112. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201410 d_106 (cost=0.00..15.43 rows=2 width=48) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
113. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201411 d_107 (cost=0.00..15.43 rows=2 width=48) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
114. 0.070 0.070 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201412 d_108 (cost=0.00..36.68 rows=1 width=44) (actual time=0.070..0.070 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 96
115. 0.635 0.635 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201501 d_109 (cost=0.00..298.26 rows=5 width=72) (actual time=0.635..0.635 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 1,215
116. 0.798 0.798 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201502 d_110 (cost=0.00..350.32 rows=6 width=71) (actual time=0.798..0.798 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 1,390
117. 0.544 0.544 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201503 d_111 (cost=0.00..170.09 rows=6 width=72) (actual time=0.544..0.544 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 1,262
118. 0.162 0.162 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201504 d_112 (cost=0.00..61.90 rows=1 width=68) (actual time=0.161..0.162 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 280
119. 0.177 0.177 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201505 d_113 (cost=0.00..59.90 rows=2 width=73) (actual time=0.177..0.177 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 337
120. 0.203 0.203 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201506 d_114 (cost=0.00..94.00 rows=2 width=52) (actual time=0.203..0.203 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 343
121. 0.232 0.232 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201507 d_115 (cost=0.00..125.21 rows=2 width=63) (actual time=0.232..0.232 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 355
122. 0.333 0.333 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201508 d_116 (cost=0.00..114.67 rows=3 width=55) (actual time=0.333..0.333 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 667
123. 0.279 0.279 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201509 d_117 (cost=0.00..59.39 rows=3 width=51) (actual time=0.279..0.279 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 651
124. 0.423 0.423 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201510 d_118 (cost=0.00..93.19 rows=5 width=50) (actual time=0.422..0.423 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 982
125. 0.393 0.393 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201511 d_119 (cost=0.00..105.30 rows=4 width=51) (actual time=0.393..0.393 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 874
126. 0.252 0.252 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201512 d_120 (cost=0.00..53.61 rows=3 width=51) (actual time=0.252..0.252 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 606
127. 0.460 0.460 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201601 d_121 (cost=0.00..56.10 rows=6 width=65) (actual time=0.460..0.460 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 1,263
128. 0.802 0.802 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201602 d_122 (cost=0.00..97.06 rows=11 width=68) (actual time=0.802..0.802 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 2,232
129. 0.673 0.673 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201603 d_123 (cost=0.00..89.15 rows=9 width=72) (actual time=0.673..0.673 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 1,837
130. 1.368 1.368 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201604 d_124 (cost=0.00..181.54 rows=18 width=72) (actual time=1.368..1.368 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 3,631
131. 0.627 0.627 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201605 d_125 (cost=0.00..79.31 rows=8 width=67) (actual time=0.627..0.627 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 1,789
132. 0.322 0.322 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201606 d_126 (cost=0.00..38.17 rows=4 width=66) (actual time=0.322..0.322 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 924
133. 0.733 0.733 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201607 d_127 (cost=0.00..85.99 rows=8 width=56) (actual time=0.733..0.733 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 2,171
134. 0.658 0.658 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201608 d_128 (cost=0.00..81.58 rows=9 width=64) (actual time=0.657..0.658 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 1,919
135. 0.371 0.371 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201609 d_129 (cost=0.00..44.94 rows=5 width=75) (actual time=0.371..0.371 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 1,082
136. 0.406 0.406 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201610 d_130 (cost=0.00..48.25 rows=6 width=69) (actual time=0.406..0.406 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 1,157
137. 0.513 0.513 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201611 d_131 (cost=0.00..57.83 rows=7 width=54) (actual time=0.513..0.513 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 1,533
138. 0.756 0.756 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201612 d_132 (cost=0.00..87.43 rows=10 width=54) (actual time=0.756..0.756 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 2,253
139. 0.198 0.198 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201702 d_133 (cost=0.00..32.79 rows=1 width=30) (actual time=0.198..0.198 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 731
140. 0.177 0.177 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201703 d_134 (cost=0.00..28.67 rows=1 width=31) (actual time=0.177..0.177 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 667
141. 0.228 0.228 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201704 d_135 (cost=0.00..29.68 rows=1 width=32) (actual time=0.228..0.228 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 610
142. 0.543 0.543 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201705 d_136 (cost=0.00..47.61 rows=1 width=41) (actual time=0.542..0.543 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 892
143. 0.519 0.519 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201706 d_137 (cost=0.00..62.02 rows=6 width=50) (actual time=0.519..0.519 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 1,544
144. 0.489 0.489 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201707 d_138 (cost=0.00..58.80 rows=7 width=48) (actual time=0.489..0.489 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 1,474
145. 0.490 0.490 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201708 d_139 (cost=0.00..66.78 rows=6 width=47) (actual time=0.490..0.490 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 1,473
146. 0.717 0.717 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201701 d_140 (cost=0.00..90.18 rows=10 width=52) (actual time=0.717..0.717 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 2,353
147. 0.817 0.817 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201709 d_141 (cost=0.00..133.41 rows=10 width=56) (actual time=0.817..0.817 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 2,252
148. 0.864 0.864 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201710 d_142 (cost=0.00..154.57 rows=10 width=62) (actual time=0.864..0.864 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 2,261
149. 0.633 0.633 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201711 d_143 (cost=0.00..141.38 rows=7 width=57) (actual time=0.633..0.633 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 1,622
150. 0.296 0.296 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201712 d_144 (cost=0.00..44.40 rows=4 width=59) (actual time=0.296..0.296 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 823
151. 0.689 0.689 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201801 d_145 (cost=0.00..129.64 rows=9 width=64) (actual time=0.689..0.689 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 1,865
152. 0.645 0.645 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201802 d_146 (cost=0.00..101.69 rows=8 width=62) (actual time=0.645..0.645 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 1,868
153. 0.482 0.482 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201803 d_147 (cost=0.00..75.97 rows=6 width=64) (actual time=0.482..0.482 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 1,370
154. 0.391 0.391 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201804 d_148 (cost=0.00..61.90 rows=5 width=86) (actual time=0.391..0.391 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 1,137
155. 0.627 0.627 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201805 d_149 (cost=0.00..89.94 rows=8 width=60) (actual time=0.627..0.627 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 1,711
156. 0.287 0.287 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201806 d_150 (cost=0.00..45.27 rows=3 width=63) (actual time=0.287..0.287 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 758
157. 0.212 0.212 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201807 d_151 (cost=0.00..31.24 rows=3 width=53) (actual time=0.212..0.212 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 585
158. 0.310 0.310 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201808 d_152 (cost=0.00..37.94 rows=4 width=55) (actual time=0.310..0.310 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 911
159. 0.159 0.159 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201809 d_153 (cost=0.00..19.80 rows=2 width=48) (actual time=0.159..0.159 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 446
160. 0.281 0.281 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201810 d_154 (cost=0.00..44.46 rows=4 width=55) (actual time=0.281..0.281 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 769
161. 0.128 0.128 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201811 d_155 (cost=0.00..18.11 rows=1 width=44) (actual time=0.128..0.128 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 349
162. 0.064 0.064 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201812 d_156 (cost=0.00..10.61 rows=1 width=44) (actual time=0.063..0.064 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 149
163. 0.081 0.081 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201901 d_157 (cost=0.00..17.34 rows=1 width=54) (actual time=0.081..0.081 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 191
164. 0.057 0.057 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201902 d_158 (cost=0.00..7.55 rows=1 width=40) (actual time=0.056..0.057 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 146
165. 0.046 0.046 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201903 d_159 (cost=0.00..5.82 rows=1 width=42) (actual time=0.046..0.046 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 104
166. 0.111 0.111 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201904 d_160 (cost=0.00..21.60 rows=1 width=49) (actual time=0.111..0.111 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 263
167. 0.059 0.059 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201905 d_161 (cost=0.00..9.12 rows=1 width=52) (actual time=0.059..0.059 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 121
168. 0.059 0.059 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201906 d_162 (cost=0.00..8.45 rows=1 width=41) (actual time=0.059..0.059 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 142
169. 0.064 0.064 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201907 d_163 (cost=0.00..8.57 rows=1 width=52) (actual time=0.063..0.064 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 148
170. 0.046 0.046 ↓ 0.0 0 1

Seq Scan on part_data_contracttime_days_201908 d_164 (cost=0.00..7.65 rows=1 width=51) (actual time=0.046..0.046 rows=0 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 94
171. 0.043 0.043 ↓ 2.0 2 1

Seq Scan on part_data_contracttime_days_201909 d_165 (cost=0.00..4.65 rows=1 width=37) (actual time=0.026..0.043 rows=2 loops=1)

  • Filter: (('{}'::smallint[] <> cells_offline) AND ((created_ts)::date = '2019-09-26'::date))
  • Rows Removed by Filter: 92
172. 0.022 0.022 ↑ 1.0 1 2

Index Scan using dim_assignments_pkey on dim_assignments a (cost=0.42..8.20 rows=1 width=32) (actual time=0.011..0.011 rows=1 loops=2)

  • Index Cond: (id = d.contract_id)
173. 0.016 0.016 ↑ 1.0 1 2

Index Scan using dim_companies_pkey on dim_companies c (cost=0.43..0.82 rows=1 width=30) (actual time=0.007..0.008 rows=1 loops=2)

  • Index Cond: (id = a.company_id)