explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Pr8b

Settings
# exclusive inclusive rows x rows loops node
1. 46.840 1,347.744 ↑ 1.0 1 1

HashAggregate (cost=15,835.12..15,835.13 rows=1 width=45) (actual time=1,347.744..1,347.744 rows=1 loops=1)

  • Output: s.id, (CASE WHEN (s.is_complex IS TRUE) THEN (('[+]'::text || (s.name)::text))::character varying ELSE s.name END), s.terms, s.org_id, s.duration
  • Group Key: s.id, CASE WHEN (s.is_complex IS TRUE) THEN (('[+]'::text || (s.name)::text))::character varying ELSE s.name END, s.terms, s.org_id, s.duration
  • Buffers: shared hit=749 read=607
  • I/O Timings: read=1231.610
2. 23.188 1,300.904 ↑ 1.0 136,072 1

Nested Loop (cost=0.42..14,122.47 rows=137,012 width=45) (actual time=13.410..1,300.904 rows=136,072 loops=1)

  • Output: s.id, CASE WHEN (s.is_complex IS TRUE) THEN (('[+]'::text || (s.name)::text))::character varying ELSE s.name END, s.terms, s.org_id, s.duration
  • Buffers: shared hit=749 read=607
  • I/O Timings: read=1231.610
3. 0.058 0.058 ↑ 1.0 1 1

Index Scan using sr_service_pk on public.sr_service s (cost=0.42..8.44 rows=1 width=127) (actual time=0.055..0.058 rows=1 loops=1)

  • Output: s.id, s.code, s.cul, s.is_death, s.duration, s.is_fictitious, s.is_independent, s.is_multuplicity, s.name, s.terms, s.org_id, s.category_id, s.duration_unit_id, s.prototype_id, s.type_id, s.from_dt, s.to_dt, s.is_repeated, s.is_inherit_protocol, s.is_expendable_materials, s.is_actual_cul, s.is_paraclinical, s.is_complex, s.accounting_id, s.is_autocopy_diagnoses, s.is_stomat, s.srg_dif_type_id, s.srg_opr_kind_id, s.is_need_anatomic_zone, s.aud_who, s.aud_when, s.aud_source, s.aud_who_create, s.aud_when_create, s.aud_source_create, s.is_filling, s.is_extraction, s.short_name, s.is_need_close_date, s.is_vmp
  • Index Cond: (s.id = 13)
  • Buffers: shared hit=4
4. 14.000 1,277.658 ↑ 1.0 136,072 1

Append (cost=0.00..12,401.38 rows=137,012 width=4) (actual time=13.327..1,277.658 rows=136,072 loops=1)

  • Buffers: shared hit=745 read=607
  • I/O Timings: read=1231.610
5. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on public.sr_scgenerated aps (cost=0.00..0.00 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: aps.service_id
  • Filter: (aps.service_id = 13)
6. 37.880 37.880 ↑ 1.0 2,766 1

Index Only Scan using sr_scgenerated_y2017_m07_r7_srv_ix on schedule.sr_scgenerated_y2017_m07_r7 aps_1 (cost=0.42..310.06 rows=2,884 width=4) (actual time=13.322..37.880 rows=2,766 loops=1)

  • Output: aps_1.service_id
  • Index Cond: (aps_1.service_id = 13)
  • Heap Fetches: 244
  • Buffers: shared hit=30 read=15
  • I/O Timings: read=36.946
7. 42.217 42.217 ↑ 1.1 2,817 1

Index Only Scan using sr_scgenerated_y2017_m08_r7_srv_ix on schedule.sr_scgenerated_y2017_m08_r7 aps_2 (cost=0.42..285.97 rows=3,066 width=4) (actual time=19.376..42.217 rows=2,817 loops=1)

  • Output: aps_2.service_id
  • Index Cond: (aps_2.service_id = 13)
  • Heap Fetches: 16
  • Buffers: shared hit=3 read=14
  • I/O Timings: read=41.643
8. 30.294 30.294 ↑ 1.0 3,036 1

Index Only Scan using sr_scgenerated_y2017_m09_r7_srv_ix on schedule.sr_scgenerated_y2017_m09_r7 aps_3 (cost=0.42..239.11 rows=3,137 width=4) (actual time=10.990..30.294 rows=3,036 loops=1)

  • Output: aps_3.service_id
  • Index Cond: (aps_3.service_id = 13)
  • Heap Fetches: 0
  • Buffers: shared hit=2 read=15
  • I/O Timings: read=29.715
9. 28.468 28.468 ↑ 1.0 3,554 1

Index Only Scan using sr_scgenerated_y2017_m10_r7_srv_ix on schedule.sr_scgenerated_y2017_m10_r7 aps_4 (cost=0.42..302.84 rows=3,596 width=4) (actual time=14.371..28.468 rows=3,554 loops=1)

  • Output: aps_4.service_id
  • Index Cond: (aps_4.service_id = 13)
  • Heap Fetches: 22
  • Buffers: shared hit=6 read=18
  • I/O Timings: read=27.768
10. 40.195 40.195 ↓ 1.0 4,568 1

Index Only Scan using sr_scgenerated_y2017_m11_r7_srv_ix on schedule.sr_scgenerated_y2017_m11_r7 aps_5 (cost=0.42..347.55 rows=4,542 width=4) (actual time=15.597..40.195 rows=4,568 loops=1)

  • Output: aps_5.service_id
  • Index Cond: (aps_5.service_id = 13)
  • Heap Fetches: 104
  • Buffers: shared hit=12 read=22
  • I/O Timings: read=39.260
11. 21.505 21.505 ↑ 1.0 5,284 1

Index Only Scan using sr_scgenerated_y2017_m12_r7_srv_ix on schedule.sr_scgenerated_y2017_m12_r7 aps_6 (cost=0.42..431.18 rows=5,457 width=4) (actual time=13.850..21.505 rows=5,284 loops=1)

  • Output: aps_6.service_id
  • Index Cond: (aps_6.service_id = 13)
  • Heap Fetches: 7
  • Buffers: shared hit=3 read=26
  • I/O Timings: read=20.339
12. 25.032 25.032 ↑ 1.1 4,423 1

Index Only Scan using sr_scgenerated_y2018_m01_r7_srv_ix on schedule.sr_scgenerated_y2018_m01_r7 aps_7 (cost=0.42..405.11 rows=4,694 width=4) (actual time=8.759..25.032 rows=4,423 loops=1)

  • Output: aps_7.service_id
  • Index Cond: (aps_7.service_id = 13)
  • Heap Fetches: 187
  • Buffers: shared hit=21 read=22
  • I/O Timings: read=23.927
13. 30.932 30.932 ↑ 1.0 5,484 1

Index Only Scan using sr_scgenerated_y2018_m02_r7_srv_ix on schedule.sr_scgenerated_y2018_m02_r7 aps_8 (cost=0.42..572.58 rows=5,569 width=4) (actual time=11.262..30.932 rows=5,484 loops=1)

  • Output: aps_8.service_id
  • Index Cond: (aps_8.service_id = 13)
  • Heap Fetches: 217
  • Buffers: shared hit=32 read=26
  • I/O Timings: read=29.425
14. 0.034 0.034 ↓ 0.0 0 1

Seq Scan on schedule.sr_scgenerated_y2007_m11_r7 aps_9 (cost=0.00..1.20 rows=1 width=4) (actual time=0.034..0.034 rows=0 loops=1)

  • Output: aps_9.service_id
  • Filter: (aps_9.service_id = 13)
  • Rows Removed by Filter: 16
  • Buffers: shared hit=1
15. 48.834 48.834 ↑ 1.0 6,281 1

Index Only Scan using sr_scgenerated_y2018_m03_r7_srv_ix on schedule.sr_scgenerated_y2018_m03_r7 aps_10 (cost=0.42..619.03 rows=6,322 width=4) (actual time=16.770..48.834 rows=6,281 loops=1)

  • Output: aps_10.service_id
  • Index Cond: (aps_10.service_id = 13)
  • Heap Fetches: 277
  • Buffers: shared hit=34 read=31
  • I/O Timings: read=47.370
16. 37.155 37.155 ↓ 1.0 6,603 1

Index Only Scan using sr_scgenerated_y2018_m04_r7_srv_ix on schedule.sr_scgenerated_y2018_m04_r7 aps_11 (cost=0.42..514.83 rows=6,538 width=4) (actual time=14.574..37.155 rows=6,603 loops=1)

  • Output: aps_11.service_id
  • Index Cond: (aps_11.service_id = 13)
  • Heap Fetches: 258
  • Buffers: shared hit=23 read=32
  • I/O Timings: read=35.823
17. 51.090 51.090 ↓ 1.0 6,315 1

Index Only Scan using sr_scgenerated_y2018_m05_r7_srv_ix on schedule.sr_scgenerated_y2018_m05_r7 aps_12 (cost=0.42..474.53 rows=6,170 width=4) (actual time=17.341..51.090 rows=6,315 loops=1)

  • Output: aps_12.service_id
  • Index Cond: (aps_12.service_id = 13)
  • Heap Fetches: 88
  • Buffers: shared hit=17 read=32
  • I/O Timings: read=49.818
18. 33.649 33.649 ↓ 1.0 6,056 1

Index Only Scan using sr_scgenerated_y2018_m06_r7_srv_ix on schedule.sr_scgenerated_y2018_m06_r7 aps_13 (cost=0.42..440.29 rows=5,842 width=4) (actual time=9.236..33.649 rows=6,056 loops=1)

  • Output: aps_13.service_id
  • Index Cond: (aps_13.service_id = 13)
  • Heap Fetches: 39
  • Buffers: shared hit=10 read=28
  • I/O Timings: read=32.501
19. 30.498 30.498 ↑ 1.0 6,362 1

Index Only Scan using sr_scgenerated_y2018_m07_r7_srv_ix on schedule.sr_scgenerated_y2018_m07_r7 aps_14 (cost=0.42..438.83 rows=6,538 width=4) (actual time=11.707..30.498 rows=6,362 loops=1)

  • Output: aps_14.service_id
  • Index Cond: (aps_14.service_id = 13)
  • Heap Fetches: 208
  • Buffers: shared hit=26 read=29
  • I/O Timings: read=29.124
20. 29.032 29.032 ↓ 1.0 6,210 1

Index Only Scan using sr_scgenerated_y2018_m08_r7_srv_ix on schedule.sr_scgenerated_y2018_m08_r7 aps_15 (cost=0.42..547.72 rows=6,135 width=4) (actual time=11.454..29.032 rows=6,210 loops=1)

  • Output: aps_15.service_id
  • Index Cond: (aps_15.service_id = 13)
  • Heap Fetches: 283
  • Buffers: shared hit=42 read=29
  • I/O Timings: read=27.696
21. 34.656 34.656 ↓ 1.0 5,296 1

Index Only Scan using sr_scgenerated_y2018_m09_r7_srv_ix on schedule.sr_scgenerated_y2018_m09_r7 aps_16 (cost=0.42..431.46 rows=5,142 width=4) (actual time=9.344..34.656 rows=5,296 loops=1)

  • Output: aps_16.service_id
  • Index Cond: (aps_16.service_id = 13)
  • Heap Fetches: 92
  • Buffers: shared hit=13 read=26
  • I/O Timings: read=33.488
22. 28.030 28.030 ↓ 1.0 6,618 1

Index Only Scan using sr_scgenerated_y2018_m10_r7_srv_ix on schedule.sr_scgenerated_y2018_m10_r7 aps_17 (cost=0.42..404.62 rows=6,420 width=4) (actual time=11.335..28.030 rows=6,618 loops=1)

  • Output: aps_17.service_id
  • Index Cond: (aps_17.service_id = 13)
  • Heap Fetches: 61
  • Buffers: shared hit=8 read=32
  • I/O Timings: read=26.722
23. 60.224 60.224 ↑ 1.0 6,384 1

Index Only Scan using sr_scgenerated_y2018_m11_r7_srv_ix on schedule.sr_scgenerated_y2018_m11_r7 aps_18 (cost=0.42..498.66 rows=6,544 width=4) (actual time=5.291..60.224 rows=6,384 loops=1)

  • Output: aps_18.service_id
  • Index Cond: (aps_18.service_id = 13)
  • Heap Fetches: 375
  • Buffers: shared hit=51 read=27
  • I/O Timings: read=58.751
24. 113.589 113.589 ↓ 1.0 7,056 1

Index Only Scan using sr_scgenerated_y2018_m12_r7_srv_ix on schedule.sr_scgenerated_y2018_m12_r7 aps_19 (cost=0.42..546.37 rows=6,941 width=4) (actual time=7.907..113.589 rows=7,056 loops=1)

  • Output: aps_19.service_id
  • Index Cond: (aps_19.service_id = 13)
  • Heap Fetches: 220
  • Buffers: shared hit=31 read=26
  • I/O Timings: read=112.004
25. 64.275 64.275 ↓ 1.0 5,064 1

Index Only Scan using sr_scgenerated_y2019_m01_r7_srv_ix on schedule.sr_scgenerated_y2019_m01_r7 aps_20 (cost=0.42..347.25 rows=5,046 width=4) (actual time=17.662..64.275 rows=5,064 loops=1)

  • Output: aps_20.service_id
  • Index Cond: (aps_20.service_id = 13)
  • Heap Fetches: 162
  • Buffers: shared hit=19 read=23
  • I/O Timings: read=63.110
26. 0.148 0.148 ↑ 1.0 234 1

Seq Scan on schedule.sr_scgenerated_y2016_m10_r7 aps_21 (cost=0.00..12.43 rows=234 width=4) (actual time=0.097..0.148 rows=234 loops=1)

  • Output: aps_21.service_id
  • Filter: (aps_21.service_id = 13)
  • Rows Removed by Filter: 280
  • Buffers: shared hit=6
27. 0.071 0.071 ↑ 1.0 153 1

Seq Scan on schedule.sr_scgenerated_y2016_m09_r7 aps_22 (cost=0.00..6.01 rows=153 width=4) (actual time=0.035..0.071 rows=153 loops=1)

  • Output: aps_22.service_id
  • Filter: (aps_22.service_id = 13)
  • Rows Removed by Filter: 88
  • Buffers: shared hit=3
28. 126.463 126.463 ↑ 1.0 5,733 1

Index Only Scan using sr_scgenerated_y2019_m02_r7_srv_ix on schedule.sr_scgenerated_y2019_m02_r7 aps_23 (cost=0.42..464.56 rows=5,953 width=4) (actual time=9.974..126.463 rows=5,733 loops=1)

  • Output: aps_23.service_id
  • Index Cond: (aps_23.service_id = 13)
  • Heap Fetches: 109
  • Buffers: shared hit=19 read=24
  • I/O Timings: read=125.197
29. 53.467 53.467 ↑ 1.0 5,975 1

Index Only Scan using sr_scgenerated_y2019_m03_r7_srv_ix on schedule.sr_scgenerated_y2019_m03_r7 aps_24 (cost=0.42..480.83 rows=6,231 width=4) (actual time=14.842..53.467 rows=5,975 loops=1)

  • Output: aps_24.service_id
  • Index Cond: (aps_24.service_id = 13)
  • Heap Fetches: 156
  • Buffers: shared hit=12 read=25
  • I/O Timings: read=52.200
30. 49.528 49.528 ↓ 1.0 6,622 1

Index Only Scan using sr_scgenerated_y2019_m05_r7_srv_ix on schedule.sr_scgenerated_y2019_m05_r7 aps_25 (cost=0.42..1,375.26 rows=6,522 width=4) (actual time=12.036..49.528 rows=6,622 loops=1)

  • Output: aps_25.service_id
  • Index Cond: (aps_25.service_id = 13)
  • Heap Fetches: 607
  • Buffers: shared hit=79 read=25
  • I/O Timings: read=47.991
31. 96.422 96.422 ↓ 1.0 6,990 1

Index Only Scan using sr_scgenerated_y2019_m04_r7_srv_ix on schedule.sr_scgenerated_y2019_m04_r7 aps_26 (cost=0.42..478.95 rows=6,858 width=4) (actual time=18.140..96.422 rows=6,990 loops=1)

  • Output: aps_26.service_id
  • Index Cond: (aps_26.service_id = 13)
  • Heap Fetches: 188
  • Buffers: shared hit=22 read=28
  • I/O Timings: read=94.955
32. 13.562 13.562 ↑ 1.0 40 1

Index Only Scan using sr_scgenerated_y2019_m12_r7_srv_ix on schedule.sr_scgenerated_y2019_m12_r7 aps_27 (cost=0.29..29.01 rows=41 width=4) (actual time=13.556..13.562 rows=40 loops=1)

  • Output: aps_27.service_id
  • Index Cond: (aps_27.service_id = 13)
  • Heap Fetches: 0
  • Buffers: shared hit=2 read=1
  • I/O Timings: read=13.493
33. 20.782 20.782 ↑ 1.2 40 1

Index Only Scan using sr_scgenerated_y2019_m10_r7_srv_ix on schedule.sr_scgenerated_y2019_m10_r7 aps_28 (cost=0.29..25.09 rows=48 width=4) (actual time=14.096..20.782 rows=40 loops=1)

  • Output: aps_28.service_id
  • Index Cond: (aps_28.service_id = 13)
  • Heap Fetches: 0
  • Buffers: shared hit=1 read=4
  • I/O Timings: read=20.663
34. 5.912 5.912 ↑ 5.1 40 1

Index Only Scan using sr_scgenerated_y2019_m07_r7_srv_ix on schedule.sr_scgenerated_y2019_m07_r7 aps_29 (cost=0.29..85.53 rows=203 width=4) (actual time=5.486..5.912 rows=40 loops=1)

  • Output: aps_29.service_id
  • Index Cond: (aps_29.service_id = 13)
  • Heap Fetches: 10
  • Buffers: shared hit=3 read=2
  • I/O Timings: read=5.853
35. 20.798 20.798 ↑ 3.5 50 1

Index Only Scan using sr_scgenerated_y2019_m08_r7_srv_ix on schedule.sr_scgenerated_y2019_m08_r7 aps_30 (cost=0.29..51.14 rows=175 width=4) (actual time=7.857..20.798 rows=50 loops=1)

  • Output: aps_30.service_id
  • Index Cond: (aps_30.service_id = 13)
  • Heap Fetches: 0
  • Buffers: shared hit=2 read=3
  • I/O Timings: read=20.700
36. 8.348 8.348 ↑ 1.0 40 1

Index Only Scan using sr_scgenerated_y2020_m01_r7_srv_ix on schedule.sr_scgenerated_y2020_m01_r7 aps_31 (cost=0.28..40.79 rows=40 width=4) (actual time=8.343..8.348 rows=40 loops=1)

  • Output: aps_31.service_id
  • Index Cond: (aps_31.service_id = 13)
  • Heap Fetches: 0
  • Buffers: shared hit=2 read=1
  • I/O Timings: read=8.203
37. 50.465 50.465 ↓ 1.0 4,579 1

Index Only Scan using sr_scgenerated_y2019_m06_r7_srv_ix on schedule.sr_scgenerated_y2019_m06_r7 aps_32 (cost=0.42..894.90 rows=4,567 width=4) (actual time=15.772..50.465 rows=4,579 loops=1)

  • Output: aps_32.service_id
  • Index Cond: (aps_32.service_id = 13)
  • Heap Fetches: 725
  • Buffers: shared hit=98 read=16
  • I/O Timings: read=49.248
38. 4.964 4.964 ↓ 1.0 50 1

Index Only Scan using sr_scgenerated_y2019_m11_r7_srv_ix on schedule.sr_scgenerated_y2019_m11_r7 aps_33 (cost=0.29..25.11 rows=48 width=4) (actual time=4.540..4.964 rows=50 loops=1)

  • Output: aps_33.service_id
  • Index Cond: (aps_33.service_id = 13)
  • Heap Fetches: 0
  • Buffers: shared hit=2 read=2
  • I/O Timings: read=4.875
39. 22.918 22.918 ↑ 1.1 40 1

Index Only Scan using sr_scgenerated_y2019_m09_r7_srv_ix on schedule.sr_scgenerated_y2019_m09_r7 aps_34 (cost=0.29..29.02 rows=45 width=4) (actual time=8.266..22.918 rows=40 loops=1)

  • Output: aps_34.service_id
  • Index Cond: (aps_34.service_id = 13)
  • Heap Fetches: 0
  • Buffers: shared hit=2 read=3
  • I/O Timings: read=22.802
40. 0.166 0.166 ↑ 1.0 243 1

Seq Scan on schedule.sr_scgenerated_y2016_m12_r7 aps_35 (cost=0.00..10.74 rows=243 width=4) (actual time=0.110..0.166 rows=243 loops=1)

  • Output: aps_35.service_id
  • Filter: (aps_35.service_id = 13)
  • Rows Removed by Filter: 216
  • Buffers: shared hit=5
41. 0.126 0.126 ↑ 1.0 234 1

Seq Scan on schedule.sr_scgenerated_y2016_m11_r7 aps_36 (cost=0.00..10.73 rows=234 width=4) (actual time=0.068..0.126 rows=234 loops=1)

  • Output: aps_36.service_id
  • Filter: (aps_36.service_id = 13)
  • Rows Removed by Filter: 224
  • Buffers: shared hit=5
42. 0.112 0.112 ↑ 1.0 314 1

Seq Scan on schedule.sr_scgenerated_y2017_m01_r7 aps_37 (cost=0.00..8.32 rows=314 width=4) (actual time=0.034..0.112 rows=314 loops=1)

  • Output: aps_37.service_id
  • Filter: (aps_37.service_id = 13)
  • Rows Removed by Filter: 32
  • Buffers: shared hit=4
43. 0.111 0.111 ↑ 1.0 378 1

Seq Scan on schedule.sr_scgenerated_y2017_m05_r7 aps_38 (cost=0.00..9.12 rows=378 width=4) (actual time=0.023..0.111 rows=378 loops=1)

  • Output: aps_38.service_id
  • Filter: (aps_38.service_id = 13)
  • Rows Removed by Filter: 32
  • Buffers: shared hit=4
44. 0.065 0.065 ↑ 1.0 269 1

Seq Scan on schedule.sr_scgenerated_y2017_m06_r7 aps_39 (cost=0.00..6.56 rows=269 width=4) (actual time=0.015..0.065 rows=269 loops=1)

  • Output: aps_39.service_id
  • Filter: (aps_39.service_id = 13)
  • Rows Removed by Filter: 16
  • Buffers: shared hit=3
45. 0.067 0.067 ↑ 1.0 288 1

Seq Scan on schedule.sr_scgenerated_y2017_m03_r7 aps_40 (cost=0.00..6.80 rows=288 width=4) (actual time=0.017..0.067 rows=288 loops=1)

  • Output: aps_40.service_id
  • Filter: (aps_40.service_id = 13)
  • Rows Removed by Filter: 16
  • Buffers: shared hit=3
46. 0.098 0.098 ↑ 1.0 294 1

Seq Scan on schedule.sr_scgenerated_y2017_m02_r7 aps_41 (cost=0.00..6.68 rows=294 width=4) (actual time=0.027..0.098 rows=294 loops=1)

  • Output: aps_41.service_id
  • Filter: (aps_41.service_id = 13)
  • Buffers: shared hit=3
47. 0.078 0.078 ↑ 1.0 259 1

Seq Scan on schedule.sr_scgenerated_y2017_m04_r7 aps_42 (cost=0.00..6.24 rows=259 width=4) (actual time=0.021..0.078 rows=259 loops=1)

  • Output: aps_42.service_id
  • Filter: (aps_42.service_id = 13)
  • Buffers: shared hit=3
48. 0.022 0.048 ↑ 1.0 40 1

Bitmap Heap Scan on schedule.sr_scgenerated_y2020_m04_r7 aps_43 (cost=4.59..18.09 rows=40 width=4) (actual time=0.042..0.048 rows=40 loops=1)

  • Output: aps_43.service_id
  • Recheck Cond: (aps_43.service_id = 13)
  • Heap Blocks: exact=1
  • Buffers: shared hit=3
49. 0.026 0.026 ↑ 1.0 40 1

Bitmap Index Scan on sr_scgenerated_y2020_m04_r7_srv_ix (cost=0.00..4.58 rows=40 width=0) (actual time=0.026..0.026 rows=40 loops=1)

  • Index Cond: (aps_43.service_id = 13)
  • Buffers: shared hit=2
50. 0.022 0.022 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2021_m11_r7 aps_44 (cost=0.00..1.50 rows=40 width=4) (actual time=0.018..0.022 rows=40 loops=1)

  • Output: aps_44.service_id
  • Filter: (aps_44.service_id = 13)
  • Buffers: shared hit=1
51. 0.020 0.020 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2023_m01_r7 aps_45 (cost=0.00..1.50 rows=40 width=4) (actual time=0.012..0.020 rows=40 loops=1)

  • Output: aps_45.service_id
  • Filter: (aps_45.service_id = 13)
  • Buffers: shared hit=1
52. 0.019 0.019 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2024_m10_r7 aps_46 (cost=0.00..1.50 rows=40 width=4) (actual time=0.012..0.019 rows=40 loops=1)

  • Output: aps_46.service_id
  • Filter: (aps_46.service_id = 13)
  • Buffers: shared hit=1
53. 0.018 0.018 ↑ 1.0 50 1

Seq Scan on schedule.sr_scgenerated_y2021_m10_r7 aps_47 (cost=0.00..1.62 rows=50 width=4) (actual time=0.012..0.018 rows=50 loops=1)

  • Output: aps_47.service_id
  • Filter: (aps_47.service_id = 13)
  • Buffers: shared hit=1
54. 0.017 0.030 ↑ 1.0 40 1

Bitmap Heap Scan on schedule.sr_scgenerated_y2020_m03_r7 aps_48 (cost=4.59..21.09 rows=40 width=4) (actual time=0.027..0.030 rows=40 loops=1)

  • Output: aps_48.service_id
  • Recheck Cond: (aps_48.service_id = 13)
  • Heap Blocks: exact=1
  • Buffers: shared hit=3
55. 0.013 0.013 ↑ 1.0 40 1

Bitmap Index Scan on sr_scgenerated_y2020_m03_r7_srv_ix (cost=0.00..4.58 rows=40 width=0) (actual time=0.013..0.013 rows=40 loops=1)

  • Index Cond: (aps_48.service_id = 13)
  • Buffers: shared hit=2
56. 0.022 0.022 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2023_m03_r7 aps_49 (cost=0.00..1.50 rows=40 width=4) (actual time=0.015..0.022 rows=40 loops=1)

  • Output: aps_49.service_id
  • Filter: (aps_49.service_id = 13)
  • Buffers: shared hit=1
57. 0.019 0.019 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2024_m09_r7 aps_50 (cost=0.00..1.50 rows=40 width=4) (actual time=0.012..0.019 rows=40 loops=1)

  • Output: aps_50.service_id
  • Filter: (aps_50.service_id = 13)
  • Buffers: shared hit=1
58. 0.020 0.020 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2023_m02_r7 aps_51 (cost=0.00..1.50 rows=40 width=4) (actual time=0.012..0.020 rows=40 loops=1)

  • Output: aps_51.service_id
  • Filter: (aps_51.service_id = 13)
  • Buffers: shared hit=1
59. 0.019 0.019 ↑ 1.0 50 1

Seq Scan on schedule.sr_scgenerated_y2024_m08_r7 aps_52 (cost=0.00..1.62 rows=50 width=4) (actual time=0.012..0.019 rows=50 loops=1)

  • Output: aps_52.service_id
  • Filter: (aps_52.service_id = 13)
  • Buffers: shared hit=1
60. 0.021 0.021 ↑ 1.0 50 1

Seq Scan on schedule.sr_scgenerated_y2023_m04_r7 aps_53 (cost=0.00..1.62 rows=50 width=4) (actual time=0.013..0.021 rows=50 loops=1)

  • Output: aps_53.service_id
  • Filter: (aps_53.service_id = 13)
  • Buffers: shared hit=1
61. 0.017 0.017 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2021_m08_r7 aps_54 (cost=0.00..1.50 rows=40 width=4) (actual time=0.012..0.017 rows=40 loops=1)

  • Output: aps_54.service_id
  • Filter: (aps_54.service_id = 13)
  • Buffers: shared hit=1
62. 0.022 0.022 ↑ 1.0 50 1

Seq Scan on schedule.sr_scgenerated_y2024_m11_r7 aps_55 (cost=0.00..1.62 rows=50 width=4) (actual time=0.013..0.022 rows=50 loops=1)

  • Output: aps_55.service_id
  • Filter: (aps_55.service_id = 13)
  • Buffers: shared hit=1
63. 0.025 0.043 ↑ 1.0 50 1

Bitmap Heap Scan on schedule.sr_scgenerated_y2020_m02_r7 aps_56 (cost=4.67..20.29 rows=50 width=4) (actual time=0.035..0.043 rows=50 loops=1)

  • Output: aps_56.service_id
  • Recheck Cond: (aps_56.service_id = 13)
  • Heap Blocks: exact=1
  • Buffers: shared hit=3
64. 0.018 0.018 ↑ 1.0 50 1

Bitmap Index Scan on sr_scgenerated_y2020_m02_r7_srv_ix (cost=0.00..4.65 rows=50 width=0) (actual time=0.018..0.018 rows=50 loops=1)

  • Index Cond: (aps_56.service_id = 13)
  • Buffers: shared hit=2
65. 0.023 0.023 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2021_m09_r7 aps_57 (cost=0.00..1.50 rows=40 width=4) (actual time=0.016..0.023 rows=40 loops=1)

  • Output: aps_57.service_id
  • Filter: (aps_57.service_id = 13)
  • Buffers: shared hit=1
66. 0.020 0.020 ↑ 1.0 50 1

Seq Scan on schedule.sr_scgenerated_y2021_m07_r7 aps_58 (cost=0.00..1.62 rows=50 width=4) (actual time=0.013..0.020 rows=50 loops=1)

  • Output: aps_58.service_id
  • Filter: (aps_58.service_id = 13)
  • Buffers: shared hit=1
67. 0.020 0.020 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2023_m06_r7 aps_59 (cost=0.00..1.50 rows=40 width=4) (actual time=0.013..0.020 rows=40 loops=1)

  • Output: aps_59.service_id
  • Filter: (aps_59.service_id = 13)
  • Buffers: shared hit=1
68. 0.024 0.024 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2024_m12_r7 aps_60 (cost=0.00..1.50 rows=40 width=4) (actual time=0.018..0.024 rows=40 loops=1)

  • Output: aps_60.service_id
  • Filter: (aps_60.service_id = 13)
  • Buffers: shared hit=1
69. 0.020 0.020 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2025_m01_r7 aps_61 (cost=0.00..1.50 rows=40 width=4) (actual time=0.013..0.020 rows=40 loops=1)

  • Output: aps_61.service_id
  • Filter: (aps_61.service_id = 13)
  • Buffers: shared hit=1
70. 0.015 0.015 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2023_m05_r7 aps_62 (cost=0.00..1.50 rows=40 width=4) (actual time=0.009..0.015 rows=40 loops=1)

  • Output: aps_62.service_id
  • Filter: (aps_62.service_id = 13)
  • Buffers: shared hit=1
71. 0.018 0.018 ↑ 1.0 30 1

Seq Scan on schedule.sr_scgenerated_y2025_m11_r7 aps_63 (cost=0.00..1.38 rows=30 width=4) (actual time=0.012..0.018 rows=30 loops=1)

  • Output: aps_63.service_id
  • Filter: (aps_63.service_id = 13)
  • Buffers: shared hit=1
72. 0.020 0.020 ↑ 1.0 50 1

Seq Scan on schedule.sr_scgenerated_y2022_m10_r7 aps_64 (cost=0.00..1.62 rows=50 width=4) (actual time=0.012..0.020 rows=50 loops=1)

  • Output: aps_64.service_id
  • Filter: (aps_64.service_id = 13)
  • Buffers: shared hit=1
73. 0.013 0.013 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2024_m04_r7 aps_65 (cost=0.00..1.50 rows=40 width=4) (actual time=0.008..0.013 rows=40 loops=1)

  • Output: aps_65.service_id
  • Filter: (aps_65.service_id = 13)
  • Buffers: shared hit=1
74. 0.016 0.016 ↑ 1.0 50 1

Seq Scan on schedule.sr_scgenerated_y2021_m05_r7 aps_66 (cost=0.00..1.62 rows=50 width=4) (actual time=0.009..0.016 rows=50 loops=1)

  • Output: aps_66.service_id
  • Filter: (aps_66.service_id = 13)
  • Buffers: shared hit=1
75. 0.018 0.018 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2025_m10_r7 aps_67 (cost=0.00..1.50 rows=40 width=4) (actual time=0.011..0.018 rows=40 loops=1)

  • Output: aps_67.service_id
  • Filter: (aps_67.service_id = 13)
  • Buffers: shared hit=1
76. 0.016 0.016 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2022_m09_r7 aps_68 (cost=0.00..1.50 rows=40 width=4) (actual time=0.010..0.016 rows=40 loops=1)

  • Output: aps_68.service_id
  • Filter: (aps_68.service_id = 13)
  • Buffers: shared hit=1
77. 0.021 0.021 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2021_m06_r7 aps_69 (cost=0.00..1.50 rows=40 width=4) (actual time=0.014..0.021 rows=40 loops=1)

  • Output: aps_69.service_id
  • Filter: (aps_69.service_id = 13)
  • Buffers: shared hit=1
78. 0.019 0.019 ↑ 1.0 50 1

Seq Scan on schedule.sr_scgenerated_y2024_m03_r7 aps_70 (cost=0.00..1.62 rows=50 width=4) (actual time=0.012..0.019 rows=50 loops=1)

  • Output: aps_70.service_id
  • Filter: (aps_70.service_id = 13)
  • Buffers: shared hit=1
79. 0.022 0.022 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2022_m11_r7 aps_71 (cost=0.00..1.50 rows=40 width=4) (actual time=0.014..0.022 rows=40 loops=1)

  • Output: aps_71.service_id
  • Filter: (aps_71.service_id = 13)
  • Buffers: shared hit=1
80. 0.020 0.020 ↑ 1.0 50 1

Seq Scan on schedule.sr_scgenerated_y2024_m06_r7 aps_72 (cost=0.00..1.62 rows=50 width=4) (actual time=0.013..0.020 rows=50 loops=1)

  • Output: aps_72.service_id
  • Filter: (aps_72.service_id = 13)
  • Buffers: shared hit=1
81. 0.018 0.018 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2021_m04_r7 aps_73 (cost=0.00..1.50 rows=40 width=4) (actual time=0.012..0.018 rows=40 loops=1)

  • Output: aps_73.service_id
  • Filter: (aps_73.service_id = 13)
  • Buffers: shared hit=1
82. 0.017 0.017 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2024_m07_r7 aps_74 (cost=0.00..1.50 rows=40 width=4) (actual time=0.012..0.017 rows=40 loops=1)

  • Output: aps_74.service_id
  • Filter: (aps_74.service_id = 13)
  • Buffers: shared hit=1
83. 0.020 0.020 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2024_m05_r7 aps_75 (cost=0.00..1.50 rows=40 width=4) (actual time=0.012..0.020 rows=40 loops=1)

  • Output: aps_75.service_id
  • Filter: (aps_75.service_id = 13)
  • Buffers: shared hit=1
84. 0.020 0.020 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2021_m02_r7 aps_76 (cost=0.00..1.50 rows=40 width=4) (actual time=0.012..0.020 rows=40 loops=1)

  • Output: aps_76.service_id
  • Filter: (aps_76.service_id = 13)
  • Buffers: shared hit=1
85. 0.020 0.020 ↑ 1.0 50 1

Seq Scan on schedule.sr_scgenerated_y2022_m12_r7 aps_77 (cost=0.00..1.62 rows=50 width=4) (actual time=0.012..0.020 rows=50 loops=1)

  • Output: aps_77.service_id
  • Filter: (aps_77.service_id = 13)
  • Buffers: shared hit=1
86. 0.018 0.018 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2021_m03_r7 aps_78 (cost=0.00..1.50 rows=40 width=4) (actual time=0.012..0.018 rows=40 loops=1)

  • Output: aps_78.service_id
  • Filter: (aps_78.service_id = 13)
  • Buffers: shared hit=1
87. 0.022 0.022 ↑ 1.0 50 1

Seq Scan on schedule.sr_scgenerated_y2023_m12_r7 aps_79 (cost=0.00..1.62 rows=50 width=4) (actual time=0.012..0.022 rows=50 loops=1)

  • Output: aps_79.service_id
  • Filter: (aps_79.service_id = 13)
  • Buffers: shared hit=1
88. 0.016 0.016 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2022_m05_r7 aps_80 (cost=0.00..1.50 rows=40 width=4) (actual time=0.011..0.016 rows=40 loops=1)

  • Output: aps_80.service_id
  • Filter: (aps_80.service_id = 13)
  • Buffers: shared hit=1
89. 0.018 0.018 ↑ 1.0 50 1

Seq Scan on schedule.sr_scgenerated_y2021_m01_r7 aps_81 (cost=0.00..1.62 rows=50 width=4) (actual time=0.011..0.018 rows=50 loops=1)

  • Output: aps_81.service_id
  • Filter: (aps_81.service_id = 13)
  • Buffers: shared hit=1
90. 0.018 0.018 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2020_m12_r7 aps_82 (cost=0.00..1.50 rows=40 width=4) (actual time=0.012..0.018 rows=40 loops=1)

  • Output: aps_82.service_id
  • Filter: (aps_82.service_id = 13)
  • Buffers: shared hit=1
91. 0.019 0.019 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2025_m06_r7 aps_83 (cost=0.00..1.50 rows=40 width=4) (actual time=0.012..0.019 rows=40 loops=1)

  • Output: aps_83.service_id
  • Filter: (aps_83.service_id = 13)
  • Buffers: shared hit=1
92. 0.017 0.017 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2025_m07_r7 aps_84 (cost=0.00..1.50 rows=40 width=4) (actual time=0.010..0.017 rows=40 loops=1)

  • Output: aps_84.service_id
  • Filter: (aps_84.service_id = 13)
  • Buffers: shared hit=1
93. 0.016 0.016 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2023_m11_r7 aps_85 (cost=0.00..1.50 rows=40 width=4) (actual time=0.009..0.016 rows=40 loops=1)

  • Output: aps_85.service_id
  • Filter: (aps_85.service_id = 13)
  • Buffers: shared hit=1
94. 0.020 0.020 ↑ 1.0 50 1

Seq Scan on schedule.sr_scgenerated_y2022_m04_r7 aps_86 (cost=0.00..1.62 rows=50 width=4) (actual time=0.013..0.020 rows=50 loops=1)

  • Output: aps_86.service_id
  • Filter: (aps_86.service_id = 13)
  • Buffers: shared hit=1
95. 0.017 0.017 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2022_m06_r7 aps_87 (cost=0.00..1.50 rows=40 width=4) (actual time=0.008..0.017 rows=40 loops=1)

  • Output: aps_87.service_id
  • Filter: (aps_87.service_id = 13)
  • Buffers: shared hit=1
96. 0.019 0.019 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2024_m01_r7 aps_88 (cost=0.00..1.50 rows=40 width=4) (actual time=0.011..0.019 rows=40 loops=1)

  • Output: aps_88.service_id
  • Filter: (aps_88.service_id = 13)
  • Buffers: shared hit=1
97. 0.015 0.015 ↑ 1.0 50 1

Seq Scan on schedule.sr_scgenerated_y2025_m08_r7 aps_89 (cost=0.00..1.62 rows=50 width=4) (actual time=0.008..0.015 rows=50 loops=1)

  • Output: aps_89.service_id
  • Filter: (aps_89.service_id = 13)
  • Buffers: shared hit=1
98. 0.024 0.024 ↑ 1.0 50 1

Seq Scan on schedule.sr_scgenerated_y2022_m07_r7 aps_90 (cost=0.00..1.62 rows=50 width=4) (actual time=0.014..0.024 rows=50 loops=1)

  • Output: aps_90.service_id
  • Filter: (aps_90.service_id = 13)
  • Buffers: shared hit=1
99. 0.028 0.028 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2024_m02_r7 aps_91 (cost=0.00..1.50 rows=40 width=4) (actual time=0.010..0.028 rows=40 loops=1)

  • Output: aps_91.service_id
  • Filter: (aps_91.service_id = 13)
  • Buffers: shared hit=1
100. 0.028 0.028 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2020_m11_r7 aps_92 (cost=0.00..1.50 rows=40 width=4) (actual time=0.020..0.028 rows=40 loops=1)

  • Output: aps_92.service_id
  • Filter: (aps_92.service_id = 13)
  • Buffers: shared hit=1
101. 0.030 0.030 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2022_m08_r7 aps_93 (cost=0.00..1.50 rows=40 width=4) (actual time=0.014..0.030 rows=40 loops=1)

  • Output: aps_93.service_id
  • Filter: (aps_93.service_id = 13)
  • Buffers: shared hit=1
102. 0.036 0.036 ↑ 1.0 50 1

Seq Scan on schedule.sr_scgenerated_y2020_m10_r7 aps_94 (cost=0.00..1.62 rows=50 width=4) (actual time=0.027..0.036 rows=50 loops=1)

  • Output: aps_94.service_id
  • Filter: (aps_94.service_id = 13)
  • Buffers: shared hit=1
103. 0.020 0.020 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2025_m09_r7 aps_95 (cost=0.00..1.50 rows=40 width=4) (actual time=0.013..0.020 rows=40 loops=1)

  • Output: aps_95.service_id
  • Filter: (aps_95.service_id = 13)
  • Buffers: shared hit=1
104. 0.014 0.014 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2020_m09_r7 aps_96 (cost=0.00..1.50 rows=40 width=4) (actual time=0.009..0.014 rows=40 loops=1)

  • Output: aps_96.service_id
  • Filter: (aps_96.service_id = 13)
  • Buffers: shared hit=1
105. 0.016 0.016 ↑ 1.0 50 1

Seq Scan on schedule.sr_scgenerated_y2020_m08_r7 aps_97 (cost=0.00..1.62 rows=50 width=4) (actual time=0.008..0.016 rows=50 loops=1)

  • Output: aps_97.service_id
  • Filter: (aps_97.service_id = 13)
  • Buffers: shared hit=1
106. 0.013 0.013 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2022_m03_r7 aps_98 (cost=0.00..1.50 rows=40 width=4) (actual time=0.008..0.013 rows=40 loops=1)

  • Output: aps_98.service_id
  • Filter: (aps_98.service_id = 13)
  • Buffers: shared hit=1
107. 0.014 0.014 ↑ 1.0 50 1

Seq Scan on schedule.sr_scgenerated_y2023_m07_r7 aps_99 (cost=0.00..1.62 rows=50 width=4) (actual time=0.008..0.014 rows=50 loops=1)

  • Output: aps_99.service_id
  • Filter: (aps_99.service_id = 13)
  • Buffers: shared hit=1
108. 0.013 0.013 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2025_m02_r7 aps_100 (cost=0.00..1.50 rows=40 width=4) (actual time=0.008..0.013 rows=40 loops=1)

  • Output: aps_100.service_id
  • Filter: (aps_100.service_id = 13)
  • Buffers: shared hit=1
109. 0.013 0.013 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2022_m02_r7 aps_101 (cost=0.00..1.50 rows=40 width=4) (actual time=0.007..0.013 rows=40 loops=1)

  • Output: aps_101.service_id
  • Filter: (aps_101.service_id = 13)
  • Buffers: shared hit=1
110. 0.014 0.014 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2023_m08_r7 aps_102 (cost=0.00..1.50 rows=40 width=4) (actual time=0.007..0.014 rows=40 loops=1)

  • Output: aps_102.service_id
  • Filter: (aps_102.service_id = 13)
  • Buffers: shared hit=1
111. 0.016 0.016 ↑ 1.0 50 1

Seq Scan on schedule.sr_scgenerated_y2025_m03_r7 aps_103 (cost=0.00..1.62 rows=50 width=4) (actual time=0.008..0.016 rows=50 loops=1)

  • Output: aps_103.service_id
  • Filter: (aps_103.service_id = 13)
  • Buffers: shared hit=1
112. 0.016 0.016 ↑ 1.0 50 1

Seq Scan on schedule.sr_scgenerated_y2023_m09_r7 aps_104 (cost=0.00..1.62 rows=50 width=4) (actual time=0.008..0.016 rows=50 loops=1)

  • Output: aps_104.service_id
  • Filter: (aps_104.service_id = 13)
  • Buffers: shared hit=1
113. 0.016 0.016 ↑ 1.0 50 1

Seq Scan on schedule.sr_scgenerated_y2022_m01_r7 aps_105 (cost=0.00..1.62 rows=50 width=4) (actual time=0.007..0.016 rows=50 loops=1)

  • Output: aps_105.service_id
  • Filter: (aps_105.service_id = 13)
  • Buffers: shared hit=1
114. 0.014 0.014 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2020_m07_r7 aps_106 (cost=0.00..1.50 rows=40 width=4) (actual time=0.008..0.014 rows=40 loops=1)

  • Output: aps_106.service_id
  • Filter: (aps_106.service_id = 13)
  • Buffers: shared hit=1
115. 0.014 0.014 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2021_m12_r7 aps_107 (cost=0.00..1.50 rows=40 width=4) (actual time=0.007..0.014 rows=40 loops=1)

  • Output: aps_107.service_id
  • Filter: (aps_107.service_id = 13)
  • Buffers: shared hit=1
116. 0.021 0.040 ↑ 1.0 50 1

Bitmap Heap Scan on schedule.sr_scgenerated_y2020_m05_r7 aps_108 (cost=4.67..17.29 rows=50 width=4) (actual time=0.034..0.040 rows=50 loops=1)

  • Output: aps_108.service_id
  • Recheck Cond: (aps_108.service_id = 13)
  • Heap Blocks: exact=1
  • Buffers: shared hit=3
117. 0.019 0.019 ↑ 1.0 50 1

Bitmap Index Scan on sr_scgenerated_y2020_m05_r7_srv_ix (cost=0.00..4.65 rows=50 width=0) (actual time=0.018..0.019 rows=50 loops=1)

  • Index Cond: (aps_108.service_id = 13)
  • Buffers: shared hit=2
118. 0.021 0.021 ↑ 1.0 50 1

Seq Scan on schedule.sr_scgenerated_y2025_m05_r7 aps_109 (cost=0.00..1.62 rows=50 width=4) (actual time=0.011..0.021 rows=50 loops=1)

  • Output: aps_109.service_id
  • Filter: (aps_109.service_id = 13)
  • Buffers: shared hit=1
119. 0.012 0.012 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2025_m04_r7 aps_110 (cost=0.00..1.50 rows=40 width=4) (actual time=0.007..0.012 rows=40 loops=1)

  • Output: aps_110.service_id
  • Filter: (aps_110.service_id = 13)
  • Buffers: shared hit=1
120. 0.015 0.015 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2020_m06_r7 aps_111 (cost=0.00..1.50 rows=40 width=4) (actual time=0.008..0.015 rows=40 loops=1)

  • Output: aps_111.service_id
  • Filter: (aps_111.service_id = 13)
  • Buffers: shared hit=1
121. 0.013 0.013 ↑ 1.0 40 1

Seq Scan on schedule.sr_scgenerated_y2023_m10_r7 aps_112 (cost=0.00..1.50 rows=40 width=4) (actual time=0.008..0.013 rows=40 loops=1)

  • Output: aps_112.service_id
  • Filter: (aps_112.service_id = 13)
  • Buffers: shared hit=1
Planning time : 8.506 ms
Execution time : 1,348.413 ms