explain.depesz.com

PostgreSQL's explain analyze made readable

Result: C3e1

Settings
# exclusive inclusive rows x rows loops node
1. 18.786 4,560.164 ↑ 123,753.7 3,016 1

Sort (cost=85,395,629.21..85,582,249.75 rows=373,241,075 width=462) (actual time=4,559.826..4,560.164 rows=3,016 loops=1)

  • Sort Key: b.bsnr, r.bsrdnr, ('D'::text)
  • Sort Method: quicksort Memory: 1652kB
2. 0.371 4,541.378 ↑ 123,753.7 3,016 1

Append (cost=795.51..5,841,718.04 rows=373,241,075 width=463) (actual time=437.804..4,541.378 rows=3,016 loops=1)

3. 3.796 3,004.951 ↑ 122,782.1 3,004 1

Hash Join (cost=795.51..242,897.41 rows=368,837,291 width=462) (actual time=437.802..3,004.951 rows=3,004 loops=1)

  • Hash Cond: (r.vranr = tct.vranr)
4. 5.507 2,935.968 ↑ 122,782.1 3,004 1

Nested Loop (cost=0.17..48,268.40 rows=368,837,291 width=428) (actual time=372.346..2,935.968 rows=3,004 loops=1)

5. 0.302 1,777.195 ↑ 1.5 1,403 1

Append (cost=0.08..262.79 rows=2,096 width=131) (actual time=338.850..1,777.195 rows=1,403 loops=1)

6. 39.443 39.443 ↓ 0.0 0 1

Index Scan using tero_part_01_betstnr_betknonr_bsnr_idx on tero_part_01 b (cost=0.08..6.22 rows=51 width=131) (actual time=39.443..39.443 rows=0 loops=1)

  • Index Cond: ((betstnr = '4658'::bpchar) AND (betknonr = 737021))
7. 23.708 23.708 ↓ 0.0 0 1

Index Scan using tero_part_02_betstnr_betknonr_bsnr_idx on tero_part_02 b_1 (cost=0.09..9.66 rows=85 width=131) (actual time=23.708..23.708 rows=0 loops=1)

  • Index Cond: ((betstnr = '4658'::bpchar) AND (betknonr = 737021))
8. 44.302 44.302 ↓ 0.0 0 1

Index Scan using tero_part_03_betstnr_betknonr_bsnr_idx on tero_part_03 b_2 (cost=0.08..7.09 rows=58 width=131) (actual time=44.302..44.302 rows=0 loops=1)

  • Index Cond: ((betstnr = '4658'::bpchar) AND (betknonr = 737021))
9. 76.761 76.761 ↓ 0.0 0 1

Index Scan using tero_part_04_betstnr_betknonr_bsnr_idx on tero_part_04 b_3 (cost=0.08..10.06 rows=83 width=131) (actual time=76.761..76.761 rows=0 loops=1)

  • Index Cond: ((betstnr = '4658'::bpchar) AND (betknonr = 737021))
10. 48.795 48.795 ↓ 0.0 0 1

Index Scan using tero_part_05_betstnr_betknonr_bsnr_idx on tero_part_05 b_4 (cost=0.08..7.53 rows=62 width=131) (actual time=48.795..48.795 rows=0 loops=1)

  • Index Cond: ((betstnr = '4658'::bpchar) AND (betknonr = 737021))
11. 45.104 45.104 ↓ 0.0 0 1

Index Scan using tero_part_06_betstnr_betknonr_bsnr_idx on tero_part_06 b_5 (cost=0.08..8.68 rows=71 width=131) (actual time=45.104..45.104 rows=0 loops=1)

  • Index Cond: ((betstnr = '4658'::bpchar) AND (betknonr = 737021))
12. 143.352 143.352 ↓ 19.9 1,394 1

Index Scan using tero_part_07_betstnr_betknonr_bsnr_idx on tero_part_07 b_6 (cost=0.08..8.29 rows=70 width=131) (actual time=60.716..143.352 rows=1,394 loops=1)

  • Index Cond: ((betstnr = '4658'::bpchar) AND (betknonr = 737021))
13. 34.418 34.418 ↓ 0.0 0 1

Index Scan using tero_part_08_betstnr_betknonr_bsnr_idx on tero_part_08 b_7 (cost=0.08..7.33 rows=60 width=131) (actual time=34.418..34.418 rows=0 loops=1)

  • Index Cond: ((betstnr = '4658'::bpchar) AND (betknonr = 737021))
14. 162.008 162.008 ↓ 0.0 0 1

Index Scan using tero_part_09_betstnr_betknonr_bsnr_idx on tero_part_09 b_8 (cost=0.09..10.98 rows=90 width=131) (actual time=162.008..162.008 rows=0 loops=1)

  • Index Cond: ((betstnr = '4658'::bpchar) AND (betknonr = 737021))
