explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Jd8w

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Sort (cost=104,463,307,482.02..104,590,582,114.62 rows=254,549,265,194 width=463) (actual rows= loops=)

  • Sort Key: b.bsnr, r.bsrdnr, ('D'::text)
2. 0.000 0.000 ↓ 0.0

Append (cost=656.61..3,837,175,536.57 rows=254,549,265,194 width=463) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash Join (cost=656.61..1,571.87 rows=24,283 width=489) (actual rows= loops=)

  • Hash Cond: (r.vranr = tct.vranr)
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.17..902.67 rows=24,283 width=455) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Append (cost=0.08..47.24 rows=25 width=155) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Index Scan using tero_part_01_betstnr_betknonr_bsnr_idx on tero_part_01 b (cost=0.08..2.11 rows=1 width=131) (actual rows= loops=)

  • Index Cond: ((betstnr = '8998'::bpchar) AND (betknonr = 711547))
7. 0.000 0.000 ↓ 0.0

Index Scan using tero_part_02_betstnr_betknonr_bsnr_idx on tero_part_02 b_1 (cost=0.08..2.11 rows=1 width=131) (actual rows= loops=)

  • Index Cond: ((betstnr = '8998'::bpchar) AND (betknonr = 711547))
8. 0.000 0.000 ↓ 0.0

Index Scan using tero_part_03_betstnr_betknonr_bsnr_idx on tero_part_03 b_2 (cost=0.08..2.11 rows=1 width=131) (actual rows= loops=)

  • Index Cond: ((betstnr = '8998'::bpchar) AND (betknonr = 711547))
9. 0.000 0.000 ↓ 0.0

Index Scan using tero_part_04_betstnr_betknonr_bsnr_idx on tero_part_04 b_3 (cost=0.08..2.10 rows=1 width=131) (actual rows= loops=)

  • Index Cond: ((betstnr = '8998'::bpchar) AND (betknonr = 711547))
10. 0.000 0.000 ↓ 0.0

Seq Scan on tero_part_05 b_4 (cost=0.00..1.03 rows=1 width=132) (actual rows= loops=)

  • Filter: ((betknonr = 711547) AND (betstnr = '8998'::bpchar))
11. 0.000 0.000 ↓ 0.0

Seq Scan on tero_part_06 b_5 (cost=0.00..1.04 rows=1 width=131) (actual rows= loops=)

  • Filter: ((betknonr = 711547) AND (betstnr = '8998'::bpchar))
12. 0.000 0.000 ↓ 0.0

Seq Scan on tero_part_07 b_6 (cost=0.00..1.09 rows=1 width=131) (actual rows= loops=)

  • Filter: ((betknonr = 711547) AND (betstnr = '8998'::bpchar))
13. 0.000 0.000 ↓ 0.0

Index Scan using tero_part_08_betstnr_betknonr_bsnr_idx on tero_part_08 b_7 (cost=0.06..2.08 rows=1 width=131) (actual rows= loops=)

  • Index Cond: ((betstnr = '8998'::bpchar) AND (betknonr = 711547))
14. 0.000 0.000 ↓ 0.0

Index Scan using tero_part_09_betstnr_betknonr_bsnr_idx on tero_part_09 b_8 (cost=0.08..2.10 rows=1 width=131) (actual rows= loops=)

  • Index Cond: ((betstnr = '8998'::bpchar) AND (betknonr = 711547))
15. 0.000 0.000 ↓ 0.0

Index Scan using tero_part_10_betstnr_betknonr_bsnr_idx on tero_part_10 b_9 (cost=0.06..2.08 rows=1 width=131) (actual rows= loops=)

  • Index Cond: ((betstnr = '8998'::bpchar) AND (betknonr = 711547))
16. 0.000 0.000 ↓ 0.0

Index Scan using tero_part_11_betstnr_betknonr_bsnr_idx on tero_part_11 b_10 (cost=0.08..2.11 rows=1 width=131) (actual rows= loops=)

  • Index Cond: ((betstnr = '8998'::bpchar) AND (betknonr = 711547))
17. 0.000 0.000 ↓ 0.0

Seq Scan on tero_part_12 b_11 (cost=0.00..1.09 rows=1 width=131) (actual rows= loops=)

  • Filter: ((betknonr = 711547) AND (betstnr = '8998'::bpchar))
