explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FUMu

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 2,167.655 ↓ 0.0 0 1

Limit (cost=238,109.88..238,122.84 rows=100 width=459) (actual time=2,167.655..2,167.655 rows=0 loops=1)

2. 0.001 2,167.654 ↓ 0.0 0 1

Unique (cost=238,109.88..238,557.67 rows=3,456 width=459) (actual time=2,167.654..2,167.654 rows=0 loops=1)

3. 0.119 2,167.653 ↓ 0.0 0 1

Sort (cost=238,109.88..238,127.10 rows=6,889 width=459) (actual time=2,167.653..2,167.653 rows=0 loops=1)

  • Sort Key: zonfpview0_.kod, zonfpview0_.id, zonfpview0_.datelock, zonfpview0_.datumcaspredlozeniazonfp, zonfpview0_.datumschvaleniazamietnutia, zonfpview0_.fazacislo, zonfpview0_.icoziadatel, zonfpview0_.nazov, zonfpview0_.nazovziadatel, zonfpview0_.pocetbodovhodnoteniacelkovy, zonfpview0_.projektid, zonfpview0_.projektnazov, zonfpview0_.schvalenavyskanfp, zonfpview0_.sposobodoslania, zonfpview0_.stavid, zonfpview0_.stavnazov, zonfpview0_.stavpriznak, zonfpview0_.styriocinazov, zonfpview0_.sumaschvalenacelkova, zonfpview0_.sumaziadanacelkova, zonfpview0_.userlock_id, zonfpview0_.verziaid, zonfpview0_.vratenespat, zonfpview0_.vyhlasovatelvyzvy, zonfpview0_.ziadanavyskanfp
  • Sort Method: quicksort Memory: 25kB
4. 0.000 2,167.534 ↓ 0.0 0 1

Merge Semi Join (cost=227,698.15..237,670.71 rows=6,889 width=459) (actual time=2,167.534..2,167.534 rows=0 loops=1)

  • Merge Cond: (specificke2_.specifickyciel_id = vizibilita12_.specifickyciel_id)
5. 0.001 2,167.534 ↓ 0.0 0 1

Nested Loop Left Join (cost=227,688.25..237,558.32 rows=27,891 width=475) (actual time=2,167.534..2,167.534 rows=0 loops=1)

6. 0.001 2,167.533 ↓ 0.0 0 1

Nested Loop Left Join (cost=227,687.83..228,581.59 rows=12,135 width=483) (actual time=2,167.533..2,167.533 rows=0 loops=1)

7. 0.000 2,167.532 ↓ 0.0 0 1

Merge Join (cost=227,687.40..227,703.53 rows=624 width=483) (actual time=2,167.532..2,167.532 rows=0 loops=1)

  • Merge Cond: (specificke2_.specifickyciel_id = specificky3_.id)
8. 0.004 2,167.532 ↓ 0.0 0 1

Sort (cost=227,687.25..227,688.81 rows=624 width=475) (actual time=2,167.532..2,167.532 rows=0 loops=1)

  • Sort Key: specificke2_.specifickyciel_id
  • Sort Method: quicksort Memory: 25kB
9. 0.000 2,167.528 ↓ 0.0 0 1

Nested Loop (cost=142,961.46..227,658.28 rows=624 width=475) (actual time=2,167.528..2,167.528 rows=0 loops=1)

  • Join Filter: (zonfpview0_.verziaid = specificke2_.zonfpverzia_id)
10. 634.711 2,167.528 ↓ 0.0 0 1

Nested Loop Left Join (cost=142,961.17..227,459.37 rows=604 width=467) (actual time=2,167.528..2,167.528 rows=0 loops=1)

  • Filter: (f_unaccent(lower(dokument6_.nazov)) ~~ '%vypis%'::text)
  • Rows Removed by Filter: 48722
11. 33.130 996.875 ↓ 1.1 48,722 1

Merge Left Join (cost=142,960.74..147,097.71 rows=44,183 width=475) (actual time=871.748..996.875 rows=48,722 loops=1)

  • Merge Cond: (zonfpverzi1_.id = dokumenty5_.zonfpverzia_id)
12. 19.994 903.641 ↑ 1.0 17,282 1

Merge Join (cost=142,960.45..144,020.59 rows=17,282 width=467) (actual time=871.609..903.641 rows=17,282 loops=1)

  • Merge Cond: (zonfpview0_.verziaid = zonfpverzi1_.id)
