explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Gvry

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 946.633 ↓ 0.0 0 1

Append (cost=5,592.22..10,313.06 rows=5 width=144) (actual time=946.633..946.633 rows=0 loops=1)

2. 0.001 935.673 ↓ 0.0 0 1

Subquery Scan on *SELECT* 1 (cost=5,592.22..5,592.24 rows=1 width=102) (actual time=935.673..935.673 rows=0 loops=1)

3. 0.001 935.672 ↓ 0.0 0 1

Unique (cost=5,592.22..5,592.23 rows=1 width=117) (actual time=935.672..935.672 rows=0 loops=1)

4. 0.009 935.671 ↓ 0.0 0 1

Sort (cost=5,592.22..5,592.22 rows=1 width=117) (actual time=935.671..935.671 rows=0 loops=1)

  • Sort Key: fps.kundenlaufnummer, fps.portfolioartcode
  • Sort Method: quicksort Memory: 25kB
5. 0.000 935.662 ↓ 0.0 0 1

Nested Loop (cost=2,861.20..5,592.21 rows=1 width=117) (actual time=935.662..935.662 rows=0 loops=1)

  • Join Filter: ((((pc.fndn_prtnr_id)::text || '|'::text) || (fps.kundenlaufnummer)::text) = (prid.ntiv_prtnr_rel_sid)::text)
6. 9.322 935.662 ↓ 0.0 0 1

Nested Loop (cost=2,860.79..5,583.75 rows=1 width=47) (actual time=935.662..935.662 rows=0 loops=1)

7. 12.095 685.050 ↓ 24,129.0 24,129 1

Nested Loop Anti Join (cost=2,860.37..5,583.27 rows=1 width=51) (actual time=376.279..685.050 rows=24,129 loops=1)

8. 20.803 648.826 ↓ 24,129.0 24,129 1

Hash Anti Join (cost=2,860.24..5,583.10 rows=1 width=59) (actual time=376.250..648.826 rows=24,129 loops=1)

  • Hash Cond: (((fcs.kundenlaufnummer)::character varying)::text = (fcshdw.s_kundenlaufnummer)::text)
9. 32.497 628.002 ↓ 24,129.0 24,129 1

Nested Loop (cost=2,849.79..5,572.64 rows=1 width=59) (actual time=376.198..628.002 rows=24,129 loops=1)

10. 42.566 486.961 ↓ 27,136.0 27,136 1

Hash Join (cost=2,849.50..5,572.16 rows=1 width=59) (actual time=376.125..486.961 rows=27,136 loops=1)

  • Hash Cond: ((((fps.portfolioartcode)::character varying)::text = (pc.pfol_cat_cd)::text) AND (cvf.fndn_prtnr_id = pc.fndn_prtnr_id))
11. 32.732 444.339 ↓ 200.3 33,458 1

Hash Join (cost=2,848.16..5,569.14 rows=167 width=59) (actual time=376.049..444.339 rows=33,458 loops=1)

  • Hash Cond: (fps.kundenlaufnummer = cvf.kundenlaufnummer)
12. 35.614 35.614 ↑ 1.0 27,136 1

Seq Scan on finn_portfolio_stg fps (cost=0.00..2,617.37 rows=27,184 width=23) (actual time=0.034..35.614 rows=27,136 loops=1)

  • Filter: ((portfolioartcode <> '10'::numeric) AND (rpl_on_ts_dt = '9999-12-31 23:59:59.999'::timestamp without time zone))
  • Rows Removed by Filter: 22422
13. 9.309 375.993 ↓ 178.8 24,320 1

Hash (cost=2,846.46..2,846.46 rows=136 width=36) (actual time=375.993..375.993 rows=24,320 loops=1)

  • Buckets: 32768 (originally 1024) Batches: 1 (originally 1) Memory Usage: 1491kB
14. 4.858 366.684 ↓ 178.8 24,320 1