15. 145.077 145.077 ↑ 90.0 1 1

Index Scan using tero_part_10_betstnr_betknonr_bsnr_idx on tero_part_10 b_9 (cost=0.09..10.77 rows=90 width=131) (actual time=145.074..145.077 rows=1 loops=1)

  • Index Cond: ((betstnr = '4658'::bpchar) AND (betknonr = 737021))
16. 109.053 109.053 ↑ 81.4 5 1

Index Scan using tero_part_11_betstnr_betknonr_bsnr_idx on tero_part_11 b_10 (cost=0.11..48.12 rows=407 width=131) (actual time=109.012..109.053 rows=5 loops=1)

  • Index Cond: ((betstnr = '4658'::bpchar) AND (betknonr = 737021))
17. 24.925 24.925 ↓ 0.0 0 1

Index Scan using tero_part_12_betstnr_betknonr_bsnr_idx on tero_part_12 b_11 (cost=0.08..8.87 rows=74 width=131) (actual time=24.925..24.925 rows=0 loops=1)

  • Index Cond: ((betstnr = '4658'::bpchar) AND (betknonr = 737021))
18. 112.942 112.942 ↑ 68.3 3 1

Index Scan using tero_part_13_betstnr_betknonr_bsnr_idx on tero_part_13 b_12 (cost=0.09..24.91 rows=205 width=131) (actual time=112.934..112.942 rows=3 loops=1)

  • Index Cond: ((betstnr = '4658'::bpchar) AND (betknonr = 737021))
19. 44.513 44.513 ↓ 0.0 0 1

Index Scan using tero_part_14_betstnr_betknonr_bsnr_idx on tero_part_14 b_13 (cost=0.08..9.55 rows=78 width=131) (actual time=44.513..44.513 rows=0 loops=1)

  • Index Cond: ((betstnr = '4658'::bpchar) AND (betknonr = 737021))
20. 67.227 67.227 ↓ 0.0 0 1

Index Scan using tero_part_15_betstnr_betknonr_bsnr_idx on tero_part_15 b_14 (cost=0.08..6.70 rows=55 width=131) (actual time=67.227..67.227 rows=0 loops=1)

  • Index Cond: ((betstnr = '4658'::bpchar) AND (betknonr = 737021))
21. 16.557 16.557 ↓ 0.0 0 1

Index Scan using tero_part_16_betstnr_betknonr_bsnr_idx on tero_part_16 b_15 (cost=0.08..8.69 rows=72 width=131) (actual time=16.557..16.557 rows=0 loops=1)

  • Index Cond: ((betstnr = '4658'::bpchar) AND (betknonr = 737021))
22. 200.286 200.286 ↓ 0.0 0 1

Index Scan using tero_part_17_betstnr_betknonr_bsnr_idx on tero_part_17 b_16 (cost=0.08..8.84 rows=73 width=131) (actual time=200.286..200.286 rows=0 loops=1)

  • Index Cond: ((betstnr = '4658'::bpchar) AND (betknonr = 737021))
23. 14.419 14.419 ↓ 0.0 0 1

Index Scan using tero_part_18_betstnr_betknonr_bsnr_idx on tero_part_18 b_17 (cost=0.08..8.15 rows=67 width=131) (actual time=14.419..14.419 rows=0 loops=1)

  • Index Cond: ((betstnr = '4658'::bpchar) AND (betknonr = 737021))
24. 74.798 74.798 ↓ 0.0 0 1

Index Scan using tero_part_19_betstnr_betknonr_bsnr_idx on tero_part_19 b_18 (cost=0.08..6.78 rows=56 width=131) (actual time=74.798..74.798 rows=0 loops=1)

  • Index Cond: ((betstnr = '4658'::bpchar) AND (betknonr = 737021))
25. 0.029 0.029 ↓ 0.0 0 1

Index Scan using tero_part_20_betstnr_betknonr_bsnr_idx on tero_part_20 b_19 (cost=0.03..0.25 rows=1 width=434) (actual time=0.029..0.029 rows=0 loops=1)

  • Index Cond: ((betstnr = '4658'::bpchar) AND (betknonr = 737021))
26. 68.099 68.099 ↓ 0.0 0 1

Index Scan using tero_part_21_betstnr_betknonr_bsnr_idx on tero_part_21 b_20 (cost=0.09..10.18 rows=83 width=131) (actual time=68.098..68.099 rows=0 loops=1)

  • Index Cond: ((betstnr = '4658'::bpchar) AND (betknonr = 737021))
27. 41.776 41.776 ↓ 0.0 0 1