18. 0.000 0.000 ↓ 0.0

Index Scan using tero_part_13_betstnr_betknonr_bsnr_idx on tero_part_13 b_12 (cost=0.08..2.11 rows=1 width=131) (actual rows= loops=)

  • Index Cond: ((betstnr = '8998'::bpchar) AND (betknonr = 711547))
19. 0.000 0.000 ↓ 0.0

Index Scan using tero_part_14_betstnr_betknonr_bsnr_idx on tero_part_14 b_13 (cost=0.06..2.08 rows=1 width=131) (actual rows= loops=)

  • Index Cond: ((betstnr = '8998'::bpchar) AND (betknonr = 711547))
20. 0.000 0.000 ↓ 0.0

Index Scan using tero_part_15_betstnr_betknonr_bsnr_idx on tero_part_15 b_14 (cost=0.06..2.08 rows=1 width=131) (actual rows= loops=)

  • Index Cond: ((betstnr = '8998'::bpchar) AND (betknonr = 711547))
21. 0.000 0.000 ↓ 0.0

Index Scan using tero_part_16_betstnr_betknonr_bsnr_idx on tero_part_16 b_15 (cost=0.06..2.08 rows=1 width=131) (actual rows= loops=)

  • Index Cond: ((betstnr = '8998'::bpchar) AND (betknonr = 711547))
22. 0.000 0.000 ↓ 0.0

Index Scan using tero_part_17_betstnr_betknonr_bsnr_idx on tero_part_17 b_16 (cost=0.08..2.10 rows=1 width=131) (actual rows= loops=)

  • Index Cond: ((betstnr = '8998'::bpchar) AND (betknonr = 711547))
23. 0.000 0.000 ↓ 0.0

Index Scan using tero_part_18_betstnr_betknonr_bsnr_idx on tero_part_18 b_17 (cost=0.06..2.08 rows=1 width=131) (actual rows= loops=)

  • Index Cond: ((betstnr = '8998'::bpchar) AND (betknonr = 711547))
24. 0.000 0.000 ↓ 0.0

Seq Scan on tero_part_19 b_18 (cost=0.00..1.03 rows=1 width=132) (actual rows= loops=)

  • Filter: ((betknonr = 711547) AND (betstnr = '8998'::bpchar))
25. 0.000 0.000 ↓ 0.0

Index Scan using tero_part_20_betstnr_betknonr_bsnr_idx on tero_part_20 b_19 (cost=0.03..2.05 rows=1 width=434) (actual rows= loops=)

  • Index Cond: ((betstnr = '8998'::bpchar) AND (betknonr = 711547))
26. 0.000 0.000 ↓ 0.0

Index Scan using tero_part_21_betstnr_betknonr_bsnr_idx on tero_part_21 b_20 (cost=0.08..2.10 rows=1 width=131) (actual rows= loops=)

  • Index Cond: ((betstnr = '8998'::bpchar) AND (betknonr = 711547))
27. 0.000 0.000 ↓ 0.0

Index Scan using tero_part_22_betstnr_betknonr_bsnr_idx on tero_part_22 b_21 (cost=0.09..2.11 rows=1 width=131) (actual rows= loops=)

  • Index Cond: ((betstnr = '8998'::bpchar) AND (betknonr = 711547))
28. 0.000 0.000 ↓ 0.0

Index Scan using tero_part_23_betstnr_betknonr_bsnr_idx on tero_part_23 b_22 (cost=0.08..2.10 rows=1 width=131) (actual rows= loops=)

  • Index Cond: ((betstnr = '8998'::bpchar) AND (betknonr = 711547))
29. 0.000 0.000 ↓ 0.0

Index Scan using tero_part_24_betstnr_betknonr_bsnr_idx on tero_part_24 b_23 (cost=0.09..2.11 rows=1 width=131) (actual rows= loops=)

  • Index Cond: ((betstnr = '8998'::bpchar) AND (betknonr = 711547))
30. 0.000 0.000 ↓ 0.0

Index Scan using tero_part_default_betstnr_betknonr_bsnr_idx on tero_part_default b_24 (cost=0.03..2.05 rows=1 width=434) (actual rows= loops=)

  • Index Cond: ((betstnr = '8998'::bpchar) AND (betknonr = 711547))
31. 0.000 0.000 ↓ 0.0