Subquery Scan on cvf (cost=2,843.74..2,846.46 rows=136 width=36) (actual time=298.852..366.684 rows=24,320 loops=1)

15. 60.653 361.826 ↓ 178.8 24,320 1

Group (cost=2,843.74..2,845.10 rows=136 width=36) (actual time=298.851..361.826 rows=24,320 loops=1)

  • Group Key: pc_1.fndn_prtnr_id, fps_1.kundenlaufnummer
16. 133.974 301.173 ↓ 199.5 27,136 1

Sort (cost=2,843.74..2,844.08 rows=136 width=32) (actual time=298.833..301.173 rows=27,136 loops=1)

  • Sort Key: pc_1.fndn_prtnr_id, fps_1.kundenlaufnummer
  • Sort Method: quicksort Memory: 2041kB
17. 16.742 167.199 ↓ 199.5 27,136 1

Nested Loop Left Join (cost=1.63..2,838.92 rows=136 width=32) (actual time=0.112..167.199 rows=27,136 loops=1)

18. 28.552 69.049 ↓ 199.5 27,136 1

Hash Join (cost=1.34..2,789.97 rows=136 width=32) (actual time=0.089..69.049 rows=27,136 loops=1)

  • Hash Cond: (((fps_1.portfolioartcode)::character varying)::text = (pc_1.pfol_cat_cd)::text)
19. 40.453 40.453 ↑ 1.0 27,136 1

Seq Scan on finn_portfolio_stg fps_1 (cost=0.00..2,617.37 rows=27,184 width=15) (actual time=0.026..40.453 rows=27,136 loops=1)

  • Filter: ((kundenlaufnummer IS NOT NULL) AND (portfolioartcode <> '10'::numeric) AND (rpl_on_ts_dt = '9999-12-31 23:59:59.999'::timestamp without time zone))
  • Rows Removed by Filter: 22422
20. 0.015 0.044 ↓ 12.0 12 1

