explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VW30

Settings
# exclusive inclusive rows x rows loops node
1. 40.926 59,288.279 ↑ 1.0 1 1

Aggregate (cost=491,287.59..491,287.60 rows=1 width=8) (actual time=59,288.279..59,288.279 rows=1 loops=1)

2. 48,767.829 59,247.353 ↓ 3.3 103,832 1

Hash Left Join (cost=219,538.49..491,209.05 rows=31,417 width=8) (actual time=3,678.302..59,247.353 rows=103,832 loops=1)

  • Hash Cond: (dokument10_.typdokument_id = typdokumen11_.id)
  • Filter: ((f_unaccent(lower((typdokumen7_.nazov)::text)) ~~ 'vypis%'::text) OR (f_unaccent(lower((typdokumen11_.nazov)::text)) ~~ 'vypis%'::text))
  • Rows Removed by Filter: 2399655
3. 5,524.290 10,479.247 ↓ 5.0 2,503,487 1

Hash Right Join (cost=219,501.98..489,497.99 rows=502,132 width=121) (actual time=3,677.880..10,479.247 rows=2,503,487 loops=1)

  • Hash Cond: (dokument10_.id = dokumenty9_.dokument_id)
4. 1,282.656 1,282.656 ↓ 1.0 7,807,125 1

Index Only Scan using dokument_typdokument_id_id_idx on d_dokument dokument10_ (cost=0.43..150,156.45 rows=7,805,781 width=16) (actual time=0.068..1,282.656 rows=7,807,125 loops=1)

  • Heap Fetches: 0
5. 618.670 3,672.301 ↓ 5.0 2,503,487 1

Hash (cost=203,907.89..203,907.89 rows=502,132 width=121) (actual time=3,672.301..3,672.301 rows=2,503,487 loops=1)

  • Buckets: 131072 (originally 131072) Batches: 16 (originally 8) Memory Usage: 20087kB
6. 1,124.417 3,053.631 ↓ 5.0 2,503,487 1

Hash Right Join (cost=144,528.65..203,907.89 rows=502,132 width=121) (actual time=1,773.111..3,053.631 rows=2,503,487 loops=1)

  • Hash Cond: (dokumenty9_.podmienkapomocidokumentzonfp_id = podmienkyp8_.id)
7. 157.437 157.437 ↑ 1.0 1,739,340 1

Seq Scan on podmienkapomocidokumentzonfp_to_dokument dokumenty9_ (cost=0.00..26,795.40 rows=1,739,340 width=16) (actual time=0.022..157.437 rows=1,739,340 loops=1)

8. 279.578 1,771.777 ↓ 4.5 986,781 1

Hash (cost=137,743.74..137,743.74 rows=218,473 width=121) (actual time=1,771.777..1,771.777 rows=986,781 loops=1)

  • Buckets: 131072 (originally 131072) Batches: 8 (originally 2) Memory Usage: 19511kB
9. 170.145 1,492.199 ↓ 4.5 986,781 1

Hash Semi Join (cost=107,312.37..137,743.74 rows=218,473 width=121) (actual time=995.702..1,492.199 rows=986,781 loops=1)

  • Hash Cond: (specificke2_.specifickyciel_id = vizibilita14_.specifickyciel_id)
10. 241.815 1,296.953 ↓ 1.1 986,781 1

Hash Right Join (cost=107,302.75..132,975.88 rows=886,753 width=137) (actual time=970.595..1,296.953 rows=986,781 loops=1)

  • Hash Cond: (podmienkyp8_.zonfpverzia_id = zonfpverzi1_.id)
11. 84.780 84.780 ↑ 1.0 756,771 1

Seq Scan on d_podmienkapomocidokumentzonfp podmienkyp8_ (cost=0.00..13,967.71 rows=756,771 width=16) (actual time=0.020..84.780 rows=756,771 loops=1)

12. 18.083 970.358 ↓ 1.1 50,329 1

