explain.depesz.com

PostgreSQL's explain analyze made readable

Result: V5vO

Settings
# exclusive inclusive rows x rows loops node
1. 0.027 100,856.285 ↑ 26.3 7 1

WindowAgg (cost=3,374.83..3,380.81 rows=184 width=976) (actual time=100,856.281..100,856.285 rows=7 loops=1)

2.          

CTE base_3_0

3. 0.003 1,313.686 ↓ 0.0 0 1

WindowAgg (cost=77.88..78.28 rows=1 width=836) (actual time=1,313.686..1,313.686 rows=0 loops=1)

4. 0.042 1,313.683 ↓ 0.0 0 1

Sort (cost=77.88..77.88 rows=1 width=520) (actual time=1,313.683..1,313.683 rows=0 loops=1)

  • Sort Key: snapshot_supervision.project_id, (_st_distance(location.geo_point, '0101000020E61000000000002098CF4240000000609AE94B40'::geography, '0'::double precision, true))
  • Sort Method: quicksort Memory: 25kB
5. 0.001 1,313.641 ↓ 0.0 0 1

Nested Loop (cost=46.94..77.87 rows=1 width=520) (actual time=1,313.641..1,313.641 rows=0 loops=1)

6. 0.001 1,313.640 ↓ 0.0 0 1

Nested Loop (cost=46.79..76.51 rows=1 width=509) (actual time=1,313.640..1,313.640 rows=0 loops=1)

7. 0.001 1,313.639 ↓ 0.0 0 1

Nested Loop (cost=46.36..68.06 rows=1 width=388) (actual time=1,313.639..1,313.639 rows=0 loops=1)

8. 0.001 1,313.638 ↓ 0.0 0 1

Nested Loop (cost=45.93..59.62 rows=1 width=295) (actual time=1,313.638..1,313.638 rows=0 loops=1)

9. 0.001 1,313.637 ↓ 0.0 0 1

Nested Loop (cost=45.65..53.93 rows=1 width=249) (actual time=1,313.637..1,313.637 rows=0 loops=1)

10. 0.006 1,313.636 ↓ 0.0 0 1

Merge Join (cost=45.23..45.56 rows=1 width=149) (actual time=1,313.636..1,313.636 rows=0 loops=1)

  • Merge Cond: (control_subject.id = snapshot_supervision.control_subject_id)
11. 0.013 0.013 ↑ 250,357.0 1 1

Index Scan using control_subject_pkey on control_subject (cost=0.42..79,352.91 rows=250,357 width=36) (actual time=0.013..0.013 rows=1 loops=1)

12. 0.018 1,313.617 ↓ 0.0 0 1

Sort (cost=44.81..44.81 rows=1 width=121) (actual time=1,313.617..1,313.617 rows=0 loops=1)

  • Sort Key: snapshot_supervision.control_subject_id
  • Sort Method: quicksort Memory: 25kB
13. 0.000 1,313.599 ↓ 0.0 0 1

Nested Loop (cost=0.71..44.80 rows=1 width=121) (actual time=1,313.599..1,313.599 rows=0 loops=1)

14. 982.345 982.345 ↓ 182,145.0 182,145 1

Index Scan using location_gix on location (cost=0.29..8.68 rows=1 width=36) (actual time=1.100..982.345 rows=182,145 loops=1)

  • Index Cond: (geo_point && '0101000020E61000000000002098CF4240000000609AE94B40'::geography)
  • Filter: (('0101000020E61000000000002098CF4240000000609AE94B40'::geography && _st_expand(geo_point, '36110'::double precision)) AND _st_dwithin(geo_point, '0101000020E61000000000002098CF4240000000609AE94B40'::geography, '36110'::double precision, true))
  • Rows Removed by Filter: 84,610
15. 364.290 364.290 ↓ 0.0 0 182,145

Index Scan using index_snapshot_supervision_on_location_id on snapshot_supervision (cost=0.42..36.11 rows=1 width=93) (actual time=0.002..0.002 rows=0 loops=182,145)

  • Index Cond: (location_id = location.id)
  • Filter: ((actor_id = '-1'::integer) AND (actuality = 0) AND (visible_id = 1) AND (project_id = ANY ('{121559,340460,340460,341394,345598,98818,98810,98850,98802,100158,147380,158567,18,1558,4795}'::integer[])))
  • Rows Removed by Filter: 1
16. 0.000 0.000 ↓ 0.0 0

Index Scan using issue_pkey on issue (cost=0.42..8.37 rows=1 width=104) (never executed)

  • Index Cond: (id = snapshot_supervision.issue_id)
17. 0.000 0.000 ↓ 0.0 0

Index Scan using company_pkey on company (cost=0.29..5.68 rows=1 width=50) (never executed)

  • Index Cond: (id = snapshot_supervision.company_id)
18. 0.000 0.000 ↓ 0.0 0

Index Scan using issue_task_pkey on issue_task (cost=0.43..8.45 rows=1 width=93) (never executed)

  • Index Cond: (id = snapshot_supervision.issue_task_id)
19. 0.000 0.000 ↓ 0.0 0

Index Scan using execution_pkey on execution (cost=0.43..8.45 rows=1 width=125) (never executed)

  • Index Cond: (id = snapshot_supervision.execution_id)
20. 0.000 0.000 ↓ 0.0 0

Index Scan using stage_pkey on stage (cost=0.14..1.07 rows=1 width=11) (never executed)

  • Index Cond: (id = snapshot_supervision.stage_id)
  • Filter: ((kind = 0) AND (status_stage_id = 2) AND ((platform)::text = 'mb'::text))
21.          

CTE base_3_1

22. 0.626 1.506 ↓ 7.0 7 1

Nested Loop (cost=73.10..122.02 rows=1 width=820) (actual time=0.865..1.506 rows=7 loops=1)

23. 0.019 0.838 ↓ 7.0 7 1

Nested Loop (cost=72.96..113.38 rows=1 width=509) (actual time=0.377..0.838 rows=7 loops=1)

24. 0.015 0.623 ↓ 7.0 7 1

Nested Loop (cost=72.53..104.93 rows=1 width=388) (actual time=0.326..0.623 rows=7 loops=1)

25. 0.011 0.573 ↓ 7.0 7 1

Nested Loop (cost=72.10..96.49 rows=1 width=360) (actual time=0.304..0.573 rows=7 loops=1)

26. 0.014 0.401 ↓ 7.0 7 1

Nested Loop (cost=71.67..88.05 rows=1 width=267) (actual time=0.266..0.401 rows=7 loops=1)

27. 0.013 0.345 ↓ 7.0 7 1

Nested Loop (cost=71.39..79.74 rows=1 width=221) (actual time=0.231..0.345 rows=7 loops=1)

28. 0.017 0.192 ↓ 7.0 7 1

Merge Join (cost=70.97..71.30 rows=1 width=121) (actual time=0.171..0.192 rows=7 loops=1)

  • Merge Cond: (control_subject_1.id = snapshot_supervision_1.control_subject_id)
29. 0.030 0.030 ↑ 125,178.5 2 1

Index Scan using control_subject_pkey on control_subject control_subject_1 (cost=0.42..79,352.91 rows=250,357 width=36) (actual time=0.019..0.030 rows=2 loops=1)

30. 0.029 0.145 ↓ 7.0 7 1

Sort (cost=70.55..70.55 rows=1 width=93) (actual time=0.144..0.145 rows=7 loops=1)

  • Sort Key: snapshot_supervision_1.control_subject_id
  • Sort Method: quicksort Memory: 26kB
31. 0.116 0.116 ↓ 7.0 7 1

Index Scan using snapshot_supervision_actor_id_project_id_actuality_visible_id_i on snapshot_supervision snapshot_supervision_1 (cost=0.42..70.54 rows=1 width=93) (actual time=0.084..0.116 rows=7 loops=1)

  • Index Cond: ((actor_id = 46) AND (project_id = ANY ('{121559,340460,340460,341394,345598,98818,98810,98850,98802,100158,147380,158567,18,1558,4795}'::integer[])) AND (actuality = 0) AND (visible_id = 1))
32. 0.140 0.140 ↑ 1.0 1 7

Index Scan using issue_pkey on issue issue_1 (cost=0.42..8.44 rows=1 width=104) (actual time=0.020..0.020 rows=1 loops=7)

  • Index Cond: (id = snapshot_supervision_1.issue_id)
33. 0.042 0.042 ↑ 1.0 1 7

Index Scan using company_pkey on company company_1 (cost=0.29..8.30 rows=1 width=50) (actual time=0.006..0.006 rows=1 loops=7)

  • Index Cond: (id = snapshot_supervision_1.company_id)
34. 0.161 0.161 ↑ 1.0 1 7

Index Scan using issue_task_pkey on issue_task issue_task_1 (cost=0.43..8.45 rows=1 width=93) (actual time=0.023..0.023 rows=1 loops=7)

  • Index Cond: (id = snapshot_supervision_1.issue_task_id)
35. 0.035 0.035 ↑ 1.0 1 7

Index Scan using location_pkey on location location_1 (cost=0.42..8.44 rows=1 width=36) (actual time=0.005..0.005 rows=1 loops=7)

  • Index Cond: (id = snapshot_supervision_1.location_id)
36. 0.196 0.196 ↑ 1.0 1 7

Index Scan using execution_pkey on execution execution_1 (cost=0.43..8.45 rows=1 width=125) (actual time=0.028..0.028 rows=1 loops=7)

  • Index Cond: (id = snapshot_supervision_1.execution_id)
37. 0.042 0.042 ↑ 1.0 1 7