Append (cost=0.08..33.97 rows=25 width=308) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Index Scan using teror_part_01_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_01 r (cost=0.08..1.57 rows=1 width=308) (actual rows= loops=)

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

Index Scan using teror_part_02_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_02 r_1 (cost=0.08..2.11 rows=1 width=308) (actual rows= loops=)

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

Index Scan using teror_part_03_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_03 r_2 (cost=0.08..1.60 rows=1 width=308) (actual rows= loops=)

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

Index Scan using teror_part_04_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_04 r_3 (cost=0.08..1.54 rows=1 width=304) (actual rows= loops=)

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

Index Scan using teror_part_05_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_05 r_4 (cost=0.03..0.15 rows=1 width=311) (actual rows= loops=)

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

Index Scan using teror_part_06_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_06 r_5 (cost=0.03..0.21 rows=1 width=306) (actual rows= loops=)

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

Index Scan using teror_part_07_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_07 r_6 (cost=0.03..0.21 rows=1 width=304) (actual rows= loops=)

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

Index Scan using teror_part_08_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_08 r_7 (cost=0.06..1.96 rows=1 width=308) (actual rows= loops=)

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

Index Scan using teror_part_09_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_09 r_8 (cost=0.08..2.11 rows=1 width=306) (actual rows= loops=)

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

Index Scan using teror_part_10_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_10 r_9 (cost=0.06..1.24 rows=1 width=306) (actual rows= loops=)

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

Index Scan using teror_part_11_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_11 r_10 (cost=0.08..1.59 rows=1 width=307) (actual rows= loops=)

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

Index Scan using teror_part_12_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_12 r_11 (cost=0.03..0.25 rows=1 width=306) (actual rows= loops=)

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

Index Scan using teror_part_13_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_13 r_12 (cost=0.08..1.57 rows=1 width=306) (actual rows= loops=)

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

Index Scan using teror_part_14_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_14 r_13 (cost=0.06..1.47 rows=1 width=306) (actual rows= loops=)

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

Index Scan using teror_part_15_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_15 r_14 (cost=0.06..2.00 rows=1 width=307) (actual rows= loops=)

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

Index Scan using teror_part_16_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_16 r_15 (cost=0.06..1.80 rows=1 width=308) (actual rows= loops=)

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

Index Scan using teror_part_17_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_17 r_16 (cost=0.08..2.11 rows=1 width=306) (actual rows= loops=)

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

Index Scan using teror_part_18_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_18 r_17 (cost=0.06..2.00 rows=1 width=307) (actual rows= loops=)

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

Index Scan using teror_part_19_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_19 r_18 (cost=0.03..0.16 rows=1 width=309) (actual rows= loops=)

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

Index Scan using teror_part_20_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_20 r_19 (cost=0.03..0.49 rows=1 width=1,154) (actual rows= loops=)

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

Index Scan using teror_part_21_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_21 r_20 (cost=0.08..1.69 rows=1 width=306) (actual rows= loops=)

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

Index Scan using teror_part_22_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_22 r_21 (cost=0.09..1.66 rows=1 width=307) (actual rows= loops=)

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

Index Scan using teror_part_23_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_23 r_22 (cost=0.08..2.11 rows=1 width=308) (actual rows= loops=)

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

Index Scan using teror_part_24_bsnr_rdvprcnr_bsrdstakod_idx on teror_part_24 r_23 (cost=0.09..2.11 rows=1 width=307) (actual rows= loops=)

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

Index Scan using teror_part_default_kdtstnr_kdtknonr_bsnr_bsrdnr_idx on teror_part_default r_24 (cost=0.03..0.17 rows=1 width=303) (actual rows= loops=)

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

Hash (cost=491.80..491.80 rows=15,680 width=6) (actual rows= loops=)

58. 0.000 0.000 ↓ 0.0

Seq Scan on tct (cost=0.00..491.80 rows=15,680 width=6) (actual rows= loops=)

59. 0.000 0.000 ↓ 0.0

Nested Loop (cost=656.61..18,934,986.78 rows=254,549,240,911 width=463) (actual rows= loops=)

60. 0.000 0.000 ↓ 0.0

Hash Join (cost=656.52..1,786,533.43 rows=6,856,150 width=309) (actual rows= loops=)

  • Hash Cond: (r_25.vranr = tct_1.vranr)
