explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gq6

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 19,672.717 ↑ 1.0 1 1

Unique (cost=890,319.90..890,319.90 rows=1 width=8) (actual time=19,672.717..19,672.717 rows=1 loops=1)

2. 0.005 19,672.716 ↑ 1.0 1 1

Sort (cost=890,319.90..890,319.90 rows=1 width=8) (actual time=19,672.716..19,672.716 rows=1 loops=1)

  • Sort Key: (count(zonfpview0_.*))
  • Sort Method: quicksort Memory: 25kB
3. 13.191 19,672.711 ↑ 1.0 1 1

Aggregate (cost=890,319.88..890,319.89 rows=1 width=8) (actual time=19,672.711..19,672.711 rows=1 loops=1)

4. 960.171 19,659.520 ↑ 1.8 101,626 1

Nested Loop Left Join (cost=581,231.12..889,870.77 rows=179,644 width=378) (actual time=11,831.286..19,659.520 rows=101,626 loops=1)

  • Filter: ((hashed SubPlan 1) OR (hashed SubPlan 2))
  • Rows Removed by Filter: 2401861
5. 17.297 1,297.253 ↓ 9.4 50,329 1

Hash Semi Join (cost=142,980.73..179,494.47 rows=5,359 width=394) (actual time=861.939..1,297.253 rows=50,329 loops=1)

  • Hash Cond: (specificke2_.specifickyciel_id = vizibilita12_.specifickyciel_id)
6. 22.878 1,279.601 ↓ 1.1 50,329 1

Hash Join (cost=142,971.11..179,305.53 rows=45,599 width=410) (actual time=861.578..1,279.601 rows=50,329 loops=1)

  • Hash Cond: (specificke2_.specifickyciel_id = specificky3_.id)
7. 27.070 1,256.668 ↓ 1.1 50,329 1

Merge Join (cost=142,961.59..179,174.36 rows=45,599 width=402) (actual time=861.516..1,256.668 rows=50,329 loops=1)

  • Merge Cond: (specificke2_.zonfpverzia_id = zonfpview0_.verziaid)
8. 11.393 11.393 ↑ 1.0 40,162 1

Index Scan using zonfpverzia_to_specifickyciel__zonfpverzia_id_idx on zonfpverzia_to_specifickyciel specificke2_ (cost=0.29..944.05 rows=40,162 width=16) (actual time=0.019..11.393 rows=40,162 loops=1)

9. 28.297 1,218.205 ↓ 1.1 50,329 1

Materialize (cost=142,961.30..177,551.37 rows=44,183 width=402) (actual time=861.492..1,218.205 rows=50,329 loops=1)

10. 33.701 1,189.908 ↓ 1.1 48,722 1

Nested Loop Left Join (cost=142,961.30..177,440.92 rows=44,183 width=402) (actual time=861.488..1,189.908 rows=48,722 loops=1)

11. 24.162 961.319 ↓ 1.1 48,722 1

Merge Left Join (cost=142,960.87..147,100.07 rows=44,183 width=402) (actual time=861.471..961.319 rows=48,722 loops=1)

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

Merge Join (cost=142,960.45..144,020.59 rows=17,282 width=394) (actual time=861.397..884.138 rows=17,282 loops=1)

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

Sort (cost=142,960.16..143,003.36 rows=17,282 width=386) (actual time=861.359..866.080 rows=17,282 loops=1)

  • Sort Key: zonfpview0_.verziaid
  • Sort Method: quicksort Memory: 10284kB
14. 10.658 851.636 ↑ 1.0 17,282 1

Subquery Scan on zonfpview0_ (cost=140,231.59..141,743.77 rows=17,282 width=386) (actual time=806.079..851.636 rows=17,282 loops=1)

15. 32.603 840.978 ↑ 1.0 17,282 1