Index Scan using stage_pkey on stage stage_1 (cost=0.14..8.17 rows=1 width=11) (actual time=0.006..0.006 rows=1 loops=7)

  • Index Cond: (id = snapshot_supervision_1.stage_id)
  • Filter: ((kind = 0) AND (status_stage_id = 2) AND ((platform)::text = 'mb'::text))
38.          

CTE base_3

39. 0.005 1,315.234 ↓ 3.5 7 1

Append (cost=0.00..0.07 rows=2 width=824) (actual time=1,314.568..1,315.234 rows=7 loops=1)

40. 1,313.688 1,313.688 ↓ 0.0 0 1

CTE Scan on base_3_0 (cost=0.00..0.02 rows=1 width=824) (actual time=1,313.687..1,313.688 rows=0 loops=1)

41. 0.010 1.541 ↓ 7.0 7 1

Subquery Scan on *SELECT* 2 (cost=0.00..0.03 rows=1 width=824) (actual time=0.877..1.541 rows=7 loops=1)

42. 1.531 1.531 ↓ 7.0 7 1

CTE Scan on base_3_1 (cost=0.00..0.02 rows=1 width=820) (actual time=0.872..1.531 rows=7 loops=1)

43.          

CTE project_121559

44. 1,315.261 1,315.261 ↓ 0.0 0 1

CTE Scan on base_3 (cost=0.00..0.04 rows=1 width=968) (actual time=1,315.261..1,315.261 rows=0 loops=1)

  • Filter: (project = '121559'::text)
  • Rows Removed by Filter: 7
45.          

CTE project_340460

46. 0.005 0.005 ↓ 0.0 0 1

CTE Scan on base_3 base_3_2 (cost=0.00..0.04 rows=1 width=968) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: (project = '340460'::text)
  • Rows Removed by Filter: 7
47.          

CTE project_341394

48. 0.005 0.005 ↓ 0.0 0 1

CTE Scan on base_3 base_3_3 (cost=0.00..0.04 rows=1 width=968) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: (project = '341394'::text)
  • Rows Removed by Filter: 7
49.          

CTE project_345598

50. 0.004 0.004 ↓ 0.0 0 1

CTE Scan on base_3 base_3_4 (cost=0.00..0.04 rows=1 width=968) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (project = '345598'::text)
  • Rows Removed by Filter: 7
51.          

CTE project_98818

52. 0.008 0.008 ↑ 1.0 1 1

CTE Scan on base_3 base_3_5 (cost=0.00..0.04 rows=1 width=968) (actual time=0.006..0.008 rows=1 loops=1)

  • Filter: (project = '98818'::text)
  • Rows Removed by Filter: 6
53.          

CTE project_98810

54. 0.004 0.004 ↓ 0.0 0 1

CTE Scan on base_3 base_3_6 (cost=0.00..0.04 rows=1 width=968) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (project = '98810'::text)
  • Rows Removed by Filter: 7
55.          

CTE project_98850

56. 0.008 0.008 ↑ 1.0 1 1

CTE Scan on base_3 base_3_7 (cost=0.00..0.04 rows=1 width=968) (actual time=0.006..0.008 rows=1 loops=1)

  • Filter: (project = '98850'::text)
  • Rows Removed by Filter: 6
57.          

CTE project_98802

58. 0.004 0.004 ↓ 0.0 0 1

CTE Scan on base_3 base_3_8 (cost=0.00..0.04 rows=1 width=968) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (project = '98802'::text)
  • Rows Removed by Filter: 7
59.          

CTE project_100158

60. 0.003 0.003 ↓ 0.0 0 1

CTE Scan on base_3 base_3_9 (cost=0.00..0.04 rows=1 width=968) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (project = '100158'::text)
  • Rows Removed by Filter: 7
61.          

CTE project_147380

62. 0.008 0.008 ↓ 4.0 4 1

CTE Scan on base_3 base_3_10 (cost=0.00..0.04 rows=1 width=968) (actual time=0.005..0.008 rows=4 loops=1)

  • Filter: (project = '147380'::text)
  • Rows Removed by Filter: 3
63.          

CTE project_158567

64. 0.007 0.007 ↑ 1.0 1 1

CTE Scan on base_3 base_3_11 (cost=0.00..0.04 rows=1 width=968) (actual time=0.007..0.007 rows=1 loops=1)

  • Filter: (project = '158567'::text)
  • Rows Removed by Filter: 6
65.          

CTE project_18

66. 0.004 0.004 ↓ 0.0 0 1

CTE Scan on base_3 base_3_12 (cost=0.00..0.04 rows=1 width=968) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (project = '18'::text)
  • Rows Removed by Filter: 7
67.          

CTE project_1558

68. 0.004 0.004 ↓ 0.0 0 1

CTE Scan on base_3 base_3_13 (cost=0.00..0.04 rows=1 width=968) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (project = '1558'::text)
  • Rows Removed by Filter: 7
69.          

CTE project_4795

70. 0.004 0.004 ↓ 0.0 0 1

CTE Scan on base_3 base_3_14 (cost=0.00..0.04 rows=1 width=968) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (project = '4795'::text)
  • Rows Removed by Filter: 7
71.          

CTE base_7_0

72. 0.004 0.510 ↓ 0.0 0 1

WindowAgg (cost=867.48..867.90 rows=1 width=1,088) (actual time=0.510..0.510 rows=0 loops=1)

73. 0.011 0.506 ↓ 0.0 0 1

Sort (cost=867.48..867.48 rows=1 width=778) (actual time=0.506..0.506 rows=0 loops=1)

  • Sort Key: snapshot_inquiry_control.project_id, (_st_distance(location_2.geo_point, '0101000020E61000000000002098CF4240000000609AE94B40'::geography, '0'::double precision, true))
  • Sort Method: quicksort Memory: 25kB
74. 0.001 0.495 ↓ 0.0 0 1

Nested Loop (cost=2.96..867.47 rows=1 width=778) (actual time=0.495..0.495 rows=0 loops=1)

75. 0.000 0.494 ↓ 0.0 0 1

Nested Loop (cost=2.52..858.77 rows=1 width=649) (actual time=0.494..0.494 rows=0 loops=1)

  • Join Filter: (snapshot_inquiry_control.stage_id = stage_2.id)
76. 0.001 0.494 ↓ 0.0 0 1

Nested Loop (cost=2.52..844.66 rows=1 width=584) (actual time=0.494..0.494 rows=0 loops=1)

  • Join Filter: (snapshot_inquiry_control.location_id = location_2.id)
77. 0.000 0.493 ↓ 0.0 0 1

Nested Loop (cost=2.24..835.96 rows=1 width=556) (actual time=0.493..0.493 rows=0 loops=1)

78. 0.001 0.493 ↓ 0.0 0 1

Nested Loop (cost=1.82..827.53 rows=1 width=456) (actual time=0.493..0.493 rows=0 loops=1)

79. 0.000 0.492 ↓ 0.0 0 1

Nested Loop (cost=1.40..819.09 rows=1 width=327) (actual time=0.492..0.492 rows=0 loops=1)

80. 0.001 0.492 ↓ 0.0 0 1

Nested Loop (cost=1.13..810.76 rows=1 width=163) (actual time=0.492..0.492 rows=0 loops=1)

81. 0.000 0.491 ↓ 0.0 0 1

Nested Loop (cost=0.84..802.45 rows=1 width=117) (actual time=0.491..0.491 rows=0 loops=1)

  • Join Filter: (snapshot_inquiry_control.overdue_id = overdue.id)
82. 0.001 0.491 ↓ 0.0 0 1

Nested Loop (cost=0.84..801.39 rows=1 width=85) (actual time=0.491..0.491 rows=0 loops=1)

83. 0.490 0.490 ↓ 0.0 0 1

Index Scan using snapshot_inquiry_control_project_id_actor_id_visible_id_actuali on snapshot_inquiry_control (cost=0.42..792.95 rows=1 width=72) (actual time=0.490..0.490 rows=0 loops=1)

  • Index Cond: ((project_id = ANY ('{95455,95456,95457,95458,95459,95460,95461,95462,95463,95464,96187,96188,96189,96190,96191,96192,96193,96194,96195,96196,96197,96198,96199,96200,96201,96202,96203,97087,97088,97089,97090,97091,97092,97093,97094,97095,97096,97097,97098,97100,97101,97102,97103,97987,97988,97989,97990,97991,97992,97993,97994,97995,97996,97997,97998,98000,98001,98002,98003,95454,97099,235987,98885,98886,98887,98888,98889,98890,98891,98892,98893,98894,98905,98906,98907,98908,98909,98910,98911,98912,98913,98914,98925,98926,98927,98928,98929,98930,98931,98932,98933,98934,316969,317077,317328,317223,95453,158440,158493,158546,97999,319128,319129,319130,319131,319132,319133,319134,319135,319136,319137,319138,319139,319140,319141,319142,319143,319144,319145,319146,319147,319148,319149,319150,319151,319152,319153,319154,319155,319156,319157,319158,319159,319160,319161,319162,319163,319164,319165,319166,319167,319168,319169,319170,319171,319172,319173,319174,319175,319176,319177,319178,319179,319180,319181,319182,319183,319184,319185,319186,319187,319188,319189,319190,319191,319192,319193,319194,319195,319196,319197,319198,319199,319200,319201,319202,319203,319204,319205,319206,319207,319208,319209,319210,319211}'::integer[])) AND (actor_id = '-1'::integer) AND (visible_id = 1) AND (actuality = 0))
84. 0.000 0.000 ↓ 0.0 0

Index Scan using inquire_pkey on inquire (cost=0.42..8.44 rows=1 width=17) (never executed)

  • Index Cond: (id = snapshot_inquiry_control.inquiry_id)
85. 0.000 0.000 ↓ 0.0 0

Seq Scan on overdue (cost=0.00..1.03 rows=3 width=36) (never executed)

