explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4Jq4 : Optimization for: Optimization for: Optimization for: plan #VWvn; plan #jLt2; plan #WI2t

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.045 1,988.768 ↓ 12.5 25 1

Sort (cost=252,818.42..252,818.42 rows=2 width=625) (actual time=1,988.767..1,988.768 rows=25 loops=1)

  • Sort Key: (CASE WHEN (p.idgeneralagreement = ANY ('{LH-CYBER,LH-DC,LH-LIC-CYBER,LH-LIC-DC,LH-LIC-DNO,LH-LIC-PA,LH-LIC-PA-MEDICA,LH-LIC-PA-MEDICARE,LH-LIC-PA-RC,LH-LIC-PI-ACC,LH-LIC-PI-PROPERTY-MANAGER,LH-LIC-PI-PROPERTY-REALTOR,LH-LIC-PI-TAX-ADVISOR,LH-LIC-SP,LH-LI-SQUARELIFE,LH-SP,MF-CITY,MF-DM,MF-DNO,MF-DNO-COOP,MF-DNO-MED,MF-DNO-SECTION2,MF-ECO,MF-EIBV,MF-GOIL,MF-IDEA-BANK,MF-IPO,MF-KOL,MF-LH-DNO-NG,MF-LH-LI,MF-LH-PI-ACC,MF-LH-PI-PROPERTY-MANAGER,MF-LH-PI-PROPERTY-REALTOR,MF-LH-PI-TAX-ADVISOR,MF-LUX,MF-MAKV,MF-MEDI,MF-MEDICA,MF-MSW,MF-PA,MF-PA-NG,MF-PA-NG-MEDICA,MF-PA-NG-MEDICARE,MF-PA-RC,MF-POL,MF-POLFP,MF-PRRM,MF-PWSFP,MF-PWSM,MF-RC,MF-RKBV,MF-SFS,MF-TAX-CARE}'::text[])) THEN ppremium.premium WHEN (od.offerstatus <> 'VISIBLE'::text) THEN NULL::numeric ELSE ppremium.premium END), pv.id
  • Sort Method: quicksort Memory: 37kB
2.          

CTE datawindow

3. 0.015 1,985.396 ↑ 1.0 25 1

Limit (cost=252,006.77..252,006.83 rows=25 width=65) (actual time=1,985.381..1,985.396 rows=25 loops=1)

4. 0.236 1,985.381 ↑ 1,754.6 25 1

Sort (cost=252,006.77..252,116.43 rows=43,865 width=65) (actual time=1,985.380..1,985.381 rows=25 loops=1)

  • Sort Key: (CASE WHEN (p_1.idgeneralagreement = ANY ('{LH-CYBER,LH-DC,LH-LIC-CYBER,LH-LIC-DC,LH-LIC-DNO,LH-LIC-PA,LH-LIC-PA-MEDICA,LH-LIC-PA-MEDICARE,LH-LIC-PA-RC,LH-LIC-PI-ACC,LH-LIC-PI-PROPERTY-MANAGER,LH-LIC-PI-PROPERTY-REALTOR,LH-LIC-PI-TAX-ADVISOR,LH-LIC-SP,LH-LI-SQUARELIFE,LH-SP,MF-CITY,MF-DM,MF-DNO,MF-DNO-COOP,MF-DNO-MED,MF-DNO-SECTION2,MF-ECO,MF-EIBV,MF-GOIL,MF-IDEA-BANK,MF-IPO,MF-KOL,MF-LH-DNO-NG,MF-LH-LI,MF-LH-PI-ACC,MF-LH-PI-PROPERTY-MANAGER,MF-LH-PI-PROPERTY-REALTOR,MF-LH-PI-TAX-ADVISOR,MF-LUX,MF-MAKV,MF-MEDI,MF-MEDICA,MF-MSW,MF-PA,MF-PA-NG,MF-PA-NG-MEDICA,MF-PA-NG-MEDICARE,MF-PA-RC,MF-POL,MF-POLFP,MF-PRRM,MF-PWSFP,MF-PWSM,MF-RC,MF-RKBV,MF-SFS,MF-TAX-CARE}'::text[])) THEN (CASE p_2.showannualpremium WHEN CASE_TEST_EXPR THEN premiums.annualpremium ELSE premiums.premium END) WHEN (od_1.offerstatus <> 'VISIBLE'::text) THEN NULL::numeric ELSE (CASE p_2.showannualpremium WHEN CASE_TEST_EXPR THEN premiums.annualpremium ELSE premiums.premium END) END), pv_1.id
  • Sort Method: top-N heapsort Memory: 28kB