GroupAggregate (cost=140,231.59..141,570.95 rows=17,282 width=458) (actual time=806.062..840.978 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. 26.110 808.375 ↑ 1.0 17,282 1

Sort (cost=140,231.59..140,274.80 rows=17,282 width=467) (actual time=806.050..808.375 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.549 782.265 ↑ 1.0 17,282 1

Nested Loop Left Join (cost=23,204.52..139,015.20 rows=17,282 width=467) (actual time=363.671..782.265 rows=17,282 loops=1)

18. 10.830 761.716 ↑ 1.0 17,282 1

Nested Loop Left Join (cost=23,204.09..130,623.55 rows=17,282 width=474) (actual time=363.610..761.716 rows=17,282 loops=1)

19. 2.434 750.886 ↑ 1.0 17,282 1

Nested Loop Left Join (cost=23,203.66..122,275.12 rows=17,282 width=476) (actual time=363.609..750.886 rows=17,282 loops=1)

20. 1.581 731.170 ↑ 1.0 17,282 1

Nested Loop Left Join (cost=23,203.23..113,926.68 rows=17,282 width=478) (actual time=363.607..731.170 rows=17,282 loops=1)

21. 16.903 677.743 ↑ 1.0 17,282 1

Nested Loop Left Join (cost=23,202.79..105,578.24 rows=17,282 width=480) (actual time=363.603..677.743 rows=17,282 loops=1)

22. 9.881 626.276 ↑ 1.0 17,282 1

Nested Loop Left Join (cost=23,202.37..85,329.73 rows=17,282 width=456) (actual time=363.600..626.276 rows=17,282 loops=1)

23. 10.717 616.395 ↑ 1.0 17,282 1

Nested Loop Left Join (cost=23,201.93..76,981.29 rows=17,282 width=458) (actual time=363.598..616.395 rows=17,282 loops=1)

24. 14.511 605.678 ↑ 1.0 17,282 1

Hash Left Join (cost=23,201.50..68,632.85 rows=17,282 width=460) (actual time=363.589..605.678 rows=17,282 loops=1)

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

Nested Loop Left Join (cost=18,222.85..63,608.83 rows=17,282 width=459) (actual time=305.962..534.029 rows=17,282 loops=1)

26. 4.339 518.433 ↑ 1.0 17,282 1

Nested Loop Left Join (cost=18,222.41..55,260.39 rows=17,282 width=461) (actual time=305.960..518.433 rows=17,282 loops=1)

27. 4.784 479.530 ↑ 1.0 17,282 1

Nested Loop Left Join (cost=18,221.98..46,911.95 rows=17,282 width=463) (actual time=305.957..479.530 rows=17,282 loops=1)

28. 6.157 440.182 ↑ 1.0 17,282 1

Hash Left Join (cost=18,221.55..26,663.45 rows=17,282 width=439) (actual time=305.951..440.182 rows=17,282 loops=1)

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

Hash Left Join (cost=18,171.13..26,567.66 rows=17,282 width=393) (actual time=305.497..433.582 rows=17,282 loops=1)

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

Hash Left Join (cost=18,160.97..26,511.30 rows=17,282 width=397) (actual time=305.405..425.251 rows=17,282 loops=1)

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

Hash Left Join (cost=18,147.13..26,451.46 rows=17,282 width=377) (actual time=305.277..416.490 rows=17,282 loops=1)

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

Hash Right Join (cost=18,128.50..26,387.10 rows=17,282 width=371) (actual time=305.088..407.467 rows=17,282 loops=1)

  • Hash Cond: (dv.id = zonfpverzia.draftzonfp_id)
33. 65.501 65.501 ↑ 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.501 rows=42,311 loops=1)

34. 16.489 304.894 ↑ 1.0 17,282 1

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

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

Hash Right Join (cost=13,162.31..17,912.48 rows=17,282 width=371) (actual time=203.234..288.405 rows=17,282 loops=1)

  • Hash Cond: (workflowst7_.id = zonfp.workflowstavaktualny_id)
36. 38.768 38.768 ↑ 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.036..38.768 rows=178,789 loops=1)

37. 16.302 203.066 ↑ 1.0 17,282 1

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

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

Hash Left Join (cost=4,805.25..12,946.28 rows=17,282 width=354) (actual time=61.816..186.764 rows=17,282 loops=1)

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

Hash Left Join (cost=2,947.67..11,043.32 rows=17,282 width=295) (actual time=43.339..160.426 rows=17,282 loops=1)

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

Hash Join (cost=2,620.25..10,670.52 rows=17,282 width=287) (actual time=39.752..149.083 rows=17,282 loops=1)

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