86. 0.000 0.000 ↓ 0.0 0

Index Scan using company_pkey on company company_2 (cost=0.29..8.30 rows=1 width=50) (never executed)

  • Index Cond: (id = snapshot_inquiry_control.company_id)
87. 0.000 0.000 ↓ 0.0 0

Index Scan using inquiry_subcategory_pkey on inquiry_subcategory (cost=0.27..8.29 rows=1 width=168) (never executed)

  • Index Cond: (id = snapshot_inquiry_control.inquiry_subcategory_id)
88. 0.000 0.000 ↓ 0.0 0

Index Scan using control_subject_pkey on control_subject control_subject_2 (cost=0.42..8.44 rows=1 width=133) (never executed)

  • Index Cond: (id = snapshot_inquiry_control.control_subject_id)
89. 0.000 0.000 ↓ 0.0 0

Index Scan using place_pkey on place (cost=0.42..8.44 rows=1 width=108) (never executed)

  • Index Cond: (id = snapshot_inquiry_control.place_id)
90. 0.000 0.000 ↓ 0.0 0

Index Scan using location_gix on location location_2 (cost=0.29..8.68 rows=1 width=36) (never executed)

  • Index Cond: (geo_point && '0101000020E61000000000002098CF4240000000609AE94B40'::geography)
  • Filter: (('0101000020E61000000000002098CF4240000000609AE94B40'::geography && _st_expand(geo_point, '36110'::double precision)) AND _st_dwithin(geo_point, '0101000020E61000000000002098CF4240000000609AE94B40'::geography, '36110'::double precision, true))
91. 0.000 0.000 ↓ 0.0 0

Seq Scan on stage stage_2 (cost=0.00..13.54 rows=46 width=73) (never executed)

  • Filter: ((kind = 0) AND (status_stage_id = 2) AND ((platform)::text = 'mb'::text))
92. 0.000 0.000 ↓ 0.0 0

Index Scan using execution_pkey on execution execution_2 (cost=0.43..8.45 rows=1 width=125) (never executed)

  • Index Cond: (id = snapshot_inquiry_control.execution_id)
93.          

CTE base_7_1

94. 0.000 0.457 ↓ 0.0 0 1

Nested Loop (cost=3.09..867.12 rows=1 width=1,072) (actual time=0.457..0.457 rows=0 loops=1)

95. 0.004 0.457 ↓ 0.0 0 1

Nested Loop (cost=2.66..858.52 rows=1 width=649) (actual time=0.457..0.457 rows=0 loops=1)

  • Join Filter: (snapshot_inquiry_control_1.stage_id = stage_3.id)
  • Rows Removed by Join Filter: 46
96. 0.005 0.353 ↑ 1.0 1 1

Nested Loop (cost=2.66..844.41 rows=1 width=584) (actual time=0.169..0.353 rows=1 loops=1)

97. 0.004 0.342 ↑ 1.0 1 1

Nested Loop (cost=2.24..835.96 rows=1 width=556) (actual time=0.159..0.342 rows=1 loops=1)

98. 0.004 0.307 ↑ 1.0 1 1

Nested Loop (cost=1.82..827.53 rows=1 width=456) (actual time=0.124..0.307 rows=1 loops=1)

99. 0.003 0.294 ↑ 1.0 1 1

Nested Loop (cost=1.40..819.09 rows=1 width=327) (actual time=0.111..0.294 rows=1 loops=1)

100. 0.004 0.276 ↑ 1.0 1 1

Nested Loop (cost=1.13..810.76 rows=1 width=163) (actual time=0.093..0.276 rows=1 loops=1)

101. 0.004 0.264 ↑ 1.0 1 1

Nested Loop (cost=0.84..802.45 rows=1 width=117) (actual time=0.080..0.264 rows=1 loops=1)

  • Join Filter: (snapshot_inquiry_control_1.overdue_id = overdue_1.id)
  • Rows Removed by Join Filter: 1
102. 0.008 0.252 ↑ 1.0 1 1

Nested Loop (cost=0.84..801.39 rows=1 width=85) (actual time=0.069..0.252 rows=1 loops=1)

103. 0.216 0.216 ↑ 1.0 1 1

Index Scan using snapshot_inquiry_control_project_id_actor_id_visible_id_actuali on snapshot_inquiry_control snapshot_inquiry_control_1 (cost=0.42..792.95 rows=1 width=72) (actual time=0.033..0.216 rows=1 loops=1)

  • Index Cond: ((project_id = ANY ('{95455,95456,95457,95458,95459,95460,95461,95462,95463,95464,96187,96188,96189,96190,96191,96192,96193,96194,96195,96196,96197,96198,96199,96200,96201,96202,96203,97087,97088,97089,97090,97091,97092,97093,97094,97095,97096,97097,97098,97100,97101,97102,97103,97987,97988,97989,97990,97991,97992,97993,97994,97995,97996,97997,97998,98000,98001,98002,98003,95454,97099,235987,98885,98886,98887,98888,98889,98890,98891,98892,98893,98894,98905,98906,98907,98908,98909,98910,98911,98912,98913,98914,98925,98926,98927,98928,98929,98930,98931,98932,98933,98934,316969,317077,317328,317223,95453,158440,158493,158546,97999,319128,319129,319130,319131,319132,319133,319134,319135,319136,319137,319138,319139,319140,319141,319142,319143,319144,319145,319146,319147,319148,319149,319150,319151,319152,319153,319154,319155,319156,319157,319158,319159,319160,319161,319162,319163,319164,319165,319166,319167,319168,319169,319170,319171,319172,319173,319174,319175,319176,319177,319178,319179,319180,319181,319182,319183,319184,319185,319186,319187,319188,319189,319190,319191,319192,319193,319194,319195,319196,319197,319198,319199,319200,319201,319202,319203,319204,319205,319206,319207,319208,319209,319210,319211}'::integer[])) AND (actor_id = 46) AND (visible_id = 1) AND (actuality = 0))
104. 0.028 0.028 ↑ 1.0 1 1

Index Scan using inquire_pkey on inquire inquire_1 (cost=0.42..8.44 rows=1 width=17) (actual time=0.028..0.028 rows=1 loops=1)

  • Index Cond: (id = snapshot_inquiry_control_1.inquiry_id)
105. 0.008 0.008 ↑ 1.5 2 1

Seq Scan on overdue overdue_1 (cost=0.00..1.03 rows=3 width=36) (actual time=0.008..0.008 rows=2 loops=1)

106. 0.008 0.008 ↑ 1.0 1 1

Index Scan using company_pkey on company company_3 (cost=0.29..8.30 rows=1 width=50) (actual time=0.008..0.008 rows=1 loops=1)

  • Index Cond: (id = snapshot_inquiry_control_1.company_id)
107. 0.015 0.015 ↑ 1.0 1 1

Index Scan using inquiry_subcategory_pkey on inquiry_subcategory inquiry_subcategory_1 (cost=0.27..8.29 rows=1 width=168) (actual time=0.014..0.015 rows=1 loops=1)

  • Index Cond: (id = snapshot_inquiry_control_1.inquiry_subcategory_id)
108. 0.009 0.009 ↑ 1.0 1 1

Index Scan using control_subject_pkey on control_subject control_subject_3 (cost=0.42..8.44 rows=1 width=133) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: (id = snapshot_inquiry_control_1.control_subject_id)
109. 0.031 0.031 ↑ 1.0 1 1

Index Scan using place_pkey on place place_1 (cost=0.42..8.44 rows=1 width=108) (actual time=0.031..0.031 rows=1 loops=1)

  • Index Cond: (id = snapshot_inquiry_control_1.place_id)
110. 0.006 0.006 ↑ 1.0 1 1

Index Scan using location_pkey on location location_3 (cost=0.42..8.44 rows=1 width=36) (actual time=0.006..0.006 rows=1 loops=1)

  • Index Cond: (id = snapshot_inquiry_control_1.location_id)
111. 0.100 0.100 ↑ 1.0 46 1

Seq Scan on stage stage_3 (cost=0.00..13.54 rows=46 width=73) (actual time=0.011..0.100 rows=46 loops=1)

  • Filter: ((kind = 0) AND (status_stage_id = 2) AND ((platform)::text = 'mb'::text))
  • Rows Removed by Filter: 100
112. 0.000 0.000 ↓ 0.0 0

Index Scan using execution_pkey on execution execution_3 (cost=0.43..8.45 rows=1 width=125) (never executed)

  • Index Cond: (id = snapshot_inquiry_control_1.execution_id)
113.          

CTE base_7

114. 0.003 0.973 ↓ 0.0 0 1

Append (cost=0.00..0.07 rows=2 width=1,076) (actual time=0.973..0.973 rows=0 loops=1)

115. 0.511 0.511 ↓ 0.0 0 1

CTE Scan on base_7_0 (cost=0.00..0.02 rows=1 width=1,076) (actual time=0.511..0.511 rows=0 loops=1)

116. 0.001 0.459 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2_1 (cost=0.00..0.03 rows=1 width=1,076) (actual time=0.459..0.459 rows=0 loops=1)

117. 0.458 0.458 ↓ 0.0 0 1

CTE Scan on base_7_1 (cost=0.00..0.02 rows=1 width=1,072) (actual time=0.458..0.458 rows=0 loops=1)

118.          

CTE project_95455

119. 0.975 0.975 ↓ 0.0 0 1

CTE Scan on base_7 (cost=0.00..0.04 rows=1 width=968) (actual time=0.975..0.975 rows=0 loops=1)

  • Filter: (project = '95455'::text)
120.          

CTE project_95456

121. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_2 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '95456'::text)
122.          

CTE project_95457

123. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_3 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '95457'::text)
124.          

CTE project_95458

125. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_4 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '95458'::text)
126.          

CTE project_95459

127. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_7 base_7_5 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '95459'::text)
128.          

CTE project_95460

129. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_6 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '95460'::text)
130.          

CTE project_95461

131. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_7 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '95461'::text)
132.          

CTE project_95462

133. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_8 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '95462'::text)
134.          

CTE project_95463

135. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_7 base_7_9 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '95463'::text)
136.          

CTE project_95464

137. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_7 base_7_10 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '95464'::text)
138.          

CTE project_96187

139. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_11 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '96187'::text)
140.          

CTE project_96188

141. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_12 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '96188'::text)
142.          

CTE project_96189

143. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_13 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '96189'::text)
144.          

CTE project_96190

145. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_14 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '96190'::text)
146.          

CTE project_96191

147. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_15 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '96191'::text)
148.          

CTE project_96192

149. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_16 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '96192'::text)
150.          

CTE project_96193

151. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_17 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '96193'::text)
152.          

CTE project_96194

153. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_18 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '96194'::text)
154.          

CTE project_96195

155. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_19 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '96195'::text)
156.          

CTE project_96196

157. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_20 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '96196'::text)
158.          

CTE project_96197

159. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_7 base_7_21 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '96197'::text)
160.          

CTE project_96198

161. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_22 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '96198'::text)
162.          

CTE project_96199

163. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_23 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '96199'::text)
164.          

CTE project_96200

165. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_24 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '96200'::text)
166.          

CTE project_96201

167. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_7 base_7_25 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '96201'::text)
168.          

CTE project_96202

169. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_26 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '96202'::text)
170.          

CTE project_96203

171. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_27 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '96203'::text)
172.          

CTE project_97087

173. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_28 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '97087'::text)
174.          

CTE project_97088

175. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_29 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '97088'::text)
176.          

CTE project_97089

177. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_7 base_7_30 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '97089'::text)
178.          

CTE project_97090

179. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_31 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '97090'::text)
180.          

CTE project_97091

181. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_32 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '97091'::text)
182.          

CTE project_97092

183. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_33 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '97092'::text)
184.          

CTE project_97093

185. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_34 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '97093'::text)
186.          

CTE project_97094

187. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_35 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '97094'::text)
188.          

CTE project_97095

189. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_36 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '97095'::text)
190.          

CTE project_97096

191. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_7 base_7_37 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '97096'::text)
192.          

CTE project_97097

193. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_7 base_7_38 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '97097'::text)
194.          

CTE project_97098

195. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_39 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '97098'::text)
196.          

CTE project_97100

197. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_40 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '97100'::text)
198.          

CTE project_97101

199. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_7 base_7_41 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '97101'::text)
200.          

CTE project_97102

201. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_42 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '97102'::text)
202.          

CTE project_97103

203. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_43 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '97103'::text)
204.          

CTE project_97987

205. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_44 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '97987'::text)
206.          

CTE project_97988

207. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_7 base_7_45 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '97988'::text)
208.          

CTE project_97989

209. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_7 base_7_46 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '97989'::text)
210.          

CTE project_97990

211. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_47 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '97990'::text)
212.          

CTE project_97991

213. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_48 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '97991'::text)
214.          

CTE project_97992

215. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_7 base_7_49 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '97992'::text)
216.          

CTE project_97993

217. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_50 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '97993'::text)
218.          

CTE project_97994

219. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_51 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '97994'::text)
220.          

CTE project_97995

221. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_52 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '97995'::text)
222.          

CTE project_97996

223. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_53 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '97996'::text)
224.          

CTE project_97997

225. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_7 base_7_54 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '97997'::text)
226.          

CTE project_97998

227. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_55 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '97998'::text)
228.          

CTE project_98000

229. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_56 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '98000'::text)
230.          

CTE project_98001

231. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_57 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '98001'::text)
232.          

CTE project_98002

233. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_58 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '98002'::text)
234.          

CTE project_98003

235. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_59 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '98003'::text)
236.          

CTE project_95454

237. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_60 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '95454'::text)
238.          

CTE project_97099

239. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_61 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '97099'::text)
240.          

CTE project_235987

241. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_62 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '235987'::text)
242.          

CTE project_98885

243. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_63 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '98885'::text)
244.          

CTE project_98886

245. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_64 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '98886'::text)
246.          

CTE project_98887

247. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_65 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '98887'::text)
248.          

CTE project_98888

249. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_66 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '98888'::text)
250.          

CTE project_98889

251. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_67 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '98889'::text)
252.          

CTE project_98890

253. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_68 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '98890'::text)
254.          

CTE project_98891

255. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_7 base_7_69 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '98891'::text)
256.          

CTE project_98892

257. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_70 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '98892'::text)
258.          

CTE project_98893

259. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_71 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '98893'::text)
260.          

CTE project_98894

261. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_72 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '98894'::text)
262.          

CTE project_98905

263. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_7 base_7_73 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '98905'::text)
264.          

CTE project_98906

265. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_74 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '98906'::text)
266.          

CTE project_98907

267. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_75 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '98907'::text)
268.          

CTE project_98908

269. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_76 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '98908'::text)
270.          

CTE project_98909

271. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_77 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '98909'::text)
272.          

CTE project_98910

273. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_78 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '98910'::text)
274.          

CTE project_98911

275. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_79 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '98911'::text)
276.          

CTE project_98912

277. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_80 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '98912'::text)
278.          

CTE project_98913

279. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_81 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '98913'::text)
280.          

CTE project_98914

281. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_82 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '98914'::text)
282.          

CTE project_98925

283. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_7 base_7_83 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '98925'::text)
284.          

CTE project_98926

285. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_84 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '98926'::text)
286.          

CTE project_98927

287. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_85 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '98927'::text)
288.          

CTE project_98928

289. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_86 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '98928'::text)
290.          

CTE project_98929

291. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_87 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '98929'::text)
292.          

CTE project_98930

293. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_88 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '98930'::text)
294.          

CTE project_98931

295. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_7 base_7_89 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '98931'::text)
296.          

CTE project_98932

297. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_90 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '98932'::text)
298.          

CTE project_98933

299. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_7 base_7_91 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '98933'::text)
300.          

CTE project_98934

301. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_7 base_7_92 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '98934'::text)
302.          

CTE project_316969

303. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_93 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '316969'::text)
304.          

CTE project_317077

305. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_94 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '317077'::text)
306.          

CTE project_317328

307. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_95 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '317328'::text)
308.          

CTE project_317223

309. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_96 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '317223'::text)
310.          

CTE project_95453

311. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_7 base_7_97 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '95453'::text)
312.          

CTE project_158440

313. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_7 base_7_98 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '158440'::text)
314.          

CTE project_158493

315. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_99 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '158493'::text)
316.          

CTE project_158546

317. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_100 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '158546'::text)
318.          

CTE project_97999

319. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_7 base_7_101 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '97999'::text)
320.          

CTE project_319128

321. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_102 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '319128'::text)
322.          

CTE project_319129

323. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_103 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319129'::text)
324.          

CTE project_319130

325. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_104 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319130'::text)
326.          

CTE project_319131

327. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_105 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319131'::text)
328.          

CTE project_319132

329. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_106 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '319132'::text)
330.          

CTE project_319133

331. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_107 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319133'::text)
332.          

CTE project_319134

333. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_7 base_7_108 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '319134'::text)
334.          

CTE project_319135

335. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_109 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319135'::text)
336.          

CTE project_319136

337. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_110 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '319136'::text)
338.          

CTE project_319137

339. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_111 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319137'::text)
340.          

CTE project_319138

341. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_7 base_7_112 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '319138'::text)
342.          

CTE project_319139

343. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_7 base_7_113 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '319139'::text)
344.          

CTE project_319140

345. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_114 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319140'::text)
346.          

CTE project_319141

347. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_115 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319141'::text)
348.          

CTE project_319142

349. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_116 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319142'::text)
350.          

CTE project_319143

351. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_117 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '319143'::text)
352.          

CTE project_319144

353. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_118 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319144'::text)
354.          

CTE project_319145

355. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_119 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319145'::text)
356.          

CTE project_319146

357. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_7 base_7_120 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '319146'::text)
358.          

CTE project_319147

359. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_121 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '319147'::text)
360.          

CTE project_319148

361. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_122 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '319148'::text)
362.          

CTE project_319149

363. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_123 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319149'::text)
364.          

CTE project_319150

365. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_7 base_7_124 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '319150'::text)
366.          

CTE project_319151

367. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_125 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319151'::text)
368.          

CTE project_319152

369. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_126 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '319152'::text)
370.          

CTE project_319153

371. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_127 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319153'::text)
372.          

CTE project_319154

373. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_128 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '319154'::text)
374.          

CTE project_319155

375. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_129 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319155'::text)
376.          

CTE project_319156

377. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_130 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319156'::text)
378.          

CTE project_319157

379. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_131 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '319157'::text)
380.          

CTE project_319158

381. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_132 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319158'::text)
382.          

CTE project_319159

383. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_7 base_7_133 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '319159'::text)
384.          

CTE project_319160

385. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_134 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '319160'::text)
386.          

CTE project_319161

387. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_135 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319161'::text)
388.          

CTE project_319162

389. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_136 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '319162'::text)
390.          

CTE project_319163

391. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_137 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319163'::text)
392.          

CTE project_319164

393. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_138 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319164'::text)
394.          

CTE project_319165

395. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_139 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319165'::text)
396.          

CTE project_319166

397. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_140 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319166'::text)
398.          

CTE project_319167

399. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_141 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319167'::text)
400.          

CTE project_319168

401. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_142 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '319168'::text)
402.          

CTE project_319169

403. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_7 base_7_143 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '319169'::text)
404.          

CTE project_319170

405. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_7 base_7_144 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '319170'::text)
406.          

CTE project_319171

407. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_7 base_7_145 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '319171'::text)
408.          

CTE project_319172

409. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_146 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319172'::text)
410.          

CTE project_319173

411. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_147 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319173'::text)
412.          

CTE project_319174

413. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_148 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '319174'::text)
414.          

CTE project_319175

415. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_149 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319175'::text)
416.          

CTE project_319176

417. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_150 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '319176'::text)
418.          

CTE project_319177

419. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_151 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319177'::text)
420.          

CTE project_319178

421. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_152 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319178'::text)
422.          

CTE project_319179

423. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_7 base_7_153 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '319179'::text)
424.          

CTE project_319180

425. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_154 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319180'::text)
426.          

CTE project_319181

427. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_155 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319181'::text)
428.          

CTE project_319182

429. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_156 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '319182'::text)
430.          

CTE project_319183

431. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_157 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319183'::text)
432.          

CTE project_319184

433. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_158 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319184'::text)
434.          

CTE project_319185

435. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_159 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319185'::text)
436.          

CTE project_319186

437. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_160 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319186'::text)
438.          

CTE project_319187

439. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_7 base_7_161 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '319187'::text)
440.          

CTE project_319188

441. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_162 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '319188'::text)
442.          

CTE project_319189

443. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_163 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319189'::text)
444.          

CTE project_319190

445. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_164 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319190'::text)
446.          

CTE project_319191

447. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_165 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '319191'::text)
448.          

CTE project_319192

449. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_166 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '319192'::text)
450.          

CTE project_319193

451. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_167 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319193'::text)
452.          

CTE project_319194

453. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_168 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '319194'::text)
454.          

CTE project_319195

455. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_169 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319195'::text)
456.          

CTE project_319196

457. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_170 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319196'::text)
458.          

CTE project_319197

459. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_7 base_7_171 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '319197'::text)
460.          

CTE project_319198

461. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_7 base_7_172 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '319198'::text)
462.          

CTE project_319199

463. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_173 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319199'::text)
464.          

CTE project_319200

465. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_174 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '319200'::text)
466.          

CTE project_319201

467. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_175 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '319201'::text)
468.          

CTE project_319202

469. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_176 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319202'::text)
470.          

CTE project_319203

471. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_7 base_7_177 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '319203'::text)
472.          

CTE project_319204

473. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_7 base_7_178 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '319204'::text)
474.          

CTE project_319205

475. 0.005 0.005 ↓ 0.0 0 1

CTE Scan on base_7 base_7_179 (cost=0.00..0.04 rows=1 width=968) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: (project = '319205'::text)
476.          

CTE project_319206

477. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_180 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319206'::text)
478.          

CTE project_319207

479. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_181 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319207'::text)
480.          

CTE project_319208

481. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_182 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '319208'::text)
482.          

CTE project_319209

483. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_183 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '319209'::text)
484.          

CTE project_319210

485. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_7 base_7_184 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '319210'::text)
486.          

CTE project_319211

487. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_7 base_7_185 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '319211'::text)
488.          

CTE base_12_0

489. 0.002 99,538.217 ↓ 0.0 0 1

WindowAgg (cost=1,191.27..1,191.67 rows=1 width=869) (actual time=99,538.217..99,538.217 rows=0 loops=1)

490. 0.009 99,538.215 ↓ 0.0 0 1

Sort (cost=1,191.27..1,191.28 rows=1 width=510) (actual time=99,538.215..99,538.215 rows=0 loops=1)

  • Sort Key: snapshot_scheduled_inspection.project_id, (_st_distance(location_4.geo_point, '0101000020E61000000000002098CF4240000000609AE94B40'::geography, '0'::double precision, true))
  • Sort Method: quicksort Memory: 25kB
491. 0.001 99,538.206 ↓ 0.0 0 1

Nested Loop (cost=55.29..1,191.26 rows=1 width=510) (actual time=99,538.206..99,538.206 rows=0 loops=1)

492. 0.000 99,538.205 ↓ 0.0 0 1

Nested Loop (cost=54.86..1,182.79 rows=1 width=381) (actual time=99,538.204..99,538.205 rows=0 loops=1)

493. 0.000 99,536.492 ↓ 1,775.0 1,775 1

Nested Loop (cost=54.72..1,182.53 rows=1 width=316) (actual time=55,977.283..99,536.492 rows=1,775 loops=1)

494. 0.556 99,534.727 ↓ 1,775.0 1,775 1

Nested Loop (cost=54.58..1,182.35 rows=1 width=284) (actual time=55,977.256..99,534.727 rows=1,775 loops=1)

495. 0.893 99,528.846 ↓ 1,775.0 1,775 1

Nested Loop (cost=54.16..1,174.52 rows=1 width=155) (actual time=55,977.225..99,528.846 rows=1,775 loops=1)

496. 51,316.147 99,526.178 ↓ 1,775.0 1,775 1

Nested Loop (cost=53.74..1,166.54 rows=1 width=97) (actual time=55,977.188..99,526.178 rows=1,775 loops=1)

  • Join Filter: (snapshot_scheduled_inspection.location_id = location_4.id)
  • Rows Removed by Join Filter: 323,305,600
497. 1,034.476 1,034.476 ↓ 182,145.0 182,145 1

Index Scan using location_gix on location location_4 (cost=0.29..8.68 rows=1 width=36) (actual time=0.458..1,034.476 rows=182,145 loops=1)

  • Index Cond: (geo_point && '0101000020E61000000000002098CF4240000000609AE94B40'::geography)
  • Filter: (('0101000020E61000000000002098CF4240000000609AE94B40'::geography && _st_expand(geo_point, '36110'::double precision)) AND _st_dwithin(geo_point, '0101000020E61000000000002098CF4240000000609AE94B40'::geography, '36110'::double precision, true))
  • Rows Removed by Filter: 84,610
498. 31,146.795 47,175.555 ↓ 2.9 1,775 182,145

Bitmap Heap Scan on snapshot_scheduled_inspection (cost=53.45..1,150.20 rows=613 width=69) (actual time=0.092..0.259 rows=1,775 loops=182,145)

  • Recheck Cond: ((actor_id = '-1'::integer) AND (project_id = ANY ('{159378,159393,159408,159423,159438,100183,156497,156514,156531,156603}'::integer[])) AND (visible_id = 1) AND (actuality = 0))
  • Heap Blocks: exact=14,207,310
499. 16,028.760 16,028.760 ↓ 2.9 1,776 182,145

Bitmap Index Scan on snapshot_scheduled_inspection_actor_id_project_id_visible_id_ac (cost=0.00..53.30 rows=613 width=0) (actual time=0.088..0.088 rows=1,776 loops=182,145)

  • Index Cond: ((actor_id = '-1'::integer) AND (project_id = ANY ('{159378,159393,159408,159423,159438,100183,156497,156514,156531,156603}'::integer[])) AND (visible_id = 1) AND (actuality = 0))
500. 1.775 1.775 ↑ 1.0 1 1,775

Index Scan using control_object_pkey on control_object (cost=0.42..7.98 rows=1 width=62) (actual time=0.001..0.001 rows=1 loops=1,775)

  • Index Cond: (id = snapshot_scheduled_inspection.control_object_id)
501. 5.325 5.325 ↑ 1.0 1 1,775

Index Scan using control_subject_pkey on control_subject control_subject_4 (cost=0.42..7.82 rows=1 width=133) (actual time=0.003..0.003 rows=1 loops=1,775)

  • Index Cond: (id = snapshot_scheduled_inspection.control_subject_id)
502. 1.775 1.775 ↑ 1.0 1 1,775

Index Scan using planned_work_status_pkey on planned_work_status (cost=0.14..0.17 rows=1 width=36) (actual time=0.001..0.001 rows=1 loops=1,775)

  • Index Cond: (id = snapshot_scheduled_inspection.planned_work_status_id)
503. 1.775 1.775 ↓ 0.0 0 1,775

Index Scan using stage_pkey on stage stage_4 (cost=0.14..0.25 rows=1 width=73) (actual time=0.001..0.001 rows=0 loops=1,775)

  • Index Cond: (id = snapshot_scheduled_inspection.stage_id)
  • Filter: ((kind = 0) AND (status_stage_id = 2) AND ((platform)::text = 'mb'::text))
  • Rows Removed by Filter: 1
504. 0.000 0.000 ↓ 0.0 0

Index Scan using execution_pkey on execution execution_4 (cost=0.43..8.23 rows=1 width=125) (never executed)

  • Index Cond: (id = snapshot_scheduled_inspection.execution_id)
505.          

CTE base_12_1

506. 0.001 0.132 ↓ 0.0 0 1

Nested Loop (cost=14.15..48.04 rows=1 width=853) (actual time=0.132..0.132 rows=0 loops=1)

507. 0.001 0.131 ↓ 0.0 0 1

Nested Loop (cost=13.72..39.46 rows=1 width=381) (actual time=0.131..0.131 rows=0 loops=1)

508. 0.004 0.111 ↑ 1.0 1 1

Nested Loop (cost=13.58..30.95 rows=1 width=316) (actual time=0.108..0.111 rows=1 loops=1)

  • Join Filter: (snapshot_scheduled_inspection_1.planned_work_status_id = planned_work_status_1.id)
  • Rows Removed by Join Filter: 4
509. 0.002 0.102 ↑ 1.0 1 1

Nested Loop (cost=13.58..29.75 rows=1 width=284) (actual time=0.100..0.102 rows=1 loops=1)

510. 0.004 0.088 ↑ 1.0 1 1

Nested Loop (cost=13.16..21.31 rows=1 width=155) (actual time=0.086..0.088 rows=1 loops=1)

