explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Iofl : Optimization for: plan #3yoq

Settings

Optimization path:

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

Sort (cost=1,925.60..1,937.75 rows=24,282 width=489) (actual time=0.369..0.369 rows=0 loops=1)

  • Sort Key: b.bsnr, r.bsrdnr
  • Sort Method: quicksort Memory: 25kB
2. 0.013 0.371 ↓ 0.0 0 1

Hash Join (cost=656.61..1,571.87 rows=24,282 width=489) (actual time=0.359..0.371 rows=0 loops=1)

  • Hash Cond: (r.vranr = tct.vranr)
3. 0.001 0.358 ↓ 0.0 0 1

Nested Loop (cost=0.17..902.67 rows=24,282 width=455) (actual time=0.358..0.358 rows=0 loops=1)

4. 0.006 0.357 ↓ 0.0 0 1

Append (cost=0.08..47.24 rows=25 width=155) (actual time=0.357..0.357 rows=0 loops=1)

5. 0.032 0.032 ↓ 0.0 0 1

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 time=0.032..0.032 rows=0 loops=1)

  • Index Cond: ((betstnr = '8998'::bpchar) AND (betknonr = 711547))
6. 0.036 0.036 ↓ 0.0 0 1

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 time=0.036..0.036 rows=0 loops=1)

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

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 time=0.018..0.018 rows=0 loops=1)

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

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 time=0.013..0.013 rows=0 loops=1)

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

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

  • Filter: ((betknonr = 711547) AND (betstnr = '8998'::bpchar))
  • Rows Removed by Filter: 3
10. 0.010 0.010 ↓ 0.0 0 1

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

  • Filter: ((betknonr = 711547) AND (betstnr = '8998'::bpchar))
  • Rows Removed by Filter: 4
11. 0.010 0.010 ↓ 0.0 0 1

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

  • Filter: ((betknonr = 711547) AND (betstnr = '8998'::bpchar))
  • Rows Removed by Filter: 8
12. 0.013 0.013 ↓ 0.0 0 1

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 time=0.013..0.013 rows=0 loops=1)

  • Index Cond: ((betstnr = '8998'::bpchar) AND (betknonr = 711547))
13. 0.015 0.015 ↓ 0.0 0 1

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 time=0.015..0.015 rows=0 loops=1)

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

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 time=0.011..0.011 rows=0 loops=1)

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

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 time=0.012..0.012 rows=0 loops=1)

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

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

  • Filter: ((betknonr = 711547) AND (betstnr = '8998'::bpchar))
  • Rows Removed by Filter: 8
17. 0.016 0.016 ↓ 0.0 0 1

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 time=0.016..0.016 rows=0 loops=1)

  • Index Cond: ((betstnr = '8998'::bpchar) AND (betknonr = 711547))
18. 0.010 0.010 ↓ 0.0 0 1

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 time=0.010..0.010 rows=0 loops=1)

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

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 time=0.010..0.010 rows=0 loops=1)

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

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 time=0.009..0.009 rows=0 loops=1)

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

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 time=0.013..0.013 rows=0 loops=1)

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

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 time=0.011..0.011 rows=0 loops=1)

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

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

  • Filter: ((betknonr = 711547) AND (betstnr = '8998'::bpchar))
  • Rows Removed by Filter: 3
24. 0.006 0.006 ↓ 0.0 0 1

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 time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((betstnr = '8998'::bpchar) AND (betknonr = 711547))
25. 0.015 0.015 ↓ 0.0 0 1

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 time=0.015..0.015 rows=0 loops=1)

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

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 time=0.016..0.016 rows=0 loops=1)

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

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 time=0.015..0.015 rows=0 loops=1)

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

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 time=0.016..0.016 rows=0 loops=1)

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

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 time=0.004..0.004 rows=0 loops=1)

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

Append (cost=0.08..33.97 rows=25 width=308) (never executed)

31. 0.000 0.000 ↓ 0.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) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 380))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
32. 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.08..2.11 rows=1 width=308) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 380))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
33. 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.08..1.60 rows=1 width=308) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 380))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
34. 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.08..1.54 rows=1 width=304) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 380))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
35. 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.03..0.15 rows=1 width=311) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 380))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
36. 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.03..0.21 rows=1 width=306) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 380))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
37. 0.000 0.000 ↓ 0.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) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 380))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
38. 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.06..1.96 rows=1 width=308) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 380))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
39. 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.08..2.11 rows=1 width=306) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 380))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
40. 0.000 0.000 ↓ 0.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) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 380))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
41. 0.000 0.000 ↓ 0.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) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 380))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
42. 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.03..0.25 rows=1 width=306) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 380))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
43. 0.000 0.000 ↓ 0.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) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 380))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
44. 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.06..1.47 rows=1 width=306) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 380))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
45. 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.06..2.00 rows=1 width=307) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 380))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
46. 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.06..1.80 rows=1 width=308) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 380))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
47. 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.08..2.11 rows=1 width=306) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 380))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
48. 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.06..2.00 rows=1 width=307) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 380))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
49. 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.03..0.16 rows=1 width=309) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 380))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
50. 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.49 rows=1 width=1,154) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 380))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
51. 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.08..1.69 rows=1 width=306) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 380))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
52. 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..1.66 rows=1 width=307) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 380))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
53. 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.08..2.11 rows=1 width=308) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 380))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
54. 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..2.11 rows=1 width=307) (never executed)

  • Index Cond: ((bsnr = b.bsnr) AND (rdvprcnr = 380))
  • Filter: (bsrdstakod <> ALL ('{FL,AN,AS}'::bpchar[]))
55. 0.000 0.000 ↓ 0.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) (never executed)

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

Hash (cost=491.80..491.80 rows=15,680 width=6) (never executed)

57. 0.000 0.000 ↓ 0.0 0

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

Planning time : 16.349 ms
Execution time : 1.238 ms