5. 0.429 1,985.145 ↑ 35.6 1,233 1

WindowAgg (cost=207,252.02..250,768.93 rows=43,865 width=65) (actual time=1,984.968..1,985.145 rows=1,233 loops=1)

6. 0.074 1,984.716 ↑ 35.6 1,233 1

Append (cost=207,252.02..250,220.62 rows=43,865 width=57) (actual time=1,714.041..1,984.716 rows=1,233 loops=1)

7. 28.778 1,984.626 ↑ 35.6 1,233 1

Hash Right Join (cost=207,252.02..249,552.99 rows=43,864 width=57) (actual time=1,714.040..1,984.626 rows=1,233 loops=1)

  • Hash Cond: (pv_2.id = pv_1.id)
8. 120.021 1,611.410 ↓ 2.0 349,901 1

Hash Join (cost=126,196.48..164,594.98 rows=177,247 width=40) (actual time=1,369.543..1,611.410 rows=349,901 loops=1)

  • Hash Cond: (p_2.id = pv_2.idpolicy)
9. 122.063 122.063 ↑ 1.0 271,914 1

Seq Scan on tblpolicy p_2 (cost=0.00..35,602.47 rows=272,947 width=9) (actual time=0.009..122.063 rows=271,914 loops=1)

10. 78.016 1,369.326 ↓ 2.0 349,901 1

Hash (cost=123,980.90..123,980.90 rows=177,247 width=80) (actual time=1,369.326..1,369.326 rows=349,901 loops=1)

  • Buckets: 524288 (originally 262144) Batches: 1 (originally 1) Memory Usage: 25967kB
11. 145.605 1,291.310 ↓ 2.0 349,901 1

Hash Join (cost=93,274.38..123,980.90 rows=177,247 width=80) (actual time=1,105.008..1,291.310 rows=349,901 loops=1)

  • Hash Cond: (pv_2.id = premiums.idpolicyversion)
12. 41.626 41.626 ↑ 1.0 349,981 1

Seq Scan on tblpolicyversion pv_2 (cost=0.00..29,787.81 rows=349,981 width=16) (actual time=0.007..41.626 rows=349,981 loops=1)

13. 77.107 1,104.079 ↓ 2.0 349,901 1

Hash (cost=91,058.79..91,058.79 rows=177,247 width=72) (actual time=1,104.078..1,104.079 rows=349,901 loops=1)

  • Buckets: 524288 (originally 262144) Batches: 1 (originally 1) Memory Usage: 21430kB
14. 26.537 1,026.972 ↓ 2.0 349,901 1

Subquery Scan on premiums (cost=63,808.05..91,058.79 rows=177,247 width=72) (actual time=350.090..1,026.972 rows=349,901 loops=1)

15. 272.006 1,000.435 ↓ 2.0 349,901 1

GroupAggregate (cost=63,808.05..89,286.32 rows=177,247 width=136) (actual time=350.088..1,000.435 rows=349,901 loops=1)

  • Group Key: rp.idpolicyversion
16. 296.820 728.429 ↑ 1.0 536,931 1

WindowAgg (cost=63,808.05..75,888.99 rows=536,931 width=76) (actual time=350.075..728.429 rows=536,931 loops=1)

17. 353.047 431.609 ↑ 1.0 536,931 1

Sort (cost=63,808.05..65,150.37 rows=536,931 width=32) (actual time=350.056..431.609 rows=536,931 loops=1)

  • Sort Key: rp.idpolicyversion, rp.riskname, rp.validfrom DESC
  • Sort Method: quicksort Memory: 71781kB
18. 78.562 78.562 ↑ 1.0 536,931 1

Seq Scan on tblriskpremium rp (cost=0.00..12,707.31 rows=536,931 width=32) (actual time=0.011..78.562 rows=536,931 loops=1)