511. 0.006 0.073 ↑ 1.0 1 1

Merge Join (cost=12.73..12.87 rows=1 width=97) (actual time=0.071..0.073 rows=1 loops=1)

  • Merge Cond: (location_5.id = snapshot_scheduled_inspection_1.location_id)
512. 0.029 0.029 ↑ 437,057.5 2 1

Index Scan using location_pkey on location location_5 (cost=0.42..105,803.44 rows=874,115 width=36) (actual time=0.028..0.029 rows=2 loops=1)

513. 0.014 0.038 ↑ 1.0 1 1

Sort (cost=12.30..12.31 rows=1 width=69) (actual time=0.038..0.038 rows=1 loops=1)

  • Sort Key: snapshot_scheduled_inspection_1.location_id
  • Sort Method: quicksort Memory: 25kB
514. 0.015 0.024 ↑ 1.0 1 1

Bitmap Heap Scan on snapshot_scheduled_inspection snapshot_scheduled_inspection_1 (cost=4.47..12.29 rows=1 width=69) (actual time=0.024..0.024 rows=1 loops=1)

  • Recheck Cond: ((actor_id = 46) AND (visible_id = 1) AND (actuality = 0))
  • Filter: (project_id = ANY ('{159378,159393,159408,159423,159438,100183,156497,156514,156531,156603}'::integer[]))
  • Heap Blocks: exact=1
515. 0.009 0.009 ↑ 2.0 1 1

Bitmap Index Scan on snapshot_scheduled_inspection_actor_id_project_id_visible_id_ac (cost=0.00..4.46 rows=2 width=0) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: ((actor_id = 46) AND (visible_id = 1) AND (actuality = 0))
516. 0.011 0.011 ↑ 1.0 1 1

Index Scan using control_object_pkey on control_object control_object_1 (cost=0.42..8.44 rows=1 width=62) (actual time=0.011..0.011 rows=1 loops=1)

  • Index Cond: (id = snapshot_scheduled_inspection_1.control_object_id)
517. 0.012 0.012 ↑ 1.0 1 1

Index Scan using control_subject_pkey on control_subject control_subject_5 (cost=0.42..8.44 rows=1 width=133) (actual time=0.012..0.012 rows=1 loops=1)

  • Index Cond: (id = snapshot_scheduled_inspection_1.control_subject_id)
518. 0.005 0.005 ↑ 1.8 5 1

Seq Scan on planned_work_status planned_work_status_1 (cost=0.00..1.09 rows=9 width=36) (actual time=0.005..0.005 rows=5 loops=1)

519. 0.019 0.019 ↓ 0.0 0 1

Index Scan using stage_pkey on stage stage_5 (cost=0.14..8.17 rows=1 width=73) (actual time=0.019..0.019 rows=0 loops=1)

  • Index Cond: (id = snapshot_scheduled_inspection_1.stage_id)
  • Filter: ((kind = 0) AND (status_stage_id = 2) AND ((platform)::text = 'mb'::text))
  • Rows Removed by Filter: 1
520. 0.000 0.000 ↓ 0.0 0

Index Scan using execution_pkey on execution execution_5 (cost=0.43..8.45 rows=1 width=125) (never executed)

  • Index Cond: (id = snapshot_scheduled_inspection_1.execution_id)
521.          

CTE base_12

522. 0.002 99,538.354 ↓ 0.0 0 1

Append (cost=0.00..0.07 rows=2 width=896) (actual time=99,538.354..99,538.354 rows=0 loops=1)

523. 99,538.219 99,538.219 ↓ 0.0 0 1

CTE Scan on base_12_0 (cost=0.00..0.02 rows=1 width=896) (actual time=99,538.218..99,538.219 rows=0 loops=1)

524. 0.000 0.133 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2_2 (cost=0.00..0.03 rows=1 width=896) (actual time=0.133..0.133 rows=0 loops=1)

525. 0.133 0.133 ↓ 0.0 0 1

CTE Scan on base_12_1 (cost=0.00..0.02 rows=1 width=892) (actual time=0.132..0.133 rows=0 loops=1)

526.          

CTE project_159378

527. 99,538.360 99,538.360 ↓ 0.0 0 1

CTE Scan on base_12 (cost=0.00..0.04 rows=1 width=968) (actual time=99,538.360..99,538.360 rows=0 loops=1)

  • Filter: (project = '159378'::text)
528.          

CTE project_159393

529. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_12 base_12_2 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '159393'::text)
530.          

CTE project_159408

531. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_12 base_12_3 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '159408'::text)
532.          

CTE project_159423

533. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_12 base_12_4 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '159423'::text)
534.          

CTE project_159438

535. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_12 base_12_5 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '159438'::text)
536.          

CTE project_100183

537. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_12 base_12_6 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '100183'::text)
538.          

CTE project_156497

539. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_12 base_12_7 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '156497'::text)
540.          

CTE project_156514

541. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_12 base_12_8 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '156514'::text)
542.          

CTE project_156531

543. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_12 base_12_9 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '156531'::text)
544.          

CTE project_156603

545. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_12 base_12_10 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '156603'::text)
546.          

CTE base_98_0

547. 0.001 0.032 ↓ 0.0 0 1

WindowAgg (cost=59.36..59.76 rows=1 width=836) (actual time=0.031..0.032 rows=0 loops=1)

548. 0.008 0.031 ↓ 0.0 0 1

Sort (cost=59.36..59.36 rows=1 width=493) (actual time=0.030..0.031 rows=0 loops=1)

  • Sort Key: prescription_snapshot.project_id, (_st_distance(location_6.geo_point, '0101000020E61000000000002098CF4240000000609AE94B40'::geography, '0'::double precision, true))
  • Sort Method: quicksort Memory: 25kB
549. 0.001 0.023 ↓ 0.0 0 1

Nested Loop (cost=1.56..59.35 rows=1 width=493) (actual time=0.023..0.023 rows=0 loops=1)

550. 0.000 0.022 ↓ 0.0 0 1

Nested Loop (cost=1.14..50.65 rows=1 width=364) (actual time=0.022..0.022 rows=0 loops=1)

551. 0.000 0.022 ↓ 0.0 0 1

Nested Loop (cost=0.99..42.14 rows=1 width=299) (actual time=0.022..0.022 rows=0 loops=1)

  • Join Filter: (prescription_snapshot.location_id = location_6.id)
552. 0.001 0.022 ↓ 0.0 0 1

Nested Loop (cost=0.71..33.45 rows=1 width=271) (actual time=0.022..0.022 rows=0 loops=1)

553. 0.000 0.021 ↓ 0.0 0 1

Nested Loop (cost=0.42..25.14 rows=1 width=225) (actual time=0.021..0.021 rows=0 loops=1)

554. 0.021 0.021 ↓ 0.0 0 1

Seq Scan on prescription_snapshot (cost=0.00..16.71 rows=1 width=96) (actual time=0.021..0.021 rows=0 loops=1)

  • Filter: ((actor_id = '-1'::integer) AND (actuality = 0) AND (visible_id = 1) AND (project_id = ANY ('{172932,172933,172934,236043,236044,236045,236046,236047,236048,236049,236050,236051,236052,236053,236054,236055,236056,236057,236058,236059,236060,236061,236062,236063,236064,236065,236066,236067,236068,236069,236070,236071,236072,236073,236074,236075,236076,236077,236078,236079,236080,236081,236082,236083,236084,236085,236086,236087,236088,236089,236090,236091,236092,236093,236094,236095,236096,236097,236098,236099,236100,236101,236102,236103,236104,236105,236106,236107,236108,236109,236110,236111,236112,236113,236114,236115,236116,236117,236118,236119,236120,236121,236122,236123,236124,236125,236126,236127,236128,236129,236130,236131,236132,236133,236134,236135,236136,236137,236138,236139,236140,236141,236142,236143,236144,236145,236146,236147,236148,236149,236150,236151,236152,236153,236154,236155,236156,236157,236158,236159,236160,236161,236162,236163,236164,236165,236166,236167,236168,236169,236170,236171,236172,236173,236174,236175,236176,236177,236178,236179,236180,236181,236182,236183,236184,236185,236186,236187,236188,236189,236190,236191,236192,236193,236194,236195,236196,236197,236198,236199,236200,236201,236202,236203,236204,236205,236206,236207,236208,236209,236210,236211,236212,236213,236214,236215,236216,236217,236218,236219,236220,236221,236222,236223,236224,236225,236226,236227,236228,236229,236230,236231,236232,236233,236234,236235,236236,236237,236238,236239,236240,236241,236242,236243,236244,236245,236246,236247,236248,236249,236250,236251,236252,236253,236254,236255,236256,236257,236258,236259,236260,236261,236262,236263,236264,236265,236266,236267,236268,236269,236270,236271,236272,236273,236274,236275,236276,236277,236278,236279,236280,236281,236282,236283,236284,236285,236286,236287,236288,236289,236290,236291,236292,236293,236294,236295,236296,236297,236298,236299,236300,236301,236302,236303,236304,236305,236306,236307,236308,236309,236310,236311,236312,236313,236314,236315,236316,236317,236318,236319,236320,236321,236322,236323,236324,236325,236326,236327,236328,236329,236330,236331,236332,236333,236334,236335,236336,236337,236338,236339,236340,236341,236342,236343,236344,236345,236346,236347,236348,236349,236350,236351,236352,236353,236354,236355,236356,236357,236358,236359,236360,236361,236362,236363,236364,236365,236366,236367,236368,236369,236370,236371,236372,236373,236374}'::integer[])))
  • Rows Removed by Filter: 36
555. 0.000 0.000 ↓ 0.0 0

Index Scan using control_subject_pkey on control_subject control_subject_6 (cost=0.42..8.44 rows=1 width=133) (never executed)

  • Index Cond: (id = prescription_snapshot.control_subject_id)