Hash Join (cost=2,611.50..10,615.50 rows=17,282 width=258) (actual time=39.477..141.880 rows=17,282 loops=1)

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

Hash Join (cost=2,365.89..10,324.42 rows=17,282 width=258) (actual time=37.302..131.999 rows=17,282 loops=1)

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

Hash Join (cost=726.85..8,447.75 rows=17,282 width=231) (actual time=11.538..94.688 rows=17,282 loops=1)

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

Seq Scan on d_zonfpverzia zonfpverzia (cost=0.00..7,402.15 rows=38,915 width=173) (actual time=0.033..56.459 rows=38,915 loops=1)

45. 4.885 11.367 ↑ 1.0 17,282 1

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

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

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

47. 3.748 25.681 ↑ 1.0 14,643 1

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

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

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

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

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

50. 2.328 5.849 ↑ 1.0 14,643 1

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

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

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

52. 0.268 2.143 ↑ 1.0 1,894 1

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

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

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

54. 0.078 0.212 ↑ 1.0 211 1

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

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

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

56. 1.327 3.470 ↑ 1.0 8,552 1

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

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

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

58. 3.120 18.373 ↑ 1.0 8,559 1

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

  • Buckets: 16384 Batches: 1 Memory Usage: 1057kB
59. 15.253 15.253 ↑ 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.032..15.253 rows=8,559 loops=1)

60. 0.078 0.178 ↑ 1.0 517 1

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

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

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

62. 0.049 0.121 ↑ 1.0 304 1

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

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

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

64. 0.031 0.087 ↑ 1.0 229 1

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

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

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

66. 0.190 0.443 ↑ 1.0 1,219 1

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

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