13. 25.850 875.865 ↑ 1.0 17,282 1

Sort (cost=142,960.16..143,003.36 rows=17,282 width=459) (actual time=871.533..875.865 rows=17,282 loops=1)

  • Sort Key: zonfpview0_.verziaid
  • Sort Method: quicksort Memory: 9887kB
14. 3.987 850.015 ↑ 1.0 17,282 1

Subquery Scan on zonfpview0_ (cost=140,231.59..141,743.77 rows=17,282 width=459) (actual time=815.771..850.015 rows=17,282 loops=1)

15. 27.323 846.028 ↑ 1.0 17,282 1

GroupAggregate (cost=140,231.59..141,570.95 rows=17,282 width=459) (actual time=815.770..846.028 rows=17,282 loops=1)

  • Group Key: zonfp.id, subjektverzia.nazovuplny, subjektverzia.ico, stav.nazov, workflowst7_.vratenespat, workflowst8_.priznak, projektverzia.nazov, (concat(oif.kod, ' - ', oif.nazov)), faza.cislo, workflowpr9_.nazov, zonfpverzia.id, projekt.id, odoslanie.sposobodoslania
16. 28.071 818.705 ↑ 1.0 17,282 1

Sort (cost=140,231.59..140,274.80 rows=17,282 width=468) (actual time=815.750..818.705 rows=17,282 loops=1)

  • Sort Key: zonfp.id, subjektverzia.nazovuplny, subjektverzia.ico, stav.nazov, workflowst7_.vratenespat, workflowst8_.priznak, projektverzia.nazov, (concat(oif.kod, ' - ', oif.nazov)), faza.cislo, workflowpr9_.nazov, zonfpverzia.id, projekt.id, odoslanie.sposobodoslania
  • Sort Method: quicksort Memory: 9973kB
17. 20.234 790.634 ↑ 1.0 17,282 1

Nested Loop Left Join (cost=23,204.52..139,015.20 rows=17,282 width=468) (actual time=341.310..790.634 rows=17,282 loops=1)

18. 10.439 770.400 ↑ 1.0 17,282 1

Nested Loop Left Join (cost=23,204.09..130,623.55 rows=17,282 width=475) (actual time=341.291..770.400 rows=17,282 loops=1)

19. 2.073 759.961 ↑ 1.0 17,282 1

Nested Loop Left Join (cost=23,203.66..122,275.12 rows=17,282 width=477) (actual time=341.286..759.961 rows=17,282 loops=1)

20. 13.050 740.606 ↑ 1.0 17,282 1

Nested Loop Left Join (cost=23,203.23..113,926.68 rows=17,282 width=479) (actual time=341.280..740.606 rows=17,282 loops=1)

21. 9.779 675.710 ↑ 1.0 17,282 1

Nested Loop Left Join (cost=23,202.79..105,578.24 rows=17,282 width=481) (actual time=341.277..675.710 rows=17,282 loops=1)

22. 9.858 614.085 ↑ 1.0 17,282 1

Nested Loop Left Join (cost=23,202.37..85,329.73 rows=17,282 width=457) (actual time=341.273..614.085 rows=17,282 loops=1)

23. 10.007 604.227 ↑ 1.0 17,282 1

Nested Loop Left Join (cost=23,201.93..76,981.29 rows=17,282 width=459) (actual time=341.269..604.227 rows=17,282 loops=1)

24. 14.655 594.220 ↑ 1.0 17,282 1

Hash Left Join (cost=23,201.50..68,632.85 rows=17,282 width=461) (actual time=341.260..594.220 rows=17,282 loops=1)

  • Hash Cond: (dv.odoslanie_id = odoslanie.id)
25. 15.029 522.907 ↑ 1.0 17,282 1

Nested Loop Left Join (cost=18,222.85..63,608.83 rows=17,282 width=460) (actual time=284.106..522.907 rows=17,282 loops=1)

26. 10.694 507.878 ↑ 1.0 17,282 1

Nested Loop Left Join (cost=18,222.41..55,260.39 rows=17,282 width=462) (actual time=284.104..507.878 rows=17,282 loops=1)

27. 10.012 462.620 ↑ 1.0 17,282 1

Nested Loop Left Join (cost=18,221.98..46,911.95 rows=17,282 width=464) (actual time=284.102..462.620 rows=17,282 loops=1)

28. 6.217 418.044 ↑ 1.0 17,282 1