Hash (cost=1.33..1.33 rows=1 width=90) (actual time=0.044..0.044 rows=12 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
21. 0.029 0.029 ↓ 12.0 12 1

Seq Scan on pfol_cat pc_1 (cost=0.00..1.33 rows=1 width=90) (actual time=0.012..0.029 rows=12 loops=1)

  • Filter: ((fndn_prtnr_id IS NOT NULL) AND (rpl_on_ts_dt = '9999-12-31 23:59:59.999'::timestamp without time zone) AND (date_trunc('day'::text, statement_timestamp()) >= vld_from_dt) AND (date_trunc('day'::text, statement_timestamp()) <= vld_unt_dt))
22. 81.408 81.408 ↑ 1.0 1 27,136

Index Only Scan using finn_client_stg_roai on finn_client_stg fcs_1 (cost=0.29..0.35 rows=1 width=10) (actual time=0.003..0.003 rows=1 loops=27,136)

  • Index Cond: (kundenlaufnummer = fps_1.kundenlaufnummer)
  • Heap Fetches: 0
23. 0.016 0.056 ↓ 12.0 12 1

Hash (cost=1.33..1.33 rows=1 width=90) (actual time=0.056..0.056 rows=12 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
24. 0.040 0.040 ↓ 12.0 12 1

Seq Scan on pfol_cat pc (cost=0.00..1.33 rows=1 width=90) (actual time=0.023..0.040 rows=12 loops=1)

  • Filter: ((rpl_on_ts_dt = '9999-12-31 23:59:59.999'::timestamp without time zone) AND (date_trunc('day'::text, statement_timestamp()) >= vld_from_dt) AND (date_trunc('day'::text, statement_timestamp()) <= vld_unt_dt))
25. 108.544 108.544 ↑ 1.0 1 27,136

Index Scan using finn_client_stg_roai on finn_client_stg fcs (cost=0.29..0.47 rows=1 width=10) (actual time=0.004..0.004 rows=1 loops=27,136)

  • Index Cond: (kundenlaufnummer = fps.kundenlaufnummer)
  • Filter: ((kundenstatuscode = '0'::numeric) AND (((kundenkategoriecode = '10'::numeric) AND (vorname IS NOT NULL)) OR ((kundenkategoriecode = '30'::numeric) AND (ahvnummersozialversicherungsnummer IS NOT NULL))))
  • Rows Removed by Filter: 0
26. 0.000 0.021 ↓ 0.0 0 1

Hash (cost=10.20..10.20 rows=20 width=15) (actual time=0.021..0.021 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
27. 0.021 0.021 ↓ 0.0 0 1

Seq Scan on finn_client_shdw fcshdw (cost=0.00..10.20 rows=20 width=15) (actual time=0.021..0.021 rows=0 loops=1)

28. 24.129 24.129 ↓ 0.0 0 24,129

Index Only Scan using finn_portfolio_shdw_if_s_portfolionummer on finn_portfolio_shdw fpshdw (cost=0.13..0.15 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=24,129)

  • Index Cond: (s_portfolionummer = ((fps.portfolionummer)::character varying)::text)
  • Heap Fetches: 0
29. 241.290 241.290 ↓ 0.0 0 24,129

Index Only Scan using prtnr_id_inx1 on prtnr_id pid (cost=0.42..0.47 rows=1 width=23) (actual time=0.010..0.010 rows=0 loops=24,129)

  • Index Cond: ((appl_sys_sid = 'FINNOVA_KEY'::text) AND (ntiv_prtnr_sid = ((fcs.kundenlaufnummer)::character varying)::text) AND (prtnr_id IS NOT NULL))
  • Heap Fetches: 0
30. 0.000 0.000 ↓ 0.0 0

Index Scan using prtnr_rel_id_apk1 on prtnr_rel_id prid (cost=0.41..8.43 rows=1 width=25) (never executed)

  • Index Cond: (((appl_sys_sid)::text = 'FINNOVA'::text) AND (prtnr_rel_id IS NOT NULL))
31. 0.000 0.298 ↓ 0.0 0 1

Nested Loop Left Join (cost=24.27..1,182.83 rows=1 width=86) (actual time=0.298..0.298 rows=0 loops=1)

32. 0.001 0.298 ↓ 0.0 0 1

Nested Loop Anti Join (cost=23.86..1,179.33 rows=1 width=22) (actual time=0.298..0.298 rows=0 loops=1)

  • Join Filter: ((fcshdw_1.s_kundenlaufnummer)::text = ((fcs_2.kundenlaufnummer)::character varying)::text)
33. 0.000 0.297 ↓ 0.0 0 1

Nested Loop (cost=23.86..1,168.78 rows=1 width=22) (actual time=0.297..0.297 rows=0 loops=1)

  • Join Filter: ((((p_liberty.prtnr_id)::text || '|'::text) || (fcs_2.kundenlaufnummer)::text) = (prid_1.ntiv_prtnr_rel_sid)::text)
34. 0.002 0.297 ↓ 0.0 0 1

Nested Loop (cost=23.86..35.92 rows=1 width=31) (actual time=0.297..0.297 rows=0 loops=1)

35. 0.077 0.269 ↑ 1.0 1 1

Bitmap Heap Scan on prtnr p_liberty (cost=23.44..27.48 rows=1 width=6) (actual time=0.214..0.269 rows=1 loops=1)

  • Recheck Cond: (((prtnr_styp_cd)::text = 'Liberty'::text) AND ((src_appl_sys_sid)::text = 'DWH_MANUAL'::text))
  • Filter: (((prtnr_typ_cd)::text = 'LEGAL'::text) AND (rpl_on_ts_dt = '9999-12-31 23:59:59.999'::timestamp without time zone) AND (date_trunc('day'::text, statement_timestamp()) >= vld_from_dt) AND (date_trunc('day'::text, statement_timestamp()) <= vld_unt_dt))
  • Rows Removed by Filter: 6
  • Heap Blocks: exact=6
36. 0.004 0.192 ↓ 0.0 0 1

BitmapAnd (cost=23.44..23.44 rows=1 width=0) (actual time=0.192..0.192 rows=0 loops=1)

37. 0.034 0.034 ↑ 3.7 7 1

Bitmap Index Scan on prtnr_if9 (cost=0.00..4.62 rows=26 width=0) (actual time=0.034..0.034 rows=7 loops=1)

  • Index Cond: ((prtnr_styp_cd)::text = 'Liberty'::text)
38. 0.154 0.154 ↑ 1.0 782 1

Bitmap Index Scan on prtnr_if17 (cost=0.00..18.58 rows=821 width=0) (actual time=0.154..0.154 rows=782 loops=1)

  • Index Cond: ((src_appl_sys_sid)::text = 'DWH_MANUAL'::text)
39. 0.026 0.026 ↓ 0.0 0 1

Index Scan using prtnr_rel_id_apk1 on prtnr_rel_id prid_1 (cost=0.41..8.43 rows=1 width=25) (actual time=0.026..0.026 rows=0 loops=1)

  • Index Cond: (((appl_sys_sid)::text = 'FINNOVA'::text) AND (prtnr_rel_id IS NOT NULL))
40. 0.000 0.000 ↓ 0.0 0

Seq Scan on finn_client_stg fcs_2 (cost=0.00..1,130.33 rows=92 width=10) (never executed)

  • Filter: ((rpl_on_ts_dt = '9999-12-31 23:59:59.999'::timestamp without time zone) AND (kundenkategoriecode = '40'::numeric) AND (kundenstatuscode = '0'::numeric))
41. 0.000 0.000 ↓ 0.0 0

Seq Scan on finn_client_shdw fcshdw_1 (cost=0.00..10.20 rows=20 width=15) (never executed)

42. 0.000 0.000 ↓ 0.0 0

Index Only Scan using prtnr_id_inx1 on prtnr_id pid_1 (cost=0.42..3.48 rows=1 width=23) (never executed)

  • Index Cond: ((appl_sys_sid = 'FINNOVA_KEY'::text) AND (ntiv_prtnr_sid = ((fcs_2.kundenlaufnummer)::character varying)::text))
  • Heap Fetches: 0
43. 0.001 0.139 ↓ 0.0 0 1

Subquery Scan on *SELECT* 3 (cost=52.98..1,226.75 rows=1 width=86) (actual time=0.139..0.139 rows=0 loops=1)

44. 0.001 0.138 ↓ 0.0 0 1

Nested Loop Left Join (cost=52.98..1,226.74 rows=1 width=57) (actual time=0.138..0.138 rows=0 loops=1)

45. 0.000 0.137 ↓ 0.0 0 1

Nested Loop Left Join (cost=52.70..1,226.15 rows=1 width=23) (actual time=0.137..0.137 rows=0 loops=1)

46. 0.000 0.137 ↓ 0.0 0 1

Nested Loop Anti Join (cost=52.28..1,225.21 rows=1 width=27) (actual time=0.137..0.137 rows=0 loops=1)

  • Join Filter: ((foshdw.s_kundenlaufnummerberater)::text = ((fos.kundenlaufnummerberater)::character varying)::text)
47. 0.001 0.137 ↓ 0.0 0 1

Nested Loop Anti Join (cost=52.28..1,214.11 rows=1 width=38) (actual time=0.137..0.137 rows=0 loops=1)

  • Join Filter: ((fcshdw_2.s_kundenlaufnummer)::text = ((fcs_3.kundenlaufnummer)::character varying)::text)
48. 0.000 0.136 ↓ 0.0 0 1

Nested Loop (cost=52.28..1,203.56 rows=1 width=38) (actual time=0.136..0.136 rows=0 loops=1)

  • Join Filter: ((((((p_liberty_1.prtnr_id)::text || '|'::text) || (fcs_3.kundenlaufnummer)::text) || '|'::text) || (fos.rollencode)::text) = (prid_2.ntiv_prtnr_rel_sid)::text)
49. 0.001 0.136 ↓ 0.0 0 1

Nested Loop (cost=23.86..35.92 rows=1 width=31) (actual time=0.136..0.136 rows=0 loops=1)

50. 0.011 0.116 ↑ 1.0 1 1

Bitmap Heap Scan on prtnr p_liberty_1 (cost=23.44..27.48 rows=1 width=6) (actual time=0.113..0.116 rows=1 loops=1)

  • Recheck Cond: (((prtnr_styp_cd)::text = 'Liberty'::text) AND ((src_appl_sys_sid)::text = 'DWH_MANUAL'::text))
  • Filter: ((rpl_on_ts_dt = '9999-12-31 23:59:59.999'::timestamp without time zone) AND ((prtnr_typ_cd)::text = 'LEGAL'::text) AND (date_trunc('day'::text, statement_timestamp()) >= vld_from_dt) AND (date_trunc('day'::text, statement_timestamp()) <= vld_unt_dt))
  • Rows Removed by Filter: 6
  • Heap Blocks: exact=6
51. 0.002 0.105 ↓ 0.0 0 1

BitmapAnd (cost=23.44..23.44 rows=1 width=0) (actual time=0.105..0.105 rows=0 loops=1)

52. 0.016 0.016 ↑ 3.7 7 1

Bitmap Index Scan on prtnr_if9 (cost=0.00..4.62 rows=26 width=0) (actual time=0.016..0.016 rows=7 loops=1)

  • Index Cond: ((prtnr_styp_cd)::text = 'Liberty'::text)
53. 0.087 0.087 ↑ 1.0 782 1

Bitmap Index Scan on prtnr_if17 (cost=0.00..18.58 rows=821 width=0) (actual time=0.087..0.087 rows=782 loops=1)

  • Index Cond: ((src_appl_sys_sid)::text = 'DWH_MANUAL'::text)
54. 0.019 0.019 ↓ 0.0 0 1

Index Scan using prtnr_rel_id_apk1 on prtnr_rel_id prid_2 (cost=0.41..8.43 rows=1 width=25) (actual time=0.019..0.019 rows=0 loops=1)

  • Index Cond: (((appl_sys_sid)::text = 'FINNOVA'::text) AND (prtnr_rel_id IS NOT NULL))
55. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=28.42..1,166.17 rows=39 width=26) (never executed)

  • Hash Cond: (fcs_3.kundenlaufnummer = fos.kundenlaufnummerberater)
56. 0.000 0.000 ↓ 0.0 0

Seq Scan on finn_client_stg fcs_3 (cost=0.00..1,130.33 rows=1,124 width=10) (never executed)

  • Filter: ((vorname IS NULL) AND (kundenkategoriecode = '10'::numeric) AND (kundenstatuscode = '0'::numeric) AND (rpl_on_ts_dt = '9999-12-31 23:59:59.999'::timestamp without time zone))
57. 0.000 0.000 ↓ 0.0 0

Hash (cost=18.71..18.71 rows=777 width=16) (never executed)

58. 0.000 0.000 ↓ 0.0 0

Seq Scan on finn_organisation_stg fos (cost=0.00..18.71 rows=777 width=16) (never executed)

  • Filter: (rpl_on_ts_dt = '9999-12-31 23:59:59.999'::timestamp without time zone)
59. 0.000 0.000 ↓ 0.0 0

Seq Scan on finn_client_shdw fcshdw_2 (cost=0.00..10.20 rows=20 width=15) (never executed)

60. 0.000 0.000 ↓ 0.0 0

Seq Scan on finn_organisation_shdw foshdw (cost=0.00..10.40 rows=40 width=15) (never executed)

61. 0.000 0.000 ↓ 0.0 0

Index Only Scan using prtnr_id_inx1 on prtnr_id pid_2 (cost=0.42..0.93 rows=1 width=23) (never executed)

  • Index Cond: ((appl_sys_sid = 'FINNOVA_KEY'::text) AND (ntiv_prtnr_sid = ((fcs_3.kundenlaufnummer)::character varying)::text))
  • Heap Fetches: 0
62. 0.000 0.000 ↓ 0.0 0

Index Scan using simp_cd_maps_apk1 on simp_cd_maps scm (cost=0.29..0.58 rows=1 width=11) (never executed)

  • Index Cond: (((phy_targ_ntt_name)::text = 'FinnovaAdvisorRole'::text) AND ((src_cd)::text = ((fos.rollencode)::character varying)::text) AND (vld_from_dt <= date_trunc('day'::text, statement_timestamp())))
  • Filter: (date_trunc('day'::text, statement_timestamp()) <= vld_unt_dt)
63. 0.000 0.010 ↓ 0.0 0 1

Subquery Scan on *SELECT* 4 (cost=40.81..1,197.43 rows=1 width=112) (actual time=0.010..0.010 rows=0 loops=1)

64. 0.001 0.010 ↓ 0.0 0 1

Nested Loop (cost=40.81..1,197.42 rows=1 width=84) (actual time=0.009..0.010 rows=0 loops=1)

65. 0.000 0.009 ↓ 0.0 0 1

Nested Loop (cost=40.40..1,195.33 rows=1 width=16) (actual time=0.009..0.009 rows=0 loops=1)

  • Join Filter: (fcs_4.kundenlaufnummer = fpes.kundenlaufnummerarbeitgeber)
66. 0.001 0.009 ↓ 0.0 0 1

Nested Loop (cost=0.41..1,145.52 rows=1 width=16) (actual time=0.009..0.009 rows=0 loops=1)

  • Join Filter: (((('4|'::text || (fcs_4.macosvertragsnummer)::text) || '|'::text) || 'CF'::text) = (prid_3.ntiv_prtnr_rel_sid)::text)
67. 0.008 0.008 ↓ 0.0 0 1

Index Scan using prtnr_rel_id_apk1 on prtnr_rel_id prid_3 (cost=0.41..8.43 rows=1 width=25) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (((appl_sys_sid)::text = 'FINNOVA'::text) AND (prtnr_rel_id IS NOT NULL))
68. 0.000 0.000 ↓ 0.0 0

Seq Scan on finn_client_stg fcs_4 (cost=0.00..1,130.33 rows=338 width=17) (never executed)

  • Filter: ((macosvertragsnummer IS NOT NULL) AND (kundenkategoriecode = '10'::numeric) AND (kundenstatuscode = '0'::numeric) AND (rpl_on_ts_dt = '9999-12-31 23:59:59.999'::timestamp without time zone))
69. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=39.98..43.01 rows=302 width=11) (never executed)

  • Group Key: fpes.kundenlaufnummerarbeitgeber
70. 0.000 0.000 ↓ 0.0 0

Seq Scan on finn_portfolio_employer_stg fpes (cost=0.00..37.49 rows=999 width=11) (never executed)

  • Filter: (rpl_on_ts_dt = '9999-12-31 23:59:59.999'::timestamp without time zone)
71. 0.000 0.000 ↓ 0.0 0

Index Only Scan using prtnr_id_inx1 on prtnr_id pid_3 (cost=0.42..2.08 rows=1 width=23) (never executed)

  • Index Cond: ((appl_sys_sid = 'FINNOVA_KEY'::text) AND (ntiv_prtnr_sid = ((fcs_4.kundenlaufnummer)::character varying)::text) AND (prtnr_id IS NOT NULL))
  • Heap Fetches: 0
72. 0.000 10.509 ↓ 0.0 0 1

Nested Loop (cost=1.80..1,113.77 rows=1 width=86) (actual time=10.509..10.509 rows=0 loops=1)

73. 0.001 10.509 ↓ 0.0 0 1

Nested Loop (cost=1.39..1,113.29 rows=1 width=22) (actual time=10.509..10.509 rows=0 loops=1)

  • Join Filter: ((((fcs_employer.macosvertragsnummer)::text || '|'::text) || (fcs_employee.ahvnummersozialversicherungsnummer)::text) = (prid_4.ntiv_prtnr_rel_sid)::text)
74. 0.000 10.508 ↓ 0.0 0 1

Nested Loop (cost=0.97..1,104.85 rows=1 width=40) (actual time=10.508..10.508 rows=0 loops=1)

75. 0.001 10.508 ↓ 0.0 0 1

Nested Loop (cost=0.69..1,100.92 rows=1 width=24) (actual time=10.508..10.508 rows=0 loops=1)

76. 0.111 10.507 ↓ 0.0 0 1

Nested Loop (cost=0.41..1,092.46 rows=1 width=23) (actual time=10.507..10.507 rows=0 loops=1)

  • Join Filter: (((fcs_employer.kundenlaufnummer)::character varying)::text = (pid_company.ntiv_prtnr_sid)::text)
77. 10.396 10.396 ↓ 1.0 352 1

Seq Scan on finn_client_stg fcs_employer (cost=0.00..1,074.28 rows=343 width=17) (actual time=0.049..10.396 rows=352 loops=1)

  • Filter: ((macosvertragsnummer IS NOT NULL) AND (rpl_on_ts_dt = '9999-12-31 23:59:59.999'::timestamp without time zone) AND (kundenstatuscode = '0'::numeric))
  • Rows Removed by Filter: 22067
78. 0.000 0.000 ↓ 0.0 0 352

Materialize (cost=0.41..4.46 rows=2 width=23) (actual time=0.000..0.000 rows=0 loops=352)

79. 0.021 0.021 ↓ 0.0 0 1

Index Only Scan using prtnr_id_inx1 on prtnr_id pid_company (cost=0.41..4.45 rows=2 width=23) (actual time=0.021..0.021 rows=0 loops=1)

  • Index Cond: (appl_sys_sid = 'FINNOVA_KEY'::text)
  • Heap Fetches: 0
80. 0.000 0.000 ↓ 0.0 0

Index Scan using finn_portfolio_employer_stgpk on finn_portfolio_employer_stg fpes_1 (cost=0.28..8.43 rows=3 width=22) (never executed)

  • Index Cond: (kundenlaufnummerarbeitgeber = fcs_employer.kundenlaufnummer)
  • Filter: (rpl_on_ts_dt = '9999-12-31 23:59:59.999'::timestamp without time zone)
81. 0.000 0.000 ↓ 0.0 0

Index Scan using finn_client_stg_roai on finn_client_stg fcs_employee (cost=0.29..3.92 rows=1 width=27) (never executed)

  • Index Cond: (kundenlaufnummer = fpes_1.kundenlaufnummer)
  • Filter: (kundenstatuscode = '0'::numeric)
82. 0.000 0.000 ↓ 0.0 0

Index Scan using prtnr_rel_id_apk1 on prtnr_rel_id prid_4 (cost=0.41..8.43 rows=1 width=25) (never executed)

  • Index Cond: ((appl_sys_sid)::text = 'FINNOVA'::text)
83. 0.000 0.000 ↓ 0.0 0

Index Only Scan using prtnr_id_inx1 on prtnr_id pid_employee (cost=0.42..0.46 rows=1 width=23) (never executed)

  • Index Cond: ((appl_sys_sid = 'FINNOVA_KEY'::text) AND (ntiv_prtnr_sid = ((fcs_employee.kundenlaufnummer)::character varying)::text))
  • Heap Fetches: 0
Planning time : 92.945 ms
Execution time : 949.010 ms