61. 0.000 0.000 ↓ 0.0

Append (cost=0.08..1,782,273.04 rows=6,856,150 width=307) (actual rows= loops=)

62. 0.000 0.000 ↓ 0.0

Index Scan using teror_part_01_kdtstnr_kdtknonr_bsnr_bsrdnr_idx on teror_part_01 r_25 (cost=0.08..40,564.04 rows=191,850 width=308) (actual rows= loops=)

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

Index Scan using teror_part_02_kdtstnr_kdtknonr_bsnr_bsrdnr_idx on teror_part_02 r_26 (cost=0.08..109,166.53 rows=267,352 width=308) (actual rows= loops=)

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

Index Scan using teror_part_03_kdtstnr_kdtknonr_bsnr_bsrdnr_idx on teror_part_03 r_27 (cost=0.08..47,113.75 rows=136,773 width=308) (actual rows= loops=)

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

Seq Scan on teror_part_04 r_28 (cost=0.00..11,674.20 rows=113,025 width=304) (actual rows= loops=)

  • Filter: ((bsrdstakod <> ALL ('{FL,AN}'::bpchar[])) AND (kdtknonr = 0) AND (kdtrdvprcnr = 0) AND (kdtstnr = '0000'::bpchar))
66. 0.000 0.000 ↓ 0.0

Seq Scan on teror_part_05 r_29 (cost=0.00..1.05 rows=1 width=311) (actual rows= loops=)

  • Filter: ((bsrdstakod <> ALL ('{FL,AN}'::bpchar[])) AND (kdtknonr = 0) AND (kdtrdvprcnr = 0) AND (kdtstnr = '0000'::bpchar))
67. 0.000 0.000 ↓ 0.0

Seq Scan on teror_part_06 r_30 (cost=0.00..2.20 rows=13 width=306) (actual rows= loops=)

  • Filter: ((bsrdstakod <> ALL ('{FL,AN}'::bpchar[])) AND (kdtknonr = 0) AND (kdtrdvprcnr = 0) AND (kdtstnr = '0000'::bpchar))
68. 0.000 0.000 ↓ 0.0

Seq Scan on teror_part_07 r_31 (cost=0.00..2.19 rows=8 width=304) (actual rows= loops=)

  • Filter: ((bsrdstakod <> ALL ('{FL,AN}'::bpchar[])) AND (kdtknonr = 0) AND (kdtrdvprcnr = 0) AND (kdtstnr = '0000'::bpchar))
69. 0.000 0.000 ↓ 0.0

Index Scan using teror_part_08_kdtstnr_kdtknonr_bsnr_bsrdnr_idx on teror_part_08 r_32 (cost=0.06..1,805.40 rows=3,260 width=308) (actual rows= loops=)

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

Seq Scan on teror_part_09 r_33 (cost=0.00..17,245.30 rows=116,477 width=306) (actual rows= loops=)

  • Filter: ((bsrdstakod <> ALL ('{FL,AN}'::bpchar[])) AND (kdtknonr = 0) AND (kdtrdvprcnr = 0) AND (kdtstnr = '0000'::bpchar))
71. 0.000 0.000 ↓ 0.0

Index Scan using teror_part_10_kdtstnr_kdtknonr_bsnr_bsrdnr_idx on teror_part_10 r_34 (cost=0.06..845.03 rows=3,409 width=306) (actual rows= loops=)

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

Seq Scan on teror_part_11 r_35 (cost=0.00..49,946.38 rows=299,694 width=307) (actual rows= loops=)

  • Filter: ((bsrdstakod <> ALL ('{FL,AN}'::bpchar[])) AND (kdtknonr = 0) AND (kdtrdvprcnr = 0) AND (kdtstnr = '0000'::bpchar))
73. 0.000 0.000 ↓ 0.0

Seq Scan on teror_part_12 r_36 (cost=0.00..3.22 rows=8 width=306) (actual rows= loops=)

  • Filter: ((bsrdstakod <> ALL ('{FL,AN}'::bpchar[])) AND (kdtknonr = 0) AND (kdtrdvprcnr = 0) AND (kdtstnr = '0000'::bpchar))
74. 0.000 0.000 ↓ 0.0