Hash (cost=106,732.76..106,732.76 rows=45,599 width=137) (actual time=970.358..970.358 rows=50,329 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 6171kB
13. 19.079 952.275 ↓ 1.1 50,329 1

Hash Join (cost=34,769.39..106,732.76 rows=45,599 width=137) (actual time=406.989..952.275 rows=50,329 loops=1)

  • Hash Cond: (zonfpverzia.id = specificke2_.zonfpverzia_id)
14. 14.228 919.626 ↓ 1.1 48,722 1

Hash Left Join (cost=33,531.08..104,648.26 rows=44,183 width=129) (actual time=393.183..919.626 rows=48,722 loops=1)

  • Hash Cond: (dokument6_.typdokument_id = typdokumen7_.id)
15. 38.015 905.016 ↓ 1.1 48,722 1

Nested Loop Left Join (cost=33,494.57..104,495.10 rows=44,183 width=32) (actual time=392.791..905.016 rows=48,722 loops=1)

16. 25.018 428.503 ↓ 1.1 48,722 1

Hash Right Join (cost=33,494.13..35,841.94 rows=44,183 width=32) (actual time=392.735..428.503 rows=48,722 loops=1)

  • Hash Cond: (dokumenty5_.zonfpverzia_id = zonfpverzi1_.id)
17. 10.885 10.885 ↑ 1.0 99,489 1

Seq Scan on zonfpverzia_to_dokument dokumenty5_ (cost=0.00..1,532.89 rows=99,489 width=16) (actual time=0.024..10.885 rows=99,489 loops=1)

18. 3.133 392.600 ↑ 1.0 17,282 1

Hash (cost=33,278.11..33,278.11 rows=17,282 width=24) (actual time=392.600..392.600 rows=17,282 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1202kB
19. 5.290 389.467 ↑ 1.0 17,282 1

Hash Join (cost=32,843.90..33,278.11 rows=17,282 width=24) (actual time=376.891..389.467 rows=17,282 loops=1)

  • Hash Cond: (zonfpverzia.id = zonfpverzi1_.id)
20. 24.617 376.335 ↑ 1.0 17,282 1

HashAggregate (cost=31,653.55..31,869.57 rows=17,282 width=632) (actual time=368.853..376.335 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
21. 29.301 351.718 ↑ 1.0 17,282 1

Hash Right Join (cost=26,879.47..31,091.88 rows=17,282 width=320) (actual time=300.347..351.718 rows=17,282 loops=1)

  • Hash Cond: (odoslanie.id = dv.odoslanie_id)
22. 22.230 22.230 ↑ 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.023..22.230 rows=108,918 loops=1)

23. 10.785 300.187 ↑ 1.0 17,282 1

Hash (cost=26,663.45..26,663.45 rows=17,282 width=324) (actual time=300.187..300.187 rows=17,282 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 5313kB
24. 3.533 289.402 ↑ 1.0 17,282 1

Hash Left Join (cost=18,221.55..26,663.45 rows=17,282 width=324) (actual time=198.983..289.402 rows=17,282 loops=1)

  • Hash Cond: (workflowst7_.workflowprechod_id = workflowpr9_.id)
25. 4.403 285.474 ↑ 1.0 17,282 1

Hash Left Join (cost=18,171.13..26,567.66 rows=17,282 width=278) (actual time=198.580..285.474 rows=17,282 loops=1)

  • Hash Cond: (stav.faza_id = faza.id)
26. 4.471 280.992 ↑ 1.0 17,282 1

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

  • Hash Cond: (workflowst8_.stav_id = stav.id)
27. 4.693 276.409 ↑ 1.0 17,282 1

Hash Left Join (cost=18,147.13..26,451.46 rows=17,282 width=262) (actual time=198.376..276.409 rows=17,282 loops=1)

  • Hash Cond: (workflowst7_.workflowstav_id = workflowst8_.id)
28. 23.065 271.532 ↑ 1.0 17,282 1

Hash Right Join (cost=18,128.50..26,387.10 rows=17,282 width=256) (actual time=198.183..271.532 rows=17,282 loops=1)

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

30. 9.504 198.031 ↑ 1.0 17,282 1

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

  • Buckets: 32768 Batches: 1 Memory Usage: 4962kB
31. 31.724 188.527 ↑ 1.0 17,282 1

Hash Right Join (cost=13,162.31..17,912.48 rows=17,282 width=256) (actual time=134.009..188.527 rows=17,282 loops=1)

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

33. 8.899 133.869 ↑ 1.0 17,282 1

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

  • Buckets: 32768 Batches: 1 Memory Usage: 4820kB
34. 5.737 124.970 ↑ 1.0 17,282 1

Hash Left Join (cost=4,805.25..12,946.28 rows=17,282 width=247) (actual time=40.731..124.970 rows=17,282 loops=1)

  • Hash Cond: (projekt.aktualnaverzia_id = projektverzia.id)
35. 5.404 108.034 ↑ 1.0 17,282 1

Hash Left Join (cost=2,947.67..11,043.32 rows=17,282 width=188) (actual time=29.471..108.034 rows=17,282 loops=1)

  • Hash Cond: (zonfp.projekt_id = projekt.id)
36. 4.147 99.699 ↑ 1.0 17,282 1

Hash Join (cost=2,620.25..10,670.52 rows=17,282 width=180) (actual time=26.484..99.699 rows=17,282 loops=1)

  • Hash Cond: (vyzvaverzia.vyhlasovatel_id = oif.id)
37. 4.564 95.469 ↑ 1.0 17,282 1

Hash Join (cost=2,611.50..10,615.50 rows=17,282 width=151) (actual time=26.396..95.469 rows=17,282 loops=1)

  • Hash Cond: (zonfpverzia.vyzvaverzia_id = vyzvaverzia.id)
38. 8.169 89.463 ↑ 1.0 17,282 1

Hash Join (cost=2,365.89..10,324.42 rows=17,282 width=151) (actual time=24.947..89.463 rows=17,282 loops=1)

  • Hash Cond: (zonfpverzia.ziadatel_id = subjekt.id)
39. 15.168 62.473 ↑ 1.0 17,282 1

Hash Join (cost=726.85..8,447.75 rows=17,282 width=124) (actual time=6.072..62.473 rows=17,282 loops=1)

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

Seq Scan on d_zonfpverzia zonfpverzia (cost=0.00..7,402.15 rows=38,915 width=116) (actual time=0.016..41.446 rows=38,915 loops=1)

41. 2.266 5.859 ↑ 1.0 17,282 1

Hash (cost=510.82..510.82 rows=17,282 width=40) (actual time=5.858..5.859 rows=17,282 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1276kB
42. 3.593 3.593 ↑ 1.0 17,282 1

Seq Scan on d_zonfp zonfp (cost=0.00..510.82 rows=17,282 width=40) (actual time=0.016..3.593 rows=17,282 loops=1)

43. 3.030 18.821 ↑ 1.0 14,643 1

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

  • Buckets: 16384 Batches: 1 Memory Usage: 1194kB
44. 7.278 15.791 ↑ 1.0 14,643 1

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

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

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

46. 1.628 3.880 ↑ 1.0 14,643 1

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

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

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

48. 0.218 1.442 ↑ 1.0 1,894 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 105kB
49. 1.224 1.224 ↑ 1.0 1,894 1

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

50. 0.035 0.083 ↑ 1.0 211 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 25kB
51. 0.048 0.048 ↑ 1.0 211 1

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

52. 1.180 2.931 ↑ 1.0 8,552 1

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

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

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

54. 1.670 11.199 ↑ 1.0 8,559 1

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

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

56. 0.073 0.184 ↑ 1.0 517 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 37kB
57. 0.111 0.111 ↑ 1.0 517 1

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

58. 0.044 0.112 ↑ 1.0 304 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 30kB
59. 0.068 0.068 ↑ 1.0 304 1

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

60. 0.028 0.079 ↑ 1.0 229 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
61. 0.051 0.051 ↑ 1.0 229 1

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

62. 0.170 0.395 ↑ 1.0 1,219 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 133kB
63. 0.225 0.225 ↑ 1.0 1,219 1

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

64. 4.293 7.842 ↑ 1.0 38,915 1

Hash (cost=703.91..703.91 rows=38,915 width=8) (actual time=7.841..7.842 rows=38,915 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2033kB
65. 3.549 3.549 ↑ 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.534..3.549 rows=38,915 loops=1)

  • Heap Fetches: 0
66. 438.498 438.498 ↑ 1.0 1 48,722

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

  • Index Cond: (dokumenty5_.dokument_id = id)
67. 0.175 0.382 ↑ 1.0 734 1

Hash (cost=27.34..27.34 rows=734 width=113) (actual time=0.382..0.382 rows=734 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 113kB
68. 0.207 0.207 ↑ 1.0 734 1

Seq Scan on d_typdokument typdokumen7_ (cost=0.00..27.34 rows=734 width=113) (actual time=0.015..0.207 rows=734 loops=1)

69. 4.982 13.570 ↑ 1.0 40,162 1

Hash (cost=736.28..736.28 rows=40,162 width=24) (actual time=13.570..13.570 rows=40,162 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2709kB
70. 5.933 8.588 ↑ 1.0 40,162 1

Hash Join (cost=9.53..736.28 rows=40,162 width=24) (actual time=0.079..8.588 rows=40,162 loops=1)

  • Hash Cond: (specificke2_.specifickyciel_id = specificky3_.id)
71. 2.603 2.603 ↑ 1.0 40,162 1

Seq Scan on zonfpverzia_to_specifickyciel specificke2_ (cost=0.00..619.62 rows=40,162 width=16) (actual time=0.018..2.603 rows=40,162 loops=1)

72. 0.026 0.052 ↑ 1.0 261 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
73. 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
74. 0.039 25.101 ↓ 10.0 260 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
75. 0.000 25.062 ↓ 10.0 260 1

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

76. 0.026 24.341 ↓ 10.0 260 1

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

  • Join Filter: (zaradeniez12_.organ_id = vizibilita14_.organ_id)
77. 0.003 23.898 ↑ 1.0 1 1

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

78. 0.048 0.048 ↑ 1.0 1 1

Index Scan using d_zaradeniezamestnanecorganu_osoba_id_idx on d_zaradeniezamestnanecorganu zaradeniez12_ (cost=0.28..2.50 rows=1 width=8) (actual time=0.047..0.048 rows=1 loops=1)

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

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

  • Index Cond: (id = zaradeniez12_.organ_id)
  • Heap Fetches: 0
80. 0.417 0.417 ↓ 9.6 260 1

Index Only Scan using d_vizibilitaps_organ_id_specifickyciel_id_key on d_vizibilitaps vizibilita14_ (cost=0.28..0.88 rows=27 width=16) (actual time=0.375..0.417 rows=260 loops=1)

  • Index Cond: (organ_id = organimple13_.id)
  • Heap Fetches: 0
81. 0.780 0.780 ↑ 1.0 1 260

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

  • Index Cond: (id = vizibilita14_.specifickyciel_id)
  • Heap Fetches: 0
82. 0.157 0.277 ↑ 1.0 734 1

Hash (cost=27.34..27.34 rows=734 width=113) (actual time=0.277..0.277 rows=734 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 113kB
83. 0.120 0.120 ↑ 1.0 734 1

Seq Scan on d_typdokument typdokumen11_ (cost=0.00..27.34 rows=734 width=113) (actual time=0.011..0.120 rows=734 loops=1)

Planning time : 15.102 ms
Execution time : 59,299.886 ms