Index Scan using tero_part_22_betstnr_betknonr_bsnr_idx on tero_part_22 b_21 (cost=0.09..2.22 rows=18 width=131) (actual time=41.776..41.776 rows=0 loops=1)

  • Index Cond: ((betstnr = '4658'::bpchar) AND (betknonr = 737021))
28. 194.185 194.185 ↓ 0.0 0 1

Index Scan using tero_part_23_betstnr_betknonr_bsnr_idx on tero_part_23 b_22 (cost=0.09..12.80 rows=107 width=131) (actual time=194.185..194.185 rows=0 loops=1)

  • Index Cond: ((betstnr = '4658'::bpchar) AND (betknonr = 737021))
29. 45.082 45.082 ↓ 0.0 0 1

Index Scan using tero_part_24_betstnr_betknonr_bsnr_idx on tero_part_24 b_23 (cost=0.08..9.39 rows=79 width=131) (actual time=45.082..45.082 rows=0 loops=1)

  • Index Cond: ((betstnr = '4658'::bpchar) AND (betknonr = 737021))
30. 0.034 0.034 ↓ 0.0 0 1

Index Scan using tero_part_default_betstnr_betknonr_bsnr_idx on tero_part_default b_24 (cost=0.03..0.25 rows=1 width=434) (actual time=0.034..0.034 rows=0 loops=1)

  • Index Cond: ((betstnr = '4658'::bpchar) AND (betknonr = 737021))
31. 5.820 1,153.266 ↑ 94.5 2 1,403

Append (cost=0.09..21.01 rows=189 width=306) (actual time=0.400..0.822 rows=2 loops=1,403)

32. 0.000 0.000 ↓ 0.0 0

Index Scan using teror_part_01_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_01 r (cost=0.09..0.78 rows=8 width=306) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 74))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
33. 0.000 0.000 ↓ 0.0 0

Index Scan using teror_part_02_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_02 r_1 (cost=0.09..0.84 rows=8 width=304) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 74))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
34. 0.000 0.000 ↓ 0.0 0

Index Scan using teror_part_03_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_03 r_2 (cost=0.09..0.74 rows=7 width=306) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 74))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
35. 0.000 0.000 ↓ 0.0 0

Index Scan using teror_part_04_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_04 r_3 (cost=0.09..0.87 rows=8 width=306) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 74))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
36. 0.000 0.000 ↓ 0.0 0

Index Scan using teror_part_05_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_05 r_4 (cost=0.09..0.79 rows=7 width=306) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 74))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
37. 0.000 0.000 ↓ 0.0 0

Index Scan using teror_part_06_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_06 r_5 (cost=0.09..0.91 rows=8 width=306) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 74))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
38. 1,046.894 1,046.894 ↑ 4.0 2 1,394

Index Scan using teror_part_07_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_07 r_6 (cost=0.09..0.86 rows=8 width=306) (actual time=0.327..0.751 rows=2 loops=1,394)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 74))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
39. 0.000 0.000 ↓ 0.0 0

Index Scan using teror_part_08_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_08 r_7 (cost=0.09..0.69 rows=6 width=306) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 74))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
40. 0.000 0.000 ↓ 0.0 0

Index Scan using teror_part_09_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_09 r_8 (cost=0.09..0.83 rows=8 width=306) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 74))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
41. 18.465 18.465 ↓ 0.0 0 1

Index Scan using teror_part_10_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_10 r_9 (cost=0.09..0.89 rows=8 width=306) (actual time=18.465..18.465 rows=0 loops=1)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 74))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
42. 80.410 80.410 ↓ 0.0 0 5

Index Scan using teror_part_11_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_11 r_10 (cost=0.09..0.72 rows=6 width=306) (actual time=16.082..16.082 rows=0 loops=5)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 74))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
43. 0.000 0.000 ↓ 0.0 0

Index Scan using teror_part_12_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_12 r_11 (cost=0.09..0.86 rows=8 width=306) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 74))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
44. 1.677 1.677 ↓ 0.0 0 3

Index Scan using teror_part_13_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_13 r_12 (cost=0.09..0.30 rows=1 width=306) (actual time=0.559..0.559 rows=0 loops=3)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 74))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
45. 0.000 0.000 ↓ 0.0 0

Index Scan using teror_part_14_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_14 r_13 (cost=0.09..0.83 rows=8 width=306) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 74))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
46. 0.000 0.000 ↓ 0.0 0

Index Scan using teror_part_15_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_15 r_14 (cost=0.09..0.87 rows=8 width=306) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 74))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
47. 0.000 0.000 ↓ 0.0 0