19. 0.301 344.438 ↑ 35.6 1,233 1

Hash (cost=80,507.23..80,507.23 rows=43,864 width=26) (actual time=344.438..344.438 rows=1,233 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 592kB
20. 17.705 344.137 ↑ 35.6 1,233 1

Hash Join (cost=43,047.44..80,507.23 rows=43,864 width=26) (actual time=209.515..344.137 rows=1,233 loops=1)

  • Hash Cond: (p_1.id = pv_1.idpolicy)
21. 116.995 116.995 ↓ 1.0 196,487 1

Seq Scan on tblpolicy p_1 (cost=0.00..36,284.84 rows=196,352 width=19) (actual time=0.010..116.995 rows=196,487 loops=1)

  • Filter: ((NOT test) AND (policytype = 'OFFER'::text))
  • Rows Removed by Filter: 75427
22. 0.288 209.437 ↑ 47.5 1,283 1

Hash (cost=42,285.25..42,285.25 rows=60,975 width=23) (actual time=209.437..209.437 rows=1,283 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 583kB
23. 26.197 209.149 ↑ 47.5 1,283 1

Hash Join (cost=10,948.23..42,285.25 rows=60,975 width=23) (actual time=55.366..209.149 rows=1,283 loops=1)

  • Hash Cond: (pv_1.id = od_1.id)
24. 127.699 127.699 ↑ 1.0 252,684 1

Seq Scan on tblpolicyversion pv_1 (cost=0.00..30,662.76 rows=256,857 width=16) (actual time=0.006..127.699 rows=252,684 loops=1)

  • Filter: ((canceldate IS NULL) AND (policyversionstatus = 'CURRENT'::text))
  • Rows Removed by Filter: 97297
25. 0.368 55.253 ↑ 52.0 1,597 1

Hash (cost=9,909.70..9,909.70 rows=83,082 width=15) (actual time=55.253..55.253 rows=1,597 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 1099kB
26. 54.885 54.885 ↑ 52.0 1,597 1

Seq Scan on tblofferdata od_1 (cost=0.00..9,909.70 rows=83,082 width=15) (actual time=49.943..54.885 rows=1,597 loops=1)

  • Filter: (((validmarked IS NULL) OR validmarked) AND (offerstatus = ANY ('{HIDDEN,VISIBLE}'::text[])) AND ((validstartdate + validdays) >= now()))
  • Rows Removed by Filter: 277791
27. 0.000 0.016 ↓ 0.0 0 1

Nested Loop (cost=0.57..9.66 rows=1 width=57) (actual time=0.016..0.016 rows=0 loops=1)

28. 0.001 0.016 ↓ 0.0 0 1

Nested Loop (cost=0.29..9.32 rows=1 width=16) (actual time=0.016..0.016 rows=0 loops=1)

29. 0.015 0.015 ↓ 0.0 0 1

Seq Scan on tblapplicationinprogress aip_1 (cost=0.00..1.02 rows=1 width=16) (actual time=0.015..0.015 rows=0 loops=1)

  • Filter: ((removed IS NULL) AND (status = ANY ('{OPEN_BROKER,OPEN_CLIENT,SUBMITTED,CLOSED,INTERRUPTED,QUOTE_NOT_SAVED}'::text[])))
  • Rows Removed by Filter: 1
30. 0.000 0.000 ↓ 0.0 0

Index Scan using tblemployee_pkey on tblemployee employee_2 (cost=0.29..8.30 rows=1 width=16) (never executed)

  • Index Cond: (id = aip_1.idemployee)
31. 0.000 0.000 ↓ 0.0 0

Index Scan using tblagencyunit_pkey on tblagencyunit division_2 (cost=0.28..0.34 rows=1 width=8) (never executed)

  • Index Cond: (id = employee_2.idagencyunit)
  • Filter: (NOT test)
32.          

CTE ppremium

33. 0.000 1,985.796 ↑ 1.0 25 1

Nested Loop (cost=302.31..538.26 rows=25 width=80) (actual time=1,985.591..1,985.796 rows=25 loops=1)

34. 0.018 1,985.696 ↑ 1.0 25 1

Nested Loop (cost=301.88..517.01 rows=25 width=144) (actual time=1,985.578..1,985.696 rows=25 loops=1)

35. 0.038 1,985.603 ↑ 1.0 25 1

GroupAggregate (cost=301.46..305.76 rows=25 width=136) (actual time=1,985.561..1,985.603 rows=25 loops=1)

  • Group Key: rp_1.idpolicyversion
36. 0.033 1,985.565 ↑ 3.0 25 1

WindowAgg (cost=301.46..303.17 rows=76 width=50) (actual time=1,985.549..1,985.565 rows=25 loops=1)

37. 0.012 1,985.532 ↑ 3.0 25 1

Sort (cost=301.46..301.65 rows=76 width=42) (actual time=1,985.531..1,985.532 rows=25 loops=1)

  • Sort Key: rp_1.idpolicyversion, rp_1.riskname, rp_1.validfrom DESC
  • Sort Method: quicksort Memory: 26kB
38. 0.020 1,985.520 ↑ 3.0 25 1

Nested Loop (cost=0.42..299.09 rows=76 width=42) (actual time=1,985.411..1,985.520 rows=25 loops=1)

39. 1,985.400 1,985.400 ↑ 1.0 25 1

CTE Scan on datawindow w (cost=0.00..0.50 rows=25 width=8) (actual time=1,985.382..1,985.400 rows=25 loops=1)

40. 0.100 0.100 ↑ 3.0 1 25

Index Scan using tblriskpremium_idpolicyversion_index on tblriskpremium rp_1 (cost=0.42..11.91 rows=3 width=42) (actual time=0.004..0.004 rows=1 loops=25)

  • Index Cond: (idpolicyversion = w.idpolicyversion)
41. 0.075 0.075 ↑ 1.0 1 25

Index Scan using tblpolicyversion_pkey on tblpolicyversion pv_3 (cost=0.42..8.44 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=25)

  • Index Cond: (id = rp_1.idpolicyversion)
42. 0.100 0.100 ↑ 1.0 1 25

Index Scan using pk_tblinsurance on tblpolicy p_3 (cost=0.42..0.85 rows=1 width=9) (actual time=0.004..0.004 rows=1 loops=25)

  • Index Cond: (id = pv_3.idpolicy)
43. 0.004 1,988.723 ↓ 12.5 25 1

Append (cost=5.48..273.32 rows=2 width=624) (actual time=1,986.479..1,988.723 rows=25 loops=1)

44. 0.773 1,988.686 ↓ 25.0 25 1

Nested Loop Left Join (cost=5.48..252.04 rows=1 width=603) (actual time=1,986.478..1,988.686 rows=25 loops=1)

45. 0.038 1,987.863 ↓ 25.0 25 1

Nested Loop Left Join (cost=5.19..251.06 rows=1 width=662) (actual time=1,986.337..1,987.863 rows=25 loops=1)

  • Join Filter: (i.key = p.keyintegration)
  • Rows Removed by Join Filter: 101
46. 0.030 1,987.800 ↓ 25.0 25 1

Nested Loop Left Join (cost=5.19..249.20 rows=1 width=630) (actual time=1,986.329..1,987.800 rows=25 loops=1)

  • Join Filter: (p.fallbacklocale ~~* (cd_label_fallback.locale || '%'::text))
  • Rows Removed by Join Filter: 25
47. 0.015 1,987.720 ↓ 25.0 25 1

Nested Loop Left Join (cost=4.77..248.53 rows=1 width=544) (actual time=1,986.322..1,987.720 rows=25 loops=1)

48. 0.041 1,987.530 ↓ 25.0 25 1

Nested Loop Left Join (cost=4.34..247.87 rows=1 width=455) (actual time=1,986.306..1,987.530 rows=25 loops=1)

  • Join Filter: (p.idinsurancetype = it_label.id)
  • Rows Removed by Join Filter: 200
49. 0.067 1,987.214 ↓ 25.0 25 1

Nested Loop Left Join (cost=4.34..246.47 rows=1 width=423) (actual time=1,986.286..1,987.214 rows=25 loops=1)

  • Join Filter: (pl_label.id = pl.id)
  • Rows Removed by Join Filter: 375
50. 0.022 1,986.797 ↓ 25.0 25 1

Nested Loop (cost=4.34..244.98 rows=1 width=391) (actual time=1,986.258..1,986.797 rows=25 loops=1)

51. 0.012 1,986.600 ↓ 25.0 25 1

Nested Loop (cost=3.92..244.44 rows=1 width=399) (actual time=1,986.241..1,986.600 rows=25 loops=1)

  • Join Filter: (pv.id = pc_ubezpieczony.idpolicyversion)
52. 0.018 1,986.438 ↓ 25.0 25 1

Nested Loop (cost=3.50..243.82 rows=1 width=390) (actual time=1,986.226..1,986.438 rows=25 loops=1)

53. 0.022 1,986.370 ↓ 25.0 25 1

Nested Loop (cost=3.21..243.51 rows=1 width=374) (actual time=1,986.208..1,986.370 rows=25 loops=1)

54. 0.025 1,986.323 ↓ 25.0 25 1

Nested Loop (cost=2.93..243.21 rows=1 width=356) (actual time=1,986.197..1,986.323 rows=25 loops=1)

55. 0.020 1,986.248 ↓ 25.0 25 1

Hash Join (cost=2.65..242.91 rows=1 width=336) (actual time=1,986.180..1,986.248 rows=25 loops=1)

  • Hash Cond: (pv.id = ppremium.idpolicyversion)
56. 0.021 0.413 ↓ 2.8 25 1

Nested Loop (cost=1.83..242.05 rows=9 width=264) (actual time=0.357..0.413 rows=25 loops=1)

  • Join Filter: (p.idinsurancecompany = cu.id)
  • Rows Removed by Join Filter: 25
57. 0.079 0.392 ↓ 2.8 25 1

Nested Loop (cost=1.83..240.79 rows=9 width=240) (actual time=0.348..0.392 rows=25 loops=1)

  • Join Filter: (ga.idproductline = pl.id)
  • Rows Removed by Join Filter: 425
58. 0.007 0.007 ↑ 1.0 18 1

Seq Scan on tblproductline pl (cost=0.00..1.18 rows=18 width=32) (actual time=0.005..0.007 rows=18 loops=1)

59. 0.024 0.306 ↓ 2.8 25 18

Materialize (cost=1.83..237.20 rows=9 width=214) (actual time=0.003..0.017 rows=25 loops=18)

60. 0.015 0.282 ↓ 2.8 25 1

Nested Loop (cost=1.83..237.15 rows=9 width=214) (actual time=0.046..0.282 rows=25 loops=1)

61. 0.022 0.217 ↓ 2.8 25 1

Nested Loop (cost=1.69..235.71 rows=9 width=197) (actual time=0.033..0.217 rows=25 loops=1)

62. 0.010 0.170 ↓ 2.8 25 1

Nested Loop (cost=1.27..227.01 rows=9 width=136) (actual time=0.026..0.170 rows=25 loops=1)

63. 0.008 0.135 ↓ 2.3 25 1

Nested Loop (cost=0.84..221.34 rows=11 width=60) (actual time=0.021..0.135 rows=25 loops=1)

64. 0.024 0.052 ↓ 1.3 25 1

Nested Loop (cost=0.42..211.56 rows=19 width=52) (actual time=0.008..0.052 rows=25 loops=1)

65. 0.003 0.003 ↑ 1.0 25 1

CTE Scan on datawindow dw (cost=0.00..0.50 rows=25 width=16) (actual time=0.000..0.003 rows=25 loops=1)

66. 0.025 0.025 ↑ 1.0 1 25

Index Scan using tblpolicyversion_pkey on tblpolicyversion pv (cost=0.42..8.44 rows=1 width=36) (actual time=0.001..0.001 rows=1 loops=25)

  • Index Cond: (id = dw.idpolicyversion)
  • Filter: (policyversionstatus = 'CURRENT'::text)
67. 0.075 0.075 ↑ 1.0 1 25

Index Scan using tblofferdata_pkey on tblofferdata (cost=0.42..0.51 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=25)

  • Index Cond: (id = pv.id)
  • Filter: (NOT archive)
68. 0.025 0.025 ↑ 1.0 1 25

Index Scan using tblofferdata_pkey on tblofferdata od (cost=0.42..0.51 rows=1 width=76) (actual time=0.001..0.001 rows=1 loops=25)

  • Index Cond: (id = pv.id)
69. 0.025 0.025 ↑ 1.0 1 25

Index Scan using pk_tblinsurance on tblpolicy p (cost=0.42..0.97 rows=1 width=77) (actual time=0.001..0.001 rows=1 loops=25)

  • Index Cond: (id = pv.idpolicy)
70. 0.050 0.050 ↑ 1.0 1 25

Index Scan using tblgeneralagreement_pkey on tblgeneralagreement ga (cost=0.14..0.16 rows=1 width=17) (actual time=0.002..0.002 rows=1 loops=25)

  • Index Cond: (id = p.idgeneralagreement)
71. 0.000 0.000 ↑ 1.0 2 25

Materialize (cost=0.00..1.03 rows=2 width=40) (actual time=0.000..0.000 rows=2 loops=25)

72. 0.005 0.005 ↑ 1.0 2 1

Seq Scan on tblinsurancecompanyunit cu (cost=0.00..1.02 rows=2 width=40) (actual time=0.005..0.005 rows=2 loops=1)

73. 0.009 1,985.815 ↑ 1.0 25 1

Hash (cost=0.50..0.50 rows=25 width=72) (actual time=1,985.815..1,985.815 rows=25 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
74. 1,985.806 1,985.806 ↑ 1.0 25 1

CTE Scan on ppremium (cost=0.00..0.50 rows=25 width=72) (actual time=1,985.593..1,985.806 rows=25 loops=1)

75. 0.050 0.050 ↑ 1.0 1 25

Index Scan using tblagencyunit_pkey on tblagencyunit agency (cost=0.28..0.30 rows=1 width=36) (actual time=0.002..0.002 rows=1 loops=25)

  • Index Cond: (id = p.idagency)
76. 0.025 0.025 ↑ 1.0 1 25

Index Scan using tblagencyunit_pkey on tblagencyunit division (cost=0.28..0.30 rows=1 width=34) (actual time=0.001..0.001 rows=1 loops=25)

  • Index Cond: (id = p.idagencyunit)
77. 0.050 0.050 ↑ 1.0 1 25

Index Scan using tblemployee_pkey on tblemployee employee (cost=0.29..0.31 rows=1 width=24) (actual time=0.002..0.002 rows=1 loops=25)

  • Index Cond: (id = p.idemployee)
78. 0.150 0.150 ↑ 1.0 1 25

Index Scan using tblpolicyclient_idpolicyversion on tblpolicyclient pc_ubezpieczony (cost=0.42..0.61 rows=1 width=49) (actual time=0.005..0.006 rows=1 loops=25)

  • Index Cond: (idpolicyversion = od.id)
79. 0.175 0.175 ↑ 1.0 1 25

Index Only Scan using tblpolicyclientrole_role_unique on tblpolicyclientrole pcr_ubezpieczony (cost=0.42..0.54 rows=1 width=8) (actual time=0.007..0.007 rows=1 loops=25)

  • Index Cond: ((idpolicyclient = pc_ubezpieczony.id) AND (role = 'ubezpieczony'::text))
  • Heap Fetches: 25
80. 0.350 0.350 ↓ 16.0 16 25

Seq Scan on tblproductlinelabel pl_label (cost=0.00..1.48 rows=1 width=64) (actual time=0.003..0.014 rows=16 loops=25)

  • Filter: ('pl_PL'::text ~~* (locale || '%'::text))
  • Rows Removed by Filter: 16
81. 0.275 0.275 ↓ 9.0 9 25

Seq Scan on tblinsurancetypelabel it_label (cost=0.00..1.39 rows=1 width=64) (actual time=0.002..0.011 rows=9 loops=25)

  • Filter: ('pl_PL'::text ~~* (locale || '%'::text))
  • Rows Removed by Filter: 17
82. 0.175 0.175 ↑ 1.0 1 25

Index Scan using tblpolicycoveragedescription_unique on tblpolicycoveragedescription cd_label (cost=0.42..0.65 rows=1 width=97) (actual time=0.007..0.007 rows=1 loops=25)

  • Index Cond: (idpolicyversion = pv.id)
  • Filter: ('pl_PL'::text ~~* (locale || '%'::text))
  • Rows Removed by Filter: 1
83. 0.050 0.050 ↑ 1.0 2 25

Index Scan using tblpolicycoveragedescription_unique on tblpolicycoveragedescription cd_label_fallback (cost=0.42..0.64 rows=2 width=100) (actual time=0.001..0.002 rows=2 loops=25)

  • Index Cond: (idpolicyversion = pv.id)
84. 0.025 0.025 ↑ 7.6 5 25

Seq Scan on tblintegration i (cost=0.00..1.38 rows=38 width=64) (actual time=0.001..0.001 rows=5 loops=25)

85. 0.050 0.050 ↑ 1.0 1 25

Index Scan using tblclient_pkey on tblclient c (cost=0.29..0.32 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=25)

  • Index Cond: (pc_ubezpieczony.idclient = id)
86. 0.000 0.033 ↓ 0.0 0 1

Nested Loop (cost=2.62..21.25 rows=1 width=646) (actual time=0.033..0.033 rows=0 loops=1)

87. 0.001 0.033 ↓ 0.0 0 1

Nested Loop (cost=2.47..20.35 rows=1 width=212) (actual time=0.033..0.033 rows=0 loops=1)

88. 0.001 0.032 ↓ 0.0 0 1

Nested Loop (cost=2.19..20.02 rows=1 width=177) (actual time=0.032..0.032 rows=0 loops=1)

89. 0.000 0.031 ↓ 0.0 0 1

Nested Loop (cost=1.90..11.71 rows=1 width=153) (actual time=0.031..0.031 rows=0 loops=1)

90. 0.008 0.031 ↓ 0.0 0 1

Hash Join (cost=1.61..3.41 rows=1 width=125) (actual time=0.031..0.031 rows=0 loops=1)

  • Hash Cond: (pa.id = aip.idpath)
91. 0.007 0.007 ↑ 57.0 1 1

Seq Scan on tblpath pa (cost=0.00..1.57 rows=57 width=27) (actual time=0.007..0.007 rows=1 loops=1)

92. 0.000 0.016 ↓ 0.0 0 1

Hash (cost=1.60..1.60 rows=1 width=108) (actual time=0.016..0.016 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
93. 0.005 0.016 ↓ 0.0 0 1

Hash Join (cost=1.02..1.60 rows=1 width=108) (actual time=0.016..0.016 rows=0 loops=1)

  • Hash Cond: (dw_1.idaip = aip.id)
94. 0.003 0.003 ↑ 1.0 25 1

CTE Scan on datawindow dw_1 (cost=0.00..0.50 rows=25 width=16) (actual time=0.001..0.003 rows=25 loops=1)

95. 0.002 0.008 ↑ 1.0 1 1

Hash (cost=1.01..1.01 rows=1 width=100) (actual time=0.008..0.008 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
96. 0.006 0.006 ↑ 1.0 1 1

Seq Scan on tblapplicationinprogress aip (cost=0.00..1.01 rows=1 width=100) (actual time=0.006..0.006 rows=1 loops=1)

97. 0.000 0.000 ↓ 0.0 0

Index Scan using tblclient_pkey on tblclient c_1 (cost=0.29..8.31 rows=1 width=36) (never executed)

  • Index Cond: (id = aip.idclient)
98. 0.000 0.000 ↓ 0.0 0

Index Scan using tblemployee_pkey on tblemployee employee_1 (cost=0.29..8.30 rows=1 width=32) (never executed)

  • Index Cond: (id = aip.idemployee)
99. 0.000 0.000 ↓ 0.0 0

Index Scan using tblagencyunit_pkey on tblagencyunit division_1 (cost=0.28..0.34 rows=1 width=51) (never executed)

  • Index Cond: (id = employee_1.idagencyunit)
100. 0.000 0.000 ↓ 0.0 0

Index Scan using tblagencyunit_path_ltree_gist on tblagencyunit agency_1 (cost=0.15..0.36 rows=1 width=45) (never executed)

  • Index Cond: (path @> division_1.path)
  • Filter: (nlevel(path) = 1)
Planning time : 13.038 ms
Execution time : 1,996.548 ms