Seq Scan on d_workflowprechod workflowpr9_ (cost=0.00..35.19 rows=1,219 width=62) (actual time=0.012..0.253 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: (id = zonfpverzia.sumaziadanacelkovaintenzity_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. 23.627 57.138 ↑ 1.0 108,918 1

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

  • Buckets: 131072 Batches: 1 Memory Usage: 6935kB
72. 33.511 33.511 ↑ 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.025..33.511 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. 34.564 34.564 ↓ 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.002..0.002 rows=0 loops=17,282)

  • Index Cond: (id = zonfpverzia.sumaschvalenacelkovaintenzity_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. 6.643 6.643 ↑ 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.032..6.643 rows=38,915 loops=1)

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

Index Scan using zonfpverzia_to_dokument__zonfpverzia_id_idx on zonfpverzia_to_dokument dokumenty5_ (cost=0.42..2,345.72 rows=99,489 width=16) (actual time=0.059..53.019 rows=99,489 loops=1)

82. 194.888 194.888 ↑ 1.0 1 48,722

Index Only Scan using d_dokument_pkey on d_dokument dokument6_ (cost=0.43..0.69 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=48,722)

  • Index Cond: (id = dokumenty5_.dokument_id)
  • Heap Fetches: 0
83. 0.029 0.055 ↑ 1.0 261 1

Hash (cost=6.26..6.26 rows=261 width=8) (actual time=0.055..0.055 rows=261 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
84. 0.026 0.026 ↑ 1.0 261 1

Index Only Scan using d_specifickyciel_pkey on d_specifickyciel specificky3_ (cost=0.15..6.26 rows=261 width=8) (actual time=0.011..0.026 rows=261 loops=1)

  • Heap Fetches: 0
85. 0.037 0.355 ↓ 10.0 260 1

Hash (cost=9.29..9.29 rows=26 width=16) (actual time=0.355..0.355 rows=260 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
86. 0.172 0.318 ↓ 10.0 260 1

Nested Loop (cost=0.86..9.29 rows=26 width=16) (actual time=0.097..0.318 rows=260 loops=1)

87. 0.022 0.146 ↓ 10.0 260 1

Nested Loop (cost=0.71..4.99 rows=26 width=8) (actual time=0.093..0.146 rows=260 loops=1)

  • Join Filter: (zaradeniez10_.organ_id = vizibilita12_.organ_id)
88. 0.002 0.077 ↑ 1.0 1 1

Nested Loop (cost=0.43..3.77 rows=1 width=16) (actual time=0.076..0.077 rows=1 loops=1)

89. 0.068 0.068 ↑ 1.0 1 1

Index Scan using d_zaradeniezamestnanecorganu_osobasubjektorgan_unique_idx on d_zaradeniezamestnanecorganu zaradeniez10_ (cost=0.28..2.50 rows=1 width=8) (actual time=0.067..0.068 rows=1 loops=1)

  • Index Cond: (osoba_id = 1088)
  • Filter: (dateinvalidate IS NULL)
  • Rows Removed by Filter: 1
90. 0.007 0.007 ↑ 1.0 1 1

Index Only Scan using d_organimplementaciefondov_pkey on d_organimplementaciefondov organimple11_ (cost=0.14..1.26 rows=1 width=8) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: (id = zaradeniez10_.organ_id)
  • Heap Fetches: 0
91. 0.047 0.047 ↓ 9.6 260 1

Index Only Scan using d_vizibilitaps_organ_id_specifickyciel_id_key on d_vizibilitaps vizibilita12_ (cost=0.28..0.88 rows=27 width=16) (actual time=0.016..0.047 rows=260 loops=1)

  • Index Cond: (organ_id = organimple11_.id)
  • Heap Fetches: 0
92. 0.000 0.000 ↑ 1.0 1 260

Index Only Scan using d_specifickyciel_pkey on d_specifickyciel specificky13_ (cost=0.15..0.17 rows=1 width=8) (actual time=0.000..0.000 rows=1 loops=260)

  • Index Cond: (id = vizibilita12_.specifickyciel_id)
  • Heap Fetches: 0
93. 1,424.552 6,643.428 ↑ 1.2 50 50,329

Nested Loop Left Join (cost=1.29..49.85 rows=62 width=16) (actual time=0.009..0.132 rows=50 loops=50,329)

94. 195.339 2,717.766 ↑ 1.2 50 50,329

Nested Loop Left Join (cost=0.85..21.11 rows=62 width=16) (actual time=0.007..0.054 rows=50 loops=50,329)

95. 553.619 553.619 ↑ 1.4 20 50,329

Index Scan using d_podmienkapomocidokument__zonfpverzia_id_idx on d_podmienkapomocidokumentzonfp podmienkyp7_ (cost=0.42..1.14 rows=27 width=16) (actual time=0.004..0.011 rows=20 loops=50,329)

  • Index Cond: (zonfpverzia_id = zonfpverzi1_.id)
96. 1,968.808 1,968.808 ↑ 3.7 3 984,404

Index Only Scan using podmienkapomocidokumentzonfp_to_dokument__dokument_id_idx on podmienkapomocidokumentzonfp_to_dokument dokumenty8_ (cost=0.43..0.63 rows=11 width=16) (actual time=0.001..0.002 rows=3 loops=984,404)

  • Index Cond: (podmienkapomocidokumentzonfp_id = podmienkyp7_.id)
  • Heap Fetches: 0
97. 2,501.110 2,501.110 ↑ 1.0 1 2,501,110

Index Only Scan using d_dokument_pkey on d_dokument dokument9_ (cost=0.43..0.46 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=2,501,110)

  • Index Cond: (id = dokumenty8_.dokument_id)
  • Heap Fetches: 0
98.          

SubPlan (for Nested Loop Left Join)

99. 5,432.737 5,432.737 ↑ 1.6 235,017 1

Index Scan using dokument_nazov_u_lower_like_idx on d_dokument (cost=0.41..218,206.91 rows=367,057 width=8) (actual time=0.743..5,432.737 rows=235,017 loops=1)

  • Index Cond: (f_unaccent(lower(nazov)) ~~ '%vypis%'::text)
100. 5,325.931 5,325.931 ↑ 1.6 235,017 1

Index Scan using dokument_nazov_u_lower_like_idx on d_dokument d_dokument_1 (cost=0.41..218,206.91 rows=367,057 width=8) (actual time=0.683..5,325.931 rows=235,017 loops=1)

  • Index Cond: (f_unaccent(lower(nazov)) ~~ '%vypis%'::text)
Planning time : 25.237 ms
Execution time : 19,681.380 ms