Index Scan using teror_part_16_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_16 r_15 (cost=0.09..0.86 rows=8 width=306) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 74))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
48. 0.000 0.000 ↓ 0.0 0

Index Scan using teror_part_17_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_17 r_16 (cost=0.09..0.81 rows=8 width=306) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 74))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
49. 0.000 0.000 ↓ 0.0 0

Index Scan using teror_part_18_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_18 r_17 (cost=0.09..0.80 rows=8 width=306) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 74))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
50. 0.000 0.000 ↓ 0.0 0

Index Scan using teror_part_19_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_19 r_18 (cost=0.09..0.83 rows=8 width=306) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 74))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
51. 0.000 0.000 ↓ 0.0 0

Index Scan using teror_part_20_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_20 r_19 (cost=0.03..0.05 rows=1 width=1,154) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 74))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
52. 0.000 0.000 ↓ 0.0 0

Index Scan using teror_part_21_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_21 r_20 (cost=0.09..1.27 rows=13 width=306) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 74))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
53. 0.000 0.000 ↓ 0.0 0

Index Scan using teror_part_22_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_22 r_21 (cost=0.09..2.09 rows=21 width=306) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 74))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
54. 0.000 0.000 ↓ 0.0 0

Index Scan using teror_part_23_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_23 r_22 (cost=0.09..0.69 rows=6 width=306) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 74))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
55. 0.000 0.000 ↓ 0.0 0

Index Scan using teror_part_24_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_24 r_23 (cost=0.09..0.84 rows=8 width=306) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 74))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
56. 0.000 0.000 ↓ 0.0 0

Index Scan using teror_part_default_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_default r_24 (cost=0.03..0.05 rows=1 width=1,154) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 74))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
57. 6.939 65.187 ↑ 1.0 19,431 1