556. 0.000 0.000 ↓ 0.0 0

Index Scan using company_pkey on company company_4 (cost=0.29..8.30 rows=1 width=50) (never executed)

  • Index Cond: (id = prescription_snapshot.company_id)
557. 0.000 0.000 ↓ 0.0 0

Index Scan using location_gix on location location_6 (cost=0.29..8.68 rows=1 width=36) (never executed)

  • Index Cond: (geo_point && '0101000020E61000000000002098CF4240000000609AE94B40'::geography)
  • Filter: (('0101000020E61000000000002098CF4240000000609AE94B40'::geography && _st_expand(geo_point, '36110'::double precision)) AND _st_dwithin(geo_point, '0101000020E61000000000002098CF4240000000609AE94B40'::geography, '36110'::double precision, true))
558. 0.000 0.000 ↓ 0.0 0

Index Scan using stage_pkey on stage stage_6 (cost=0.14..8.17 rows=1 width=73) (never executed)

  • Index Cond: (id = prescription_snapshot.stage_id)
  • Filter: ((kind = 0) AND (status_stage_id = 2) AND ((platform)::text = 'mb'::text))
559. 0.000 0.000 ↓ 0.0 0

Index Scan using execution_pkey on execution execution_6 (cost=0.43..8.45 rows=1 width=125) (never executed)

  • Index Cond: (id = prescription_snapshot.execution_id)
560.          

CTE base_98_1

561. 0.000 0.009 ↓ 0.0 0 1

Nested Loop (cost=1.71..58.97 rows=1 width=820) (actual time=0.009..0.009 rows=0 loops=1)

562. 0.001 0.009 ↓ 0.0 0 1

Nested Loop (cost=1.28..50.40 rows=1 width=364) (actual time=0.008..0.009 rows=0 loops=1)

563. 0.000 0.008 ↓ 0.0 0 1

Nested Loop (cost=1.13..41.89 rows=1 width=299) (actual time=0.008..0.008 rows=0 loops=1)

564. 0.000 0.008 ↓ 0.0 0 1

Nested Loop (cost=0.71..33.45 rows=1 width=271) (actual time=0.008..0.008 rows=0 loops=1)

565. 0.001 0.008 ↓ 0.0 0 1

Nested Loop (cost=0.42..25.14 rows=1 width=225) (actual time=0.008..0.008 rows=0 loops=1)

566. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on prescription_snapshot prescription_snapshot_1 (cost=0.00..16.71 rows=1 width=96) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: ((actor_id = 46) AND (actuality = 0) AND (visible_id = 1) AND (project_id = ANY ('{172932,172933,172934,236043,236044,236045,236046,236047,236048,236049,236050,236051,236052,236053,236054,236055,236056,236057,236058,236059,236060,236061,236062,236063,236064,236065,236066,236067,236068,236069,236070,236071,236072,236073,236074,236075,236076,236077,236078,236079,236080,236081,236082,236083,236084,236085,236086,236087,236088,236089,236090,236091,236092,236093,236094,236095,236096,236097,236098,236099,236100,236101,236102,236103,236104,236105,236106,236107,236108,236109,236110,236111,236112,236113,236114,236115,236116,236117,236118,236119,236120,236121,236122,236123,236124,236125,236126,236127,236128,236129,236130,236131,236132,236133,236134,236135,236136,236137,236138,236139,236140,236141,236142,236143,236144,236145,236146,236147,236148,236149,236150,236151,236152,236153,236154,236155,236156,236157,236158,236159,236160,236161,236162,236163,236164,236165,236166,236167,236168,236169,236170,236171,236172,236173,236174,236175,236176,236177,236178,236179,236180,236181,236182,236183,236184,236185,236186,236187,236188,236189,236190,236191,236192,236193,236194,236195,236196,236197,236198,236199,236200,236201,236202,236203,236204,236205,236206,236207,236208,236209,236210,236211,236212,236213,236214,236215,236216,236217,236218,236219,236220,236221,236222,236223,236224,236225,236226,236227,236228,236229,236230,236231,236232,236233,236234,236235,236236,236237,236238,236239,236240,236241,236242,236243,236244,236245,236246,236247,236248,236249,236250,236251,236252,236253,236254,236255,236256,236257,236258,236259,236260,236261,236262,236263,236264,236265,236266,236267,236268,236269,236270,236271,236272,236273,236274,236275,236276,236277,236278,236279,236280,236281,236282,236283,236284,236285,236286,236287,236288,236289,236290,236291,236292,236293,236294,236295,236296,236297,236298,236299,236300,236301,236302,236303,236304,236305,236306,236307,236308,236309,236310,236311,236312,236313,236314,236315,236316,236317,236318,236319,236320,236321,236322,236323,236324,236325,236326,236327,236328,236329,236330,236331,236332,236333,236334,236335,236336,236337,236338,236339,236340,236341,236342,236343,236344,236345,236346,236347,236348,236349,236350,236351,236352,236353,236354,236355,236356,236357,236358,236359,236360,236361,236362,236363,236364,236365,236366,236367,236368,236369,236370,236371,236372,236373,236374}'::integer[])))
  • Rows Removed by Filter: 36
567. 0.000 0.000 ↓ 0.0 0

Index Scan using control_subject_pkey on control_subject control_subject_7 (cost=0.42..8.44 rows=1 width=133) (never executed)

  • Index Cond: (id = prescription_snapshot_1.control_subject_id)
568. 0.000 0.000 ↓ 0.0 0

Index Scan using company_pkey on company company_5 (cost=0.29..8.30 rows=1 width=50) (never executed)

  • Index Cond: (id = prescription_snapshot_1.company_id)
569. 0.000 0.000 ↓ 0.0 0

Index Scan using location_pkey on location location_7 (cost=0.42..8.44 rows=1 width=36) (never executed)

  • Index Cond: (id = prescription_snapshot_1.location_id)
570. 0.000 0.000 ↓ 0.0 0

Index Scan using stage_pkey on stage stage_7 (cost=0.14..8.17 rows=1 width=73) (never executed)

  • Index Cond: (id = prescription_snapshot_1.stage_id)
  • Filter: ((kind = 0) AND (status_stage_id = 2) AND ((platform)::text = 'mb'::text))
571. 0.000 0.000 ↓ 0.0 0

Index Scan using execution_pkey on execution execution_7 (cost=0.43..8.45 rows=1 width=125) (never executed)

  • Index Cond: (id = prescription_snapshot_1.execution_id)
572.          

CTE base_98

573. 0.002 0.051 ↓ 0.0 0 1

Append (cost=0.00..0.07 rows=2 width=824) (actual time=0.051..0.051 rows=0 loops=1)

574. 0.037 0.037 ↓ 0.0 0 1

CTE Scan on base_98_0 (cost=0.00..0.02 rows=1 width=824) (actual time=0.037..0.037 rows=0 loops=1)

575. 0.003 0.012 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2_3 (cost=0.00..0.03 rows=1 width=824) (actual time=0.012..0.012 rows=0 loops=1)

576. 0.009 0.009 ↓ 0.0 0 1

CTE Scan on base_98_1 (cost=0.00..0.02 rows=1 width=820) (actual time=0.009..0.009 rows=0 loops=1)

577.          

CTE project_172932

578. 0.054 0.054 ↓ 0.0 0 1

CTE Scan on base_98 (cost=0.00..0.04 rows=1 width=968) (actual time=0.054..0.054 rows=0 loops=1)

  • Filter: (project = '172932'::text)
579.          

CTE project_172933

580. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_2 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '172933'::text)
581.          

CTE project_172934

582. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_3 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '172934'::text)
583.          

CTE project_236043

584. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_4 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236043'::text)
585.          

CTE project_236044

586. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_5 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236044'::text)
587.          

CTE project_236045

588. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_6 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236045'::text)
589.          

CTE project_236046

590. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_7 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236046'::text)
591.          

CTE project_236047

592. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_8 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236047'::text)
593.          

CTE project_236048

594. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_9 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '236048'::text)
595.          

CTE project_236049

596. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_10 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236049'::text)
597.          

CTE project_236050

598. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_11 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236050'::text)
599.          

CTE project_236051

600. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_12 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236051'::text)
601.          

CTE project_236052

602. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_13 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '236052'::text)
603.          

CTE project_236053

604. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_14 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236053'::text)
605.          

CTE project_236054

606. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_15 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236054'::text)
607.          

CTE project_236055

608. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_16 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236055'::text)
609.          

CTE project_236056

610. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_17 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '236056'::text)
611.          

CTE project_236057

612. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_18 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236057'::text)
613.          

CTE project_236058

614. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_19 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236058'::text)
615.          

CTE project_236059

616. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_20 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236059'::text)
617.          

CTE project_236060

618. 0.003 0.003 ↓ 0.0 0 1

CTE Scan on base_98 base_98_21 (cost=0.00..0.04 rows=1 width=968) (actual time=0.002..0.003 rows=0 loops=1)

  • Filter: (project = '236060'::text)
619.          

CTE project_236061

620. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_22 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236061'::text)
621.          

CTE project_236062

622. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_23 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236062'::text)
623.          

CTE project_236063

624. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_24 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236063'::text)
625.          

CTE project_236064

626. 0.003 0.003 ↓ 0.0 0 1

CTE Scan on base_98 base_98_25 (cost=0.00..0.04 rows=1 width=968) (actual time=0.002..0.003 rows=0 loops=1)

  • Filter: (project = '236064'::text)
627.          

CTE project_236065

628. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_26 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236065'::text)
629.          

CTE project_236066

630. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_27 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236066'::text)
631.          

CTE project_236067

632. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_28 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236067'::text)
633.          