Seq Scan on teror_part_13 r_37 (cost=0.00..182,249.10 rows=677,837 width=306) (actual rows= loops=)

  • Filter: ((bsrdstakod <> ALL ('{FL,AN}'::bpchar[])) AND (kdtknonr = 0) AND (kdtrdvprcnr = 0) AND (kdtstnr = '0000'::bpchar))
75. 0.000 0.000 ↓ 0.0

Seq Scan on teror_part_14 r_38 (cost=0.00..3,457.02 rows=22,486 width=306) (actual rows= loops=)

  • Filter: ((bsrdstakod <> ALL ('{FL,AN}'::bpchar[])) AND (kdtknonr = 0) AND (kdtrdvprcnr = 0) AND (kdtstnr = '0000'::bpchar))
76. 0.000 0.000 ↓ 0.0

Seq Scan on teror_part_15 r_39 (cost=0.00..3,186.13 rows=29,135 width=307) (actual rows= loops=)

  • Filter: ((bsrdstakod <> ALL ('{FL,AN}'::bpchar[])) AND (kdtknonr = 0) AND (kdtrdvprcnr = 0) AND (kdtstnr = '0000'::bpchar))
77. 0.000 0.000 ↓ 0.0

Seq Scan on teror_part_16 r_40 (cost=0.00..657.48 rows=6,279 width=308) (actual rows= loops=)

  • Filter: ((bsrdstakod <> ALL ('{FL,AN}'::bpchar[])) AND (kdtknonr = 0) AND (kdtrdvprcnr = 0) AND (kdtstnr = '0000'::bpchar))
78. 0.000 0.000 ↓ 0.0

Index Scan using teror_part_17_kdtstnr_kdtknonr_bsnr_bsrdnr_idx on teror_part_17 r_41 (cost=0.08..16,436.56 rows=57,281 width=306) (actual rows= loops=)

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

Index Scan using teror_part_18_kdtstnr_kdtknonr_bsnr_bsrdnr_idx on teror_part_18 r_42 (cost=0.06..3,023.61 rows=12,453 width=307) (actual rows= loops=)

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

Seq Scan on teror_part_19 r_43 (cost=0.00..1.07 rows=6 width=309) (actual rows= loops=)

  • Filter: ((bsrdstakod <> ALL ('{FL,AN}'::bpchar[])) AND (kdtknonr = 0) AND (kdtrdvprcnr = 0) AND (kdtstnr = '0000'::bpchar))
81. 0.000 0.000 ↓ 0.0

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

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

Seq Scan on teror_part_21 r_45 (cost=0.00..19,449.01 rows=112,216 width=306) (actual rows= loops=)

  • Filter: ((bsrdstakod <> ALL ('{FL,AN}'::bpchar[])) AND (kdtknonr = 0) AND (kdtrdvprcnr = 0) AND (kdtstnr = '0000'::bpchar))
83. 0.000 0.000 ↓ 0.0

Seq Scan on teror_part_22 r_46 (cost=0.00..505,863.52 rows=1,995,271 width=307) (actual rows= loops=)

  • Filter: ((bsrdstakod <> ALL ('{FL,AN}'::bpchar[])) AND (kdtknonr = 0) AND (kdtrdvprcnr = 0) AND (kdtstnr = '0000'::bpchar))
84. 0.000 0.000 ↓ 0.0

Index Scan using teror_part_23_kdtstnr_kdtknonr_bsnr_bsrdnr_idx on teror_part_23 r_47 (cost=0.08..15,208.27 rows=60,296 width=308) (actual rows= loops=)

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

Seq Scan on teror_part_24 r_48 (cost=0.00..720,088.17 rows=2,751,018 width=307) (actual rows= loops=)

  • Filter: ((bsrdstakod <> ALL ('{FL,AN}'::bpchar[])) AND (kdtknonr = 0) AND (kdtrdvprcnr = 0) AND (kdtstnr = '0000'::bpchar))
86. 0.000 0.000 ↓ 0.0

Seq Scan on teror_part_default r_49 (cost=0.00..1.01 rows=1 width=303) (actual rows= loops=)

  • Filter: ((bsrdstakod <> ALL ('{FL,AN}'::bpchar[])) AND (kdtknonr = 0) AND (kdtrdvprcnr = 0) AND (kdtstnr = '0000'::bpchar))
87. 0.000 0.000 ↓ 0.0

Hash (cost=491.80..491.80 rows=15,680 width=6) (actual rows= loops=)