Hash (cost=591.31..591.31 rows=19,431 width=6) (actual time=65.186..65.187 rows=19,431 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1016kB
58. 58.248 58.248 ↑ 1.0 19,431 1

Seq Scan on tct (cost=0.00..591.31 rows=19,431 width=6) (actual time=3.286..58.248 rows=19,431 loops=1)

59. 0.138 1,536.056 ↑ 366,982.0 12 1

Nested Loop (cost=0.23..204.51 rows=4,403,784 width=526) (actual time=420.543..1,536.056 rows=12 loops=1)

60. 0.059 1,238.630 ↑ 2.1 12 1

Nested Loop (cost=0.14..14.67 rows=25 width=374) (actual time=350.582..1,238.630 rows=12 loops=1)

61. 0.078 1,231.419 ↑ 2.1 12 1

Append (cost=0.09..8.12 rows=25 width=374) (actual time=344.743..1,231.419 rows=12 loops=1)

62. 36.478 36.478 ↓ 0.0 0 1

Index Scan using teror_part_01_kdtstnr_kdtknonr_bsnr_bsrdnr_idx on teror_part_01 r_25 (cost=0.09..0.31 rows=1 width=306) (actual time=36.478..36.478 rows=0 loops=1)

  • Index Cond: ((kdtstnr = '4658'::bpchar) AND (kdtknonr = 737021))
  • Filter: ((bsrdstakod <> ALL ('{FL,AN}'::bpchar[])) AND (kdtrdvprcnr = 74))
63. 24.118 24.118 ↓ 0.0 0 1

Index Scan using teror_part_02_kdtstnr_kdtknonr_bsnr_bsrdnr_idx on teror_part_02 r_26 (cost=0.09..0.31 rows=1 width=304) (actual time=24.118..24.118 rows=0 loops=1)

  • Index Cond: ((kdtstnr = '4658'::bpchar) AND (kdtknonr = 737021))
  • Filter: ((bsrdstakod <> ALL ('{FL,AN}'::bpchar[])) AND (kdtrdvprcnr = 74))
64. 24.732 24.732 ↓ 0.0 0 1

Index Scan using teror_part_03_kdtstnr_kdtknonr_bsnr_bsrdnr_idx on teror_part_03 r_27 (cost=0.09..0.31 rows=1 width=306) (actual time=24.732..24.732 rows=0 loops=1)

  • Index Cond: ((kdtstnr = '4658'::bpchar) AND (kdtknonr = 737021))
  • Filter: ((bsrdstakod <> ALL ('{FL,AN}'::bpchar[])) AND (kdtrdvprcnr = 74))
65. 125.680 125.680 ↓ 0.0 0 1

Index Scan using teror_part_04_kdtstnr_kdtknonr_bsnr_bsrdnr_idx on teror_part_04 r_28 (cost=0.09..0.31 rows=1 width=306) (actual time=125.680..125.680 rows=0 loops=1)

  • Index Cond: ((kdtstnr = '4658'::bpchar) AND (kdtknonr = 737021))
  • Filter: ((bsrdstakod <> ALL ('{FL,AN}'::bpchar[])) AND (kdtrdvprcnr = 74))
66. 54.361 54.361 ↓ 0.0 0 1

Index Scan using teror_part_05_kdtstnr_kdtknonr_bsnr_bsrdnr_idx on teror_part_05 r_29 (cost=0.09..0.31 rows=1 width=306) (actual time=54.361..54.361 rows=0 loops=1)

  • Index Cond: ((kdtstnr = '4658'::bpchar) AND (kdtknonr = 737021))
  • Filter: ((bsrdstakod <> ALL ('{FL,AN}'::bpchar[])) AND (kdtrdvprcnr = 74))
67. 33.789 33.789 ↓ 0.0 0 1

Index Scan using teror_part_06_kdtstnr_kdtknonr_bsnr_bsrdnr_idx on teror_part_06 r_30 (cost=0.09..0.31 rows=1 width=306) (actual time=33.789..33.789 rows=0 loops=1)

  • Index Cond: ((kdtstnr = '4658'::bpchar) AND (kdtknonr = 737021))
  • Filter: ((bsrdstakod <> ALL ('{FL,AN}'::bpchar[])) AND (kdtrdvprcnr = 74))
68. 45.639 45.639 ↓ 12.0 12 1

Index Scan using teror_part_07_kdtstnr_kdtknonr_bsnr_bsrdnr_idx on teror_part_07 r_31 (cost=0.09..0.31 rows=1 width=306) (actual time=45.566..45.639 rows=12 loops=1)

  • Index Cond: ((kdtstnr = '4658'::bpchar) AND (kdtknonr = 737021))
  • Filter: ((bsrdstakod <> ALL ('{FL,AN}'::bpchar[])) AND (kdtrdvprcnr = 74))
69. 229.183 229.183 ↓ 0.0 0 1

Index Scan using teror_part_08_kdtstnr_kdtknonr_bsnr_bsrdnr_idx on teror_part_08 r_32 (cost=0.09..0.31 rows=1 width=306) (actual time=229.183..229.183 rows=0 loops=1)

  • Index Cond: ((kdtstnr = '4658'::bpchar) AND (kdtknonr = 737021))
  • Filter: ((bsrdstakod <> ALL ('{FL,AN}'::bpchar[])) AND (kdtrdvprcnr = 74))
70. 161.102 161.102 ↓ 0.0 0 1

Index Scan using teror_part_09_kdtstnr_kdtknonr_bsnr_bsrdnr_idx on teror_part_09 r_33 (cost=0.09..0.31 rows=1 width=306) (actual time=161.102..161.102 rows=0 loops=1)

  • Index Cond: ((kdtstnr = '4658'::bpchar) AND (kdtknonr = 737021))
  • Filter: ((bsrdstakod <> ALL ('{FL,AN}'::bpchar[])) AND (kdtrdvprcnr = 74))
71. 19.942 19.942 ↓ 0.0 0 1

Index Scan using teror_part_10_kdtstnr_kdtknonr_bsnr_bsrdnr_idx on teror_part_10 r_34 (cost=0.09..0.31 rows=1 width=306) (actual time=19.942..19.942 rows=0 loops=1)

  • Index Cond: ((kdtstnr = '4658'::bpchar) AND (kdtknonr = 737021))
  • Filter: ((bsrdstakod <> ALL ('{FL,AN}'::bpchar[])) AND (kdtrdvprcnr = 74))
72. 30.316 30.316 ↓ 0.0 0 1

Index Scan using teror_part_11_kdtstnr_kdtknonr_bsnr_bsrdnr_idx on teror_part_11 r_35 (cost=0.11..0.55 rows=1 width=306) (actual time=30.315..30.316 rows=0 loops=1)

  • Index Cond: ((kdtstnr = '4658'::bpchar) AND (kdtknonr = 737021))
  • Filter: ((bsrdstakod <> ALL ('{FL,AN}'::bpchar[])) AND (kdtrdvprcnr = 74))
73. 56.346 56.346 ↓ 0.0 0 1

Index Scan using teror_part_12_kdtstnr_kdtknonr_bsnr_bsrdnr_idx on teror_part_12 r_36 (cost=0.09..0.31 rows=1 width=306) (actual time=56.346..56.346 rows=0 loops=1)

  • Index Cond: ((kdtstnr = '4658'::bpchar) AND (kdtknonr = 737021))
  • Filter: ((bsrdstakod <> ALL ('{FL,AN}'::bpchar[])) AND (kdtrdvprcnr = 74))
74. 55.285 55.285 ↓ 0.0 0 1

Index Scan using teror_part_13_kdtstnr_kdtknonr_bsnr_bsrdnr_idx on teror_part_13 r_37 (cost=0.11..0.48 rows=1 width=306) (actual time=55.285..55.285 rows=0 loops=1)

  • Index Cond: ((kdtstnr = '4658'::bpchar) AND (kdtknonr = 737021))
  • Filter: ((bsrdstakod <> ALL ('{FL,AN}'::bpchar[])) AND (kdtrdvprcnr = 74))
75. 15.468 15.468 ↓ 0.0 0 1

Index Scan using teror_part_14_kdtstnr_kdtknonr_bsnr_bsrdnr_idx on teror_part_14 r_38 (cost=0.09..0.31 rows=1 width=306) (actual time=15.468..15.468 rows=0 loops=1)

  • Index Cond: ((kdtstnr = '4658'::bpchar) AND (kdtknonr = 737021))
  • Filter: ((bsrdstakod <> ALL ('{FL,AN}'::bpchar[])) AND (kdtrdvprcnr = 74))
76. 26.178 26.178 ↓ 0.0 0 1

Index Scan using teror_part_15_kdtstnr_kdtknonr_bsnr_bsrdnr_idx on teror_part_15 r_39 (cost=0.09..0.31 rows=1 width=306) (actual time=26.177..26.178 rows=0 loops=1)

  • Index Cond: ((kdtstnr = '4658'::bpchar) AND (kdtknonr = 737021))
  • Filter: ((bsrdstakod <> ALL ('{FL,AN}'::bpchar[])) AND (kdtrdvprcnr = 74))
77. 39.311 39.311 ↓ 0.0 0 1

Index Scan using teror_part_16_kdtstnr_kdtknonr_bsnr_bsrdnr_idx on teror_part_16 r_40 (cost=0.09..0.31 rows=1 width=306) (actual time=39.311..39.311 rows=0 loops=1)

  • Index Cond: ((kdtstnr = '4658'::bpchar) AND (kdtknonr = 737021))
  • Filter: ((bsrdstakod <> ALL ('{FL,AN}'::bpchar[])) AND (kdtrdvprcnr = 74))
78. 46.144 46.144 ↓ 0.0 0 1

Index Scan using teror_part_17_kdtstnr_kdtknonr_bsnr_bsrdnr_idx on teror_part_17 r_41 (cost=0.09..0.31 rows=1 width=306) (actual time=46.144..46.144 rows=0 loops=1)

  • Index Cond: ((kdtstnr = '4658'::bpchar) AND (kdtknonr = 737021))
  • Filter: ((bsrdstakod <> ALL ('{FL,AN}'::bpchar[])) AND (kdtrdvprcnr = 74))
79. 21.286 21.286 ↓ 0.0 0 1

Index Scan using teror_part_18_kdtstnr_kdtknonr_bsnr_bsrdnr_idx on teror_part_18 r_42 (cost=0.09..0.31 rows=1 width=306) (actual time=21.286..21.286 rows=0 loops=1)

  • Index Cond: ((kdtstnr = '4658'::bpchar) AND (kdtknonr = 737021))
  • Filter: ((bsrdstakod <> ALL ('{FL,AN}'::bpchar[])) AND (kdtrdvprcnr = 74))
80. 79.553 79.553 ↓ 0.0 0 1

Index Scan using teror_part_19_kdtstnr_kdtknonr_bsnr_bsrdnr_idx on teror_part_19 r_43 (cost=0.09..0.31 rows=1 width=306) (actual time=79.553..79.553 rows=0 loops=1)

  • Index Cond: ((kdtstnr = '4658'::bpchar) AND (kdtknonr = 737021))
  • Filter: ((bsrdstakod <> ALL ('{FL,AN}'::bpchar[])) AND (kdtrdvprcnr = 74))
81. 0.051 0.051 ↓ 0.0 0 1

Index Scan using teror_part_20_kdtstnr_kdtknonr_bsnr_bsrdnr_idx on teror_part_20 r_44 (cost=0.03..0.25 rows=1 width=1,154) (actual time=0.051..0.051 rows=0 loops=1)

  • Index Cond: ((kdtstnr = '4658'::bpchar) AND (kdtknonr = 737021))
  • Filter: ((bsrdstakod <> ALL ('{FL,AN}'::bpchar[])) AND (kdtrdvprcnr = 74))
82. 36.940 36.940 ↓ 0.0 0 1

Index Scan using teror_part_21_kdtstnr_kdtknonr_bsnr_bsrdnr_idx on teror_part_21 r_45 (cost=0.09..0.31 rows=1 width=306) (actual time=36.940..36.940 rows=0 loops=1)

  • Index Cond: ((kdtstnr = '4658'::bpchar) AND (kdtknonr = 737021))
  • Filter: ((bsrdstakod <> ALL ('{FL,AN}'::bpchar[])) AND (kdtrdvprcnr = 74))
83. 11.700 11.700 ↓ 0.0 0 1

Index Scan using teror_part_22_kdtstnr_kdtknonr_bsnr_bsrdnr_idx on teror_part_22 r_46 (cost=0.09..0.31 rows=1 width=306) (actual time=11.700..11.700 rows=0 loops=1)

  • Index Cond: ((kdtstnr = '4658'::bpchar) AND (kdtknonr = 737021))
  • Filter: ((bsrdstakod <> ALL ('{FL,AN}'::bpchar[])) AND (kdtrdvprcnr = 74))
84. 29.415 29.415 ↓ 0.0 0 1

Index Scan using teror_part_23_kdtstnr_kdtknonr_bsnr_bsrdnr_idx on teror_part_23 r_47 (cost=0.09..0.31 rows=1 width=306) (actual time=29.415..29.415 rows=0 loops=1)

  • Index Cond: ((kdtstnr = '4658'::bpchar) AND (kdtknonr = 737021))
  • Filter: ((bsrdstakod <> ALL ('{FL,AN}'::bpchar[])) AND (kdtrdvprcnr = 74))
85. 28.272 28.272 ↓ 0.0 0 1

Index Scan using teror_part_24_kdtstnr_kdtknonr_bsnr_bsrdnr_idx on teror_part_24 r_48 (cost=0.09..0.31 rows=1 width=306) (actual time=28.272..28.272 rows=0 loops=1)

  • Index Cond: ((kdtstnr = '4658'::bpchar) AND (kdtknonr = 737021))
  • Filter: ((bsrdstakod <> ALL ('{FL,AN}'::bpchar[])) AND (kdtrdvprcnr = 74))
86. 0.052 0.052 ↓ 0.0 0 1

Index Scan using teror_part_default_kdtstnr_kdtknonr_bsnr_bsrdnr_idx on teror_part_default r_49 (cost=0.03..0.25 rows=1 width=1,154) (actual time=0.052..0.052 rows=0 loops=1)

  • Index Cond: ((kdtstnr = '4658'::bpchar) AND (kdtknonr = 737021))
  • Filter: ((bsrdstakod <> ALL ('{FL,AN}'::bpchar[])) AND (kdtrdvprcnr = 74))
87. 7.152 7.152 ↑ 1.0 1 12

Index Only Scan using ux_tct_04 on tct tct_1 (cost=0.06..0.26 rows=1 width=6) (actual time=0.596..0.596 rows=1 loops=12)

  • Index Cond: (vranr = r_25.vranr)
  • Heap Fetches: 12
88. 0.096 297.288 ↑ 25.0 1 12

Append (cost=0.08..7.34 rows=25 width=131) (actual time=24.772..24.774 rows=1 loops=12)

89. 0.000 0.000 ↓ 0.0 0

Index Scan using tero_part_01_pkey on tero_part_01 b_25 (cost=0.08..0.31 rows=1 width=131) (never executed)

  • Index Cond: (bsnr = r_25.bsnr)
90. 0.000 0.000 ↓ 0.0 0

Index Scan using tero_part_02_pkey on tero_part_02 b_26 (cost=0.09..0.31 rows=1 width=131) (never executed)

  • Index Cond: (bsnr = r_25.bsnr)
91. 0.000 0.000 ↓ 0.0 0

Index Scan using tero_part_03_pkey on tero_part_03 b_27 (cost=0.08..0.31 rows=1 width=131) (never executed)

  • Index Cond: (bsnr = r_25.bsnr)
92. 0.000 0.000 ↓ 0.0 0

Index Scan using tero_part_04_pkey on tero_part_04 b_28 (cost=0.08..0.31 rows=1 width=131) (never executed)

  • Index Cond: (bsnr = r_25.bsnr)
93. 0.000 0.000 ↓ 0.0 0

Index Scan using tero_part_05_pkey on tero_part_05 b_29 (cost=0.08..0.31 rows=1 width=131) (never executed)

  • Index Cond: (bsnr = r_25.bsnr)
94. 0.000 0.000 ↓ 0.0 0

Index Scan using tero_part_06_pkey on tero_part_06 b_30 (cost=0.08..0.31 rows=1 width=131) (never executed)

  • Index Cond: (bsnr = r_25.bsnr)
95. 297.192 297.192 ↑ 1.0 1 12

Index Scan using tero_part_07_pkey on tero_part_07 b_31 (cost=0.08..0.31 rows=1 width=131) (actual time=24.765..24.766 rows=1 loops=12)

  • Index Cond: (bsnr = r_25.bsnr)
96. 0.000 0.000 ↓ 0.0 0

Index Scan using tero_part_08_pkey on tero_part_08 b_32 (cost=0.08..0.31 rows=1 width=131) (never executed)

  • Index Cond: (bsnr = r_25.bsnr)
97. 0.000 0.000 ↓ 0.0 0

Index Scan using tero_part_09_pkey on tero_part_09 b_33 (cost=0.09..0.31 rows=1 width=131) (never executed)

  • Index Cond: (bsnr = r_25.bsnr)
98. 0.000 0.000 ↓ 0.0 0

Index Scan using tero_part_10_pkey on tero_part_10 b_34 (cost=0.09..0.31 rows=1 width=131) (never executed)

  • Index Cond: (bsnr = r_25.bsnr)
99. 0.000 0.000 ↓ 0.0 0

Index Scan using tero_part_11_pkey on tero_part_11 b_35 (cost=0.09..0.31 rows=1 width=131) (never executed)

  • Index Cond: (bsnr = r_25.bsnr)
100. 0.000 0.000 ↓ 0.0 0

Index Scan using tero_part_12_pkey on tero_part_12 b_36 (cost=0.08..0.31 rows=1 width=131) (never executed)

  • Index Cond: (bsnr = r_25.bsnr)
101. 0.000 0.000 ↓ 0.0 0

Index Scan using tero_part_13_pkey on tero_part_13 b_37 (cost=0.09..0.31 rows=1 width=131) (never executed)

  • Index Cond: (bsnr = r_25.bsnr)
102. 0.000 0.000 ↓ 0.0 0

Index Scan using tero_part_14_pkey on tero_part_14 b_38 (cost=0.08..0.31 rows=1 width=131) (never executed)

  • Index Cond: (bsnr = r_25.bsnr)
103. 0.000 0.000 ↓ 0.0 0

Index Scan using tero_part_15_pkey on tero_part_15 b_39 (cost=0.08..0.31 rows=1 width=131) (never executed)

  • Index Cond: (bsnr = r_25.bsnr)
104. 0.000 0.000 ↓ 0.0 0

Index Scan using tero_part_16_pkey on tero_part_16 b_40 (cost=0.08..0.31 rows=1 width=131) (never executed)

  • Index Cond: (bsnr = r_25.bsnr)
105. 0.000 0.000 ↓ 0.0 0

Index Scan using tero_part_17_pkey on tero_part_17 b_41 (cost=0.08..0.31 rows=1 width=131) (never executed)

  • Index Cond: (bsnr = r_25.bsnr)
106. 0.000 0.000 ↓ 0.0 0

Index Scan using tero_part_18_pkey on tero_part_18 b_42 (cost=0.08..0.31 rows=1 width=131) (never executed)

  • Index Cond: (bsnr = r_25.bsnr)
107. 0.000 0.000 ↓ 0.0 0

Index Scan using tero_part_19_pkey on tero_part_19 b_43 (cost=0.08..0.31 rows=1 width=131) (never executed)

  • Index Cond: (bsnr = r_25.bsnr)
108. 0.000 0.000 ↓ 0.0 0

Index Scan using tero_part_20_pkey on tero_part_20 b_44 (cost=0.03..0.09 rows=1 width=434) (never executed)

  • Index Cond: (bsnr = r_25.bsnr)
109. 0.000 0.000 ↓ 0.0 0

Index Scan using tero_part_21_pkey on tero_part_21 b_45 (cost=0.09..0.31 rows=1 width=131) (never executed)

  • Index Cond: (bsnr = r_25.bsnr)
110. 0.000 0.000 ↓ 0.0 0

Index Scan using tero_part_22_pkey on tero_part_22 b_46 (cost=0.09..0.31 rows=1 width=131) (never executed)

  • Index Cond: (bsnr = r_25.bsnr)
111. 0.000 0.000 ↓ 0.0 0

Index Scan using tero_part_23_pkey on tero_part_23 b_47 (cost=0.09..0.31 rows=1 width=131) (never executed)

  • Index Cond: (bsnr = r_25.bsnr)
112. 0.000 0.000 ↓ 0.0 0

Index Scan using tero_part_24_pkey on tero_part_24 b_48 (cost=0.08..0.31 rows=1 width=131) (never executed)

  • Index Cond: (bsnr = r_25.bsnr)
113. 0.000 0.000 ↓ 0.0 0

Index Scan using tero_part_default_pkey on tero_part_default b_49 (cost=0.03..0.09 rows=1 width=434) (never executed)

  • Index Cond: (bsnr = r_25.bsnr)
Planning time : 2,391.761 ms
Execution time : 4,568.471 ms