CTE project_236068

634. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_29 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236068'::text)
635.          

CTE project_236069

636. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_30 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236069'::text)
637.          

CTE project_236070

638. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_31 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236070'::text)
639.          

CTE project_236071

640. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_32 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236071'::text)
641.          

CTE project_236072

642. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_33 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236072'::text)
643.          

CTE project_236073

644. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_34 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236073'::text)
645.          

CTE project_236074

646. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_35 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236074'::text)
647.          

CTE project_236075

648. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_36 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236075'::text)
649.          

CTE project_236076

650. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_37 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236076'::text)
651.          

CTE project_236077

652. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_38 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236077'::text)
653.          

CTE project_236078

654. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_39 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236078'::text)
655.          

CTE project_236079

656. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_40 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236079'::text)
657.          

CTE project_236080

658. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_41 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '236080'::text)
659.          

CTE project_236081

660. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_42 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236081'::text)
661.          

CTE project_236082

662. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_43 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236082'::text)
663.          

CTE project_236083

664. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_44 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236083'::text)
665.          

CTE project_236084

666. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_45 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236084'::text)
667.          

CTE project_236085

668. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_46 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236085'::text)
669.          

CTE project_236086

670. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_47 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236086'::text)
671.          

CTE project_236087

672. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_48 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236087'::text)
673.          

CTE project_236088

674. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_49 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '236088'::text)
675.          

CTE project_236089

676. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_50 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236089'::text)
677.          

CTE project_236090

678. 0.004 0.004 ↓ 0.0 0 1

CTE Scan on base_98 base_98_51 (cost=0.00..0.04 rows=1 width=968) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (project = '236090'::text)
679.          

CTE project_236091

680. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_52 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236091'::text)
681.          

CTE project_236092

682. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_53 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '236092'::text)
683.          

CTE project_236093

684. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_54 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236093'::text)
685.          

CTE project_236094

686. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_55 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236094'::text)
687.          

CTE project_236095

688. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_56 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '236095'::text)
689.          

CTE project_236096

690. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_57 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '236096'::text)
691.          

CTE project_236097

692. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_58 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236097'::text)
693.          

CTE project_236098

694. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_59 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236098'::text)
695.          

CTE project_236099

696. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_60 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236099'::text)
697.          

CTE project_236100

698. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_61 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '236100'::text)
699.          

CTE project_236101

700. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_62 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236101'::text)
701.          

CTE project_236102

702. 0.003 0.003 ↓ 0.0 0 1

CTE Scan on base_98 base_98_63 (cost=0.00..0.04 rows=1 width=968) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (project = '236102'::text)
703.          

CTE project_236103

704. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_64 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236103'::text)
705.          

CTE project_236104

706. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_65 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '236104'::text)
707.          

CTE project_236105

708. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_66 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236105'::text)
709.          

CTE project_236106

710. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_67 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236106'::text)
711.          

CTE project_236107

712. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_68 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '236107'::text)
713.          

CTE project_236108

714. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_69 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '236108'::text)
715.          

CTE project_236109

716. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_70 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236109'::text)
717.          

CTE project_236110

718. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_71 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236110'::text)
719.          

CTE project_236111

720. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_72 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236111'::text)
721.          

CTE project_236112

722. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_73 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236112'::text)
723.          

CTE project_236113

724. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_74 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236113'::text)
725.          

CTE project_236114

726. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_75 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '236114'::text)
727.          

CTE project_236115

728. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_76 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '236115'::text)
729.          

CTE project_236116

730. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_77 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236116'::text)
731.          

CTE project_236117

732. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_78 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236117'::text)
733.          

CTE project_236118

734. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_79 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236118'::text)
735.          

CTE project_236119

736. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_80 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236119'::text)
737.          

CTE project_236120

738. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_81 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236120'::text)
739.          

CTE project_236121

740. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_82 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236121'::text)
741.          

CTE project_236122

742. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_83 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236122'::text)
743.          

CTE project_236123

744. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_84 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236123'::text)
745.          

CTE project_236124

746. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_85 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236124'::text)
747.          

CTE project_236125

748. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_86 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236125'::text)
749.          

CTE project_236126

750. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_87 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236126'::text)
751.          

CTE project_236127

752. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_88 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '236127'::text)
753.          

CTE project_236128

754. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_89 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236128'::text)
755.          

CTE project_236129

756. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_90 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236129'::text)
757.          

CTE project_236130

758. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_91 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236130'::text)
759.          

CTE project_236131

760. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_92 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236131'::text)
761.          

CTE project_236132

762. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_93 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236132'::text)
763.          

CTE project_236133

764. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_94 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236133'::text)
765.          

CTE project_236134

766. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_95 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236134'::text)
767.          

CTE project_236135

768. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_96 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '236135'::text)
769.          

CTE project_236136

770. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_97 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236136'::text)
771.          

CTE project_236137

772. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_98 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236137'::text)
773.          

CTE project_236138

774. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_99 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236138'::text)
775.          

CTE project_236139

776. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_100 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '236139'::text)
777.          

CTE project_236140

778. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_101 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236140'::text)
779.          

CTE project_236141

780. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_102 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236141'::text)
781.          

CTE project_236142

782. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_103 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236142'::text)
783.          

CTE project_236143

784. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_104 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '236143'::text)
785.          

CTE project_236144

786. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_105 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236144'::text)
787.          

CTE project_236145

788. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_106 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '236145'::text)
789.          

CTE project_236146

790. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_107 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236146'::text)
791.          

CTE project_236147

792. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_108 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '236147'::text)
793.          

CTE project_236148

794. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_109 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236148'::text)
795.          

CTE project_236149

796. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_110 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236149'::text)
797.          

CTE project_236150

798. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_111 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236150'::text)
799.          

CTE project_236151

800. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_112 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '236151'::text)
801.          

CTE project_236152

802. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_113 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236152'::text)
803.          

CTE project_236153

804. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_114 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236153'::text)
805.          

CTE project_236154

806. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_115 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236154'::text)
807.          

CTE project_236155

808. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_116 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '236155'::text)
809.          

CTE project_236156

810. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_117 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236156'::text)
811.          

CTE project_236157

812. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_118 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '236157'::text)
813.          

CTE project_236158

814. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_119 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236158'::text)
815.          

CTE project_236159

816. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_120 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236159'::text)
817.          

CTE project_236160

818. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_121 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236160'::text)
819.          

CTE project_236161

820. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_122 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236161'::text)
821.          

CTE project_236162

822. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_123 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236162'::text)
823.          

CTE project_236163

824. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_124 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236163'::text)
825.          

CTE project_236164

826. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_125 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236164'::text)
827.          

CTE project_236165

828. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_126 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236165'::text)
829.          

CTE project_236166

830. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_127 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236166'::text)
831.          

CTE project_236167

832. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_128 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '236167'::text)
833.          

CTE project_236168

834. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_129 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236168'::text)
835.          

CTE project_236169

836. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_130 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236169'::text)
837.          

CTE project_236170

838. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_131 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '236170'::text)
839.          

CTE project_236171

840. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_132 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '236171'::text)
841.          

CTE project_236172

842. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_133 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236172'::text)
843.          

CTE project_236173

844. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_134 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236173'::text)
845.          

CTE project_236174

846. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_135 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236174'::text)
847.          

CTE project_236175

848. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_136 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '236175'::text)
849.          

CTE project_236176

850. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_137 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236176'::text)
851.          

CTE project_236177

852. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_138 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236177'::text)
853.          

CTE project_236178

854. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_139 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236178'::text)
855.          

CTE project_236179

856. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_140 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '236179'::text)
857.          

CTE project_236180

858. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_141 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236180'::text)
859.          

CTE project_236181

860. 0.002 0.002 ↓ 0.0 0 1

CTE Scan on base_98 base_98_142 (cost=0.00..0.04 rows=1 width=968) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (project = '236181'::text)
861.          

CTE project_236182

862. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_143 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236182'::text)
863.          

CTE project_236183

864. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_144 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '236183'::text)
865.          

CTE project_236184

866. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_145 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236184'::text)
867.          

CTE project_236185

868. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_146 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236185'::text)
869.          

CTE project_236186

870. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_147 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236186'::text)
871.          

CTE project_236187

872. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_148 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '236187'::text)
873.          

CTE project_236188

874. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_149 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236188'::text)
875.          

CTE project_236189

876. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_150 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236189'::text)
877.          

CTE project_236190

878. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_151 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236190'::text)
879.          

CTE project_236191

880. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_152 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '236191'::text)
881.          

CTE project_236192

882. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_153 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236192'::text)
883.          

CTE project_236193

884. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_154 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236193'::text)
885.          

CTE project_236194

886. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_155 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236194'::text)
887.          

CTE project_236195

888. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_156 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '236195'::text)
889.          

CTE project_236196

890. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_157 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '236196'::text)
891.          

CTE project_236197

892. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_158 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236197'::text)
893.          

CTE project_236198

894. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_159 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236198'::text)
895.          

CTE project_236199

896. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_160 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '236199'::text)
897.          

CTE project_236200

898. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_161 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236200'::text)
899.          

CTE project_236201

900. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_162 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236201'::text)
901.          

CTE project_236202

902. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_163 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236202'::text)
903.          

CTE project_236203

904. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_164 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (project = '236203'::text)
905.          

CTE project_236204

906. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_165 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236204'::text)
907.          

CTE project_236205

908. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_166 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236205'::text)
909.          

CTE project_236206

910. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on base_98 base_98_167 (cost=0.00..0.04 rows=1 width=968) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (project = '236206'::text)
911.          

CTE project_236207

912. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on base_98 base_98_168 (cost=0.00..0.04 rows=1 width=968) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (project = '236207'::text)
913.