88. 0.000 0.000 ↓ 0.0

Seq Scan on tct tct_1 (cost=0.00..491.80 rows=15,680 width=6) (actual rows= loops=)

89. 0.000 0.000 ↓ 0.0

Append (cost=0.08..2.25 rows=25 width=131) (actual rows= loops=)

90. 0.000 0.000 ↓ 0.0

Index Scan using tero_part_01_pkey on tero_part_01 b_25 (cost=0.08..0.11 rows=1 width=131) (actual rows= loops=)

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

Index Scan using tero_part_02_pkey on tero_part_02 b_26 (cost=0.08..0.11 rows=1 width=131) (actual rows= loops=)

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

Index Scan using tero_part_03_pkey on tero_part_03 b_27 (cost=0.08..0.11 rows=1 width=131) (actual rows= loops=)

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

Index Scan using tero_part_04_pkey on tero_part_04 b_28 (cost=0.08..0.10 rows=1 width=131) (actual rows= loops=)

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

Index Scan using tero_part_05_pkey on tero_part_05 b_29 (cost=0.03..0.05 rows=1 width=132) (actual rows= loops=)

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

Index Scan using tero_part_06_pkey on tero_part_06 b_30 (cost=0.03..0.05 rows=1 width=131) (actual rows= loops=)

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

Index Scan using tero_part_07_pkey on tero_part_07 b_31 (cost=0.03..0.05 rows=1 width=131) (actual rows= loops=)

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

Index Scan using tero_part_08_pkey on tero_part_08 b_32 (cost=0.06..0.08 rows=1 width=131) (actual rows= loops=)

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

Index Scan using tero_part_09_pkey on tero_part_09 b_33 (cost=0.08..0.10 rows=1 width=131) (actual rows= loops=)

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

Index Scan using tero_part_10_pkey on tero_part_10 b_34 (cost=0.06..0.08 rows=1 width=131) (actual rows= loops=)

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

Index Scan using tero_part_11_pkey on tero_part_11 b_35 (cost=0.08..0.11 rows=1 width=131) (actual rows= loops=)

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

Index Scan using tero_part_12_pkey on tero_part_12 b_36 (cost=0.03..0.05 rows=1 width=131) (actual rows= loops=)

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

Index Scan using tero_part_13_pkey on tero_part_13 b_37 (cost=0.08..0.11 rows=1 width=131) (actual rows= loops=)

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

Index Scan using tero_part_14_pkey on tero_part_14 b_38 (cost=0.06..0.08 rows=1 width=131) (actual rows= loops=)

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

Index Scan using tero_part_15_pkey on tero_part_15 b_39 (cost=0.06..0.08 rows=1 width=131) (actual rows= loops=)

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

Index Scan using tero_part_16_pkey on tero_part_16 b_40 (cost=0.06..0.08 rows=1 width=131) (actual rows= loops=)

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

Index Scan using tero_part_17_pkey on tero_part_17 b_41 (cost=0.08..0.10 rows=1 width=131) (actual rows= loops=)

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

Index Scan using tero_part_18_pkey on tero_part_18 b_42 (cost=0.06..0.08 rows=1 width=131) (actual rows= loops=)

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

Index Scan using tero_part_19_pkey on tero_part_19 b_43 (cost=0.03..0.05 rows=1 width=132) (actual rows= loops=)

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

Index Scan using tero_part_20_pkey on tero_part_20 b_44 (cost=0.03..0.05 rows=1 width=434) (actual rows= loops=)

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

Index Scan using tero_part_21_pkey on tero_part_21 b_45 (cost=0.08..0.10 rows=1 width=131) (actual rows= loops=)

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

Index Scan using tero_part_22_pkey on tero_part_22 b_46 (cost=0.09..0.13 rows=1 width=131) (actual rows= loops=)

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

Index Scan using tero_part_23_pkey on tero_part_23 b_47 (cost=0.08..0.10 rows=1 width=131) (actual rows= loops=)

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

Index Scan using tero_part_24_pkey on tero_part_24 b_48 (cost=0.09..0.13 rows=1 width=131) (actual rows= loops=)

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

Index Scan using tero_part_default_pkey on tero_part_default b_49 (cost=0.03..0.05 rows=1 width=434) (actual rows= loops=)

  • Index Cond: (bsnr = r_25.bsnr)