Hash Left Join (cost=18,221.55..26,663.45 rows=17,282 width=440) (actual time=284.096..418.044 rows=17,282 loops=1)

  • Hash Cond: (workflowst7_.workflowprechod_id = workflowpr9_.id)
29. 7.866 411.225 ↑ 1.0 17,282 1

Hash Left Join (cost=18,171.13..26,567.66 rows=17,282 width=394) (actual time=283.484..411.225 rows=17,282 loops=1)

  • Hash Cond: (stav.faza_id = faza.id)
30. 8.919 403.265 ↑ 1.0 17,282 1

Hash Left Join (cost=18,160.97..26,511.30 rows=17,282 width=398) (actual time=283.382..403.265 rows=17,282 loops=1)

  • Hash Cond: (workflowst8_.stav_id = stav.id)
31. 8.422 394.075 ↑ 1.0 17,282 1

Hash Left Join (cost=18,147.13..26,451.46 rows=17,282 width=378) (actual time=283.096..394.075 rows=17,282 loops=1)

  • Hash Cond: (workflowst7_.workflowstav_id = workflowst8_.id)
32. 37.786 385.309 ↑ 1.0 17,282 1

Hash Right Join (cost=18,128.50..26,387.10 rows=17,282 width=372) (actual time=282.737..385.309 rows=17,282 loops=1)

  • Hash Cond: (dv.id = zonfpverzia.draftzonfp_id)
33. 65.047 65.047 ↑ 1.0 42,311 1

Seq Scan on d_zonfpdraftverzia dv (cost=0.00..7,927.11 rows=42,311 width=16) (actual time=0.043..65.047 rows=42,311 loops=1)

34. 15.107 282.476 ↑ 1.0 17,282 1

Hash (cost=17,912.48..17,912.48 rows=17,282 width=372) (actual time=282.476..282.476 rows=17,282 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 6468kB
35. 41.503 267.369 ↑ 1.0 17,282 1

Hash Right Join (cost=13,162.31..17,912.48 rows=17,282 width=372) (actual time=199.435..267.369 rows=17,282 loops=1)

  • Hash Cond: (workflowst7_.id = zonfp.workflowstavaktualny_id)
36. 26.695 26.695 ↑ 1.0 178,789 1

Seq Scan on d_workflowstavaktualny workflowst7_ (cost=0.00..3,906.89 rows=178,789 width=25) (actual time=0.022..26.695 rows=178,789 loops=1)

37. 16.330 199.171 ↑ 1.0 17,282 1

Hash (cost=12,946.28..12,946.28 rows=17,282 width=355) (actual time=199.171..199.171 rows=17,282 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 6257kB
38. 8.248 182.841 ↑ 1.0 17,282 1

Hash Left Join (cost=4,805.25..12,946.28 rows=17,282 width=355) (actual time=57.395..182.841 rows=17,282 loops=1)

  • Hash Cond: (projekt.aktualnaverzia_id = projektverzia.id)
39. 7.722 158.081 ↑ 1.0 17,282 1

Hash Left Join (cost=2,947.67..11,043.32 rows=17,282 width=296) (actual time=40.764..158.081 rows=17,282 loops=1)

  • Hash Cond: (zonfp.projekt_id = projekt.id)
40. 6.859 147.454 ↑ 1.0 17,282 1

Hash Join (cost=2,620.25..10,670.52 rows=17,282 width=288) (actual time=37.794..147.454 rows=17,282 loops=1)

  • Hash Cond: (vyzvaverzia.vyhlasovatel_id = oif.id)
41. 7.725 140.425 ↑ 1.0 17,282 1

Hash Join (cost=2,611.50..10,615.50 rows=17,282 width=259) (actual time=37.617..140.425 rows=17,282 loops=1)

  • Hash Cond: (zonfpverzia.vyzvaverzia_id = vyzvaverzia.id)
42. 11.602 129.896 ↑ 1.0 17,282 1

Hash Join (cost=2,365.89..10,324.42 rows=17,282 width=259) (actual time=34.799..129.896 rows=17,282 loops=1)

  • Hash Cond: (zonfpverzia.ziadatel_id = subjekt.id)
43. 27.118 93.666 ↑ 1.0 17,282 1

Hash Join (cost=726.85..8,447.75 rows=17,282 width=232) (actual time=10.064..93.666 rows=17,282 loops=1)

  • Hash Cond: (zonfpverzia.id = zonfp.verziazonfpaktualna_id)
44. 56.638 56.638 ↑ 1.0 38,915 1

Seq Scan on d_zonfpverzia zonfpverzia (cost=0.00..7,402.15 rows=38,915 width=174) (actual time=0.022..56.638 rows=38,915 loops=1)

45. 4.144 9.910 ↑ 1.0 17,282 1

Hash (cost=510.82..510.82 rows=17,282 width=66) (actual time=9.910..9.910 rows=17,282 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1642kB
46. 5.766 5.766 ↑ 1.0 17,282 1

Seq Scan on d_zonfp zonfp (cost=0.00..510.82 rows=17,282 width=66) (actual time=0.018..5.766 rows=17,282 loops=1)

47. 3.247 24.628 ↑ 1.0 14,643 1

Hash (cost=1,456.01..1,456.01 rows=14,643 width=43) (actual time=24.628..24.628 rows=14,643 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 1194kB
48. 8.127 21.381 ↑ 1.0 14,643 1

Hash Join (cost=515.47..1,456.01 rows=14,643 width=43) (actual time=7.177..21.381 rows=14,643 loops=1)

  • Hash Cond: (subjektverzia.id = subjekt.subjektverziaaktualna_id)
49. 6.170 6.170 ↑ 1.0 24,517 1

Seq Scan on d_subjektverzia subjektverzia (cost=0.00..876.17 rows=24,517 width=43) (actual time=0.025..6.170 rows=24,517 loops=1)

50. 2.865 7.084 ↑ 1.0 14,643 1

Hash (cost=332.43..332.43 rows=14,643 width=16) (actual time=7.084..7.084 rows=14,643 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 815kB
51. 4.219 4.219 ↑ 1.0 14,643 1

Seq Scan on d_subjekt subjekt (cost=0.00..332.43 rows=14,643 width=16) (actual time=0.016..4.219 rows=14,643 loops=1)

52. 0.414 2.804 ↑ 1.0 1,894 1

Hash (cost=221.94..221.94 rows=1,894 width=16) (actual time=2.804..2.804 rows=1,894 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 105kB
53. 2.390 2.390 ↑ 1.0 1,894 1

Seq Scan on d_vyzvaverzia vyzvaverzia (cost=0.00..221.94 rows=1,894 width=16) (actual time=0.023..2.390 rows=1,894 loops=1)

54. 0.067 0.170 ↑ 1.0 211 1

Hash (cost=6.11..6.11 rows=211 width=45) (actual time=0.170..0.170 rows=211 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 25kB
55. 0.103 0.103 ↑ 1.0 211 1

Seq Scan on d_organimplementaciefondov oif (cost=0.00..6.11 rows=211 width=45) (actual time=0.018..0.103 rows=211 loops=1)

56. 1.093 2.905 ↑ 1.0 8,552 1

Hash (cost=220.52..220.52 rows=8,552 width=16) (actual time=2.905..2.905 rows=8,552 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 529kB
57. 1.812 1.812 ↑ 1.0 8,552 1

Seq Scan on d_projekt projekt (cost=0.00..220.52 rows=8,552 width=16) (actual time=0.023..1.812 rows=8,552 loops=1)

58. 2.741 16.512 ↑ 1.0 8,559 1

Hash (cost=1,750.59..1,750.59 rows=8,559 width=75) (actual time=16.512..16.512 rows=8,559 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 1057kB
59. 13.771 13.771 ↑ 1.0 8,559 1

Seq Scan on d_projektverzia projektverzia (cost=0.00..1,750.59 rows=8,559 width=75) (actual time=0.024..13.771 rows=8,559 loops=1)

60. 0.136 0.344 ↑ 1.0 517 1

Hash (cost=12.17..12.17 rows=517 width=22) (actual time=0.344..0.344 rows=517 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 37kB
61. 0.208 0.208 ↑ 1.0 517 1

Seq Scan on d_workflowstav workflowst8_ (cost=0.00..12.17 rows=517 width=22) (actual time=0.013..0.208 rows=517 loops=1)

62. 0.162 0.271 ↑ 1.0 304 1

Hash (cost=10.04..10.04 rows=304 width=36) (actual time=0.271..0.271 rows=304 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 30kB
63. 0.109 0.109 ↑ 1.0 304 1

Seq Scan on d_stav stav (cost=0.00..10.04 rows=304 width=36) (actual time=0.019..0.109 rows=304 loops=1)

64. 0.032 0.094 ↑ 1.0 229 1

Hash (cost=7.29..7.29 rows=229 width=12) (actual time=0.094..0.094 rows=229 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
65. 0.062 0.062 ↑ 1.0 229 1

Seq Scan on d_faza faza (cost=0.00..7.29 rows=229 width=12) (actual time=0.008..0.062 rows=229 loops=1)

66. 0.224 0.602 ↑ 1.0 1,219 1

Hash (cost=35.19..35.19 rows=1,219 width=62) (actual time=0.602..0.602 rows=1,219 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 133kB
67. 0.378 0.378 ↑ 1.0 1,219 1

Seq Scan on d_workflowprechod workflowpr9_ (cost=0.00..35.19 rows=1,219 width=62) (actual time=0.024..0.378 rows=1,219 loops=1)

68. 34.564 34.564 ↓ 0.0 0 17,282

Index Scan using d_sumaspolu_pkey on d_sumaspolu sumaziadanacelkovaintenzity (cost=0.43..1.17 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=17,282)

  • Index Cond: (zonfpverzia.sumaziadanacelkovaintenzity_id = id)
69. 34.564 34.564 ↓ 0.0 0 17,282

Index Scan using d_sumapodiel_pkey on d_sumapodiel ziadanapodieleu (cost=0.43..0.48 rows=1 width=14) (actual time=0.002..0.002 rows=0 loops=17,282)

  • Index Cond: (id = sumaziadanacelkovaintenzity.podieleu_id)
70. 0.000 0.000 ↓ 0.0 0 17,282

Index Scan using d_sumapodiel_pkey on d_sumapodiel ziadanapodielsr (cost=0.43..0.48 rows=1 width=14) (actual time=0.000..0.000 rows=0 loops=17,282)

  • Index Cond: (id = sumaziadanacelkovaintenzity.podielsr_id)
71. 24.154 56.658 ↑ 1.0 108,918 1

Hash (cost=3,617.18..3,617.18 rows=108,918 width=17) (actual time=56.658..56.658 rows=108,918 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 6935kB
72. 32.504 32.504 ↑ 1.0 108,918 1

Seq Scan on d_odoslanie odoslanie (cost=0.00..3,617.18 rows=108,918 width=17) (actual time=0.021..32.504 rows=108,918 loops=1)

73. 0.000 0.000 ↓ 0.0 0 17,282

Index Scan using d_sumapodiel_pkey on d_sumapodiel ziadanapodielpr (cost=0.43..0.48 rows=1 width=14) (actual time=0.000..0.000 rows=0 loops=17,282)

  • Index Cond: (id = sumaziadanacelkovaintenzity.podielpr_id)
74. 0.000 0.000 ↓ 0.0 0 17,282

Index Scan using d_sumapodiel_pkey on d_sumapodiel ziadanapodielyei (cost=0.43..0.48 rows=1 width=14) (actual time=0.000..0.000 rows=0 loops=17,282)

  • Index Cond: (id = sumaziadanacelkovaintenzity.podielyei_id)
75. 51.846 51.846 ↓ 0.0 0 17,282

Index Scan using d_sumaspolu_pkey on d_sumaspolu sumaschvalenacelkovaintenzity (cost=0.43..1.17 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=17,282)

  • Index Cond: (zonfpverzia.sumaschvalenacelkovaintenzity_id = id)
76. 51.846 51.846 ↓ 0.0 0 17,282

Index Scan using d_sumapodiel_pkey on d_sumapodiel schvalenapodieleu (cost=0.43..0.48 rows=1 width=14) (actual time=0.003..0.003 rows=0 loops=17,282)

  • Index Cond: (id = sumaschvalenacelkovaintenzity.podieleu_id)
77. 17.282 17.282 ↓ 0.0 0 17,282

Index Scan using d_sumapodiel_pkey on d_sumapodiel schvalenapodielsr (cost=0.43..0.48 rows=1 width=14) (actual time=0.001..0.001 rows=0 loops=17,282)

  • Index Cond: (id = sumaschvalenacelkovaintenzity.podielsr_id)
78. 0.000 0.000 ↓ 0.0 0 17,282

Index Scan using d_sumapodiel_pkey on d_sumapodiel schvalenapodielpr (cost=0.43..0.48 rows=1 width=14) (actual time=0.000..0.000 rows=0 loops=17,282)

  • Index Cond: (id = sumaschvalenacelkovaintenzity.podielpr_id)
79. 0.000 0.000 ↓ 0.0 0 17,282

Index Scan using d_sumapodiel_pkey on d_sumapodiel schvalenapodielyei (cost=0.43..0.48 rows=1 width=14) (actual time=0.000..0.000 rows=0 loops=17,282)

  • Index Cond: (id = sumaschvalenacelkovaintenzity.podielyei_id)
80. 7.782 7.782 ↑ 1.0 38,915 1

Index Only Scan using d_zonfpverzia_pkey on d_zonfpverzia zonfpverzi1_ (cost=0.29..703.91 rows=38,915 width=8) (actual time=0.051..7.782 rows=38,915 loops=1)

  • Heap Fetches: 0
81. 60.104 60.104 ↑ 1.0 99,489 1

Index Scan using zonfpverzia_to_dokument__zonfpverzia_id_idx on zonfpverzia_to_dokument dokumenty5_ (cost=0.29..2,343.36 rows=99,489 width=16) (actual time=0.057..60.104 rows=99,489 loops=1)

82. 535.942 535.942 ↑ 1.0 1 48,722

Index Scan using d_dokument_pkey on d_dokument dokument6_ (cost=0.43..1.55 rows=1 width=45) (actual time=0.011..0.011 rows=1 loops=48,722)

  • Index Cond: (dokumenty5_.dokument_id = id)
83. 0.000 0.000 ↓ 0.0 0

Index Scan using zonfpverzia_to_specifickyciel__zonfpverzia_id_idx on zonfpverzia_to_specifickyciel specificke2_ (cost=0.29..0.32 rows=1 width=16) (never executed)

  • Index Cond: (zonfpverzia_id = zonfpverzi1_.id)
84. 0.000 0.000 ↓ 0.0 0

Index Only Scan using d_specifickyciel_pkey on d_specifickyciel specificky3_ (cost=0.15..6.26 rows=261 width=8) (never executed)

  • Heap Fetches: 0
85. 0.000 0.000 ↓ 0.0 0

Index Scan using d_podmienkapomocidokument__zonfpverzia_id_idx on d_podmienkapomocidokumentzonfp podmienkyp7_ (cost=0.42..1.14 rows=27 width=16) (never executed)

  • Index Cond: (zonfpverzi1_.id = zonfpverzia_id)
86. 0.000 0.000 ↓ 0.0 0

Index Only Scan using podmienkapomocidokumentzonfp_to_dokument__dokument_id_idx on podmienkapomocidokumentzonfp_to_dokument dokumenty8_ (cost=0.43..0.63 rows=11 width=16) (never executed)

  • Index Cond: (podmienkapomocidokumentzonfp_id = podmienkyp7_.id)
  • Heap Fetches: 0
87. 0.000 0.000 ↓ 0.0 0

Sort (cost=9.90..9.97 rows=26 width=16) (never executed)

  • Sort Key: vizibilita12_.specifickyciel_id
88. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.86..9.29 rows=26 width=16) (never executed)

89. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.71..4.99 rows=26 width=8) (never executed)

  • Join Filter: (zaradeniez10_.organ_id = vizibilita12_.organ_id)
90. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..3.77 rows=1 width=16) (never executed)

91. 0.000 0.000 ↓ 0.0 0

Index Scan using d_zaradeniezamestnanecorganu_osoba_id_idx on d_zaradeniezamestnanecorganu zaradeniez10_ (cost=0.28..2.50 rows=1 width=8) (never executed)

  • Index Cond: (osoba_id = 1088)
  • Filter: (dateinvalidate IS NULL)
92. 0.000 0.000 ↓ 0.0 0

Index Only Scan using d_organimplementaciefondov_pkey on d_organimplementaciefondov organimple11_ (cost=0.14..1.26 rows=1 width=8) (never executed)

  • Index Cond: (id = zaradeniez10_.organ_id)
  • Heap Fetches: 0
93. 0.000 0.000 ↓ 0.0 0

Index Only Scan using d_vizibilitaps_organ_id_specifickyciel_id_key on d_vizibilitaps vizibilita12_ (cost=0.28..0.88 rows=27 width=16) (never executed)

  • Index Cond: (organ_id = organimple11_.id)
  • Heap Fetches: 0
94. 0.000 0.000 ↓ 0.0 0

Index Only Scan using d_specifickyciel_pkey on d_specifickyciel specificky13_ (cost=0.15..0.17 rows=1 width=8) (never executed)

  • Index Cond: (id = vizibilita12_.specifickyciel_id)
  • Heap Fetches: 0