explain.depesz.com

PostgreSQL's explain analyze made readable

Result: I9gK

Settings
# exclusive inclusive rows x rows loops node
1. 0.029 52,522.854 ↑ 1.0 1 1

Aggregate (cost=382,824.58..382,824.59 rows=1 width=8) (actual time=52,522.854..52,522.854 rows=1 loops=1)

2. 39,402.666 52,522.825 ↓ 0.0 0 1

Hash Left Join (cost=118,191.74..382,822.87 rows=684 width=8) (actual time=52,522.824..52,522.825 rows=0 loops=1)

  • Hash Cond: (dokument10_.typdokument_id = typdokumen11_.id)
  • Filter: (f_unaccent(lower((typdokumen11_.nazov)::text)) ~~ 'vypis'::text)
  • Rows Removed by Filter: 2503487
3. 6,692.624 13,119.707 ↓ 5.0 2,503,487 1

Hash Right Join (cost=118,155.22..381,286.23 rows=502,132 width=16) (actual time=4,607.375..13,119.707 rows=2,503,487 loops=1)

  • Hash Cond: (dokument10_.id = dokumenty9_.dokument_id)
4. 1,829.540 1,829.540 ↓ 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.076..1,829.540 rows=7,807,125 loops=1)

  • Heap Fetches: 0
5. 760.947 4,597.543 ↓ 5.0 2,503,487 1

Hash (cost=109,426.14..109,426.14 rows=502,132 width=16) (actual time=4,597.543..4,597.543 rows=2,503,487 loops=1)

  • Buckets: 524288 (originally 524288) Batches: 8 (originally 2) Memory Usage: 20024kB
6. 1,610.094 3,836.596 ↓ 5.0 2,503,487 1

Hash Right Join (cost=71,086.89..109,426.14 rows=502,132 width=16) (actual time=1,969.751..3,836.596 rows=2,503,487 loops=1)

  • Hash Cond: (dokumenty9_.podmienkapomocidokumentzonfp_id = podmienkyp8_.id)
7. 258.385 258.385 ↑ 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.023..258.385 rows=1,739,340 loops=1)

8. 342.413 1,968.117 ↓ 4.5 986,781 1

Hash (cost=68,355.98..68,355.98 rows=218,473 width=16) (actual time=1,968.117..1,968.117 rows=986,781 loops=1)

  • Buckets: 524288 (originally 262144) Batches: 4 (originally 1) Memory Usage: 16439kB
9. 318.710 1,625.704 ↓ 4.5 986,781 1

Hash Semi Join (cost=37,924.61..68,355.98 rows=218,473 width=16) (actual time=740.066..1,625.704 rows=986,781 loops=1)

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

Hash Right Join (cost=37,914.99..63,588.13 rows=886,753 width=32) (actual time=739.640..1,306.578 rows=986,781 loops=1)

  • Hash Cond: (podmienkyp8_.zonfpverzia_id = zonfpverzi1_.id)
11. 145.413 145.413 ↑ 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.037..145.413 rows=756,771 loops=1)

12. 15.728 739.336 ↓ 1.1 50,329 1

Hash (cost=37,345.01..37,345.01 rows=45,599 width=32) (actual time=739.336..739.336 rows=50,329 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 3658kB
13. 45.020 723.608 ↓ 1.1 50,329 1

Hash Right Join (cost=34,983.04..37,345.01 rows=45,599 width=32) (actual time=662.080..723.608 rows=50,329 loops=1)

  • Hash Cond: (dokumenty5_.zonfpverzia_id = zonfpverzi1_.id)
14. 16.735 16.735 ↑ 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.020..16.735 rows=99,489 loops=1)

15. 5.203 661.853 ↓ 1.0 17,856 1

Hash (cost=34,760.09..34,760.09 rows=17,836 width=32) (actual time=661.853..661.853 rows=17,856 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1372kB
16. 5.123 656.650 ↓ 1.0 17,856 1

Hash Join (cost=34,080.50..34,760.09 rows=17,836 width=32) (actual time=631.280..656.650 rows=17,856 loops=1)

  • Hash Cond: (specificke2_.specifickyciel_id = specificky3_.id)
17. 9.143 651.462 ↓ 1.0 17,856 1

Hash Join (cost=34,070.98..34,702.99 rows=17,836 width=24) (actual time=631.209..651.462 rows=17,856 loops=1)

  • Hash Cond: (zonfpverzia.id = zonfpverzi1_.id)
18. 35.553 588.036 ↑ 1.0 17,282 1

HashAggregate (cost=31,653.55..31,869.57 rows=17,282 width=632) (actual time=576.672..588.036 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
19. 40.341 552.483 ↑ 1.0 17,282 1

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

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

21. 16.085 481.262 ↑ 1.0 17,282 1

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

  • Buckets: 32768 Batches: 1 Memory Usage: 5313kB
22. 5.859 465.177 ↑ 1.0 17,282 1

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

  • Hash Cond: (workflowst7_.workflowprechod_id = workflowpr9_.id)
23. 7.526 458.394 ↑ 1.0 17,282 1

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

  • Hash Cond: (stav.faza_id = faza.id)
24. 7.281 450.675 ↑ 1.0 17,282 1

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

  • Hash Cond: (workflowst8_.stav_id = stav.id)
25. 7.704 443.086 ↑ 1.0 17,282 1

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

  • Hash Cond: (workflowst7_.workflowstav_id = workflowst8_.id)
26. 33.816 435.033 ↑ 1.0 17,282 1

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

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

28. 13.960 329.293 ↑ 1.0 17,282 1

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

  • Buckets: 32768 Batches: 1 Memory Usage: 4962kB
29. 46.865 315.333 ↑ 1.0 17,282 1

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

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

31. 15.576 233.684 ↑ 1.0 17,282 1

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

  • Buckets: 32768 Batches: 1 Memory Usage: 4820kB
32. 9.277 218.108 ↑ 1.0 17,282 1

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

  • Hash Cond: (projekt.aktualnaverzia_id = projektverzia.id)
33. 8.472 186.842 ↑ 1.0 17,282 1

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

  • Hash Cond: (zonfp.projekt_id = projekt.id)
34. 7.046 172.076 ↑ 1.0 17,282 1

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

  • Hash Cond: (vyzvaverzia.vyhlasovatel_id = oif.id)
35. 8.325 164.849 ↑ 1.0 17,282 1

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

  • Hash Cond: (zonfpverzia.vyzvaverzia_id = vyzvaverzia.id)
36. 12.331 153.659 ↑ 1.0 17,282 1

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

  • Hash Cond: (zonfpverzia.ziadatel_id = subjekt.id)
37. 24.611 108.904 ↑ 1.0 17,282 1

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

  • Hash Cond: (zonfpverzia.id = zonfp.verziazonfpaktualna_id)
38. 72.806 72.806 ↑ 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.027..72.806 rows=38,915 loops=1)

39. 4.412 11.487 ↑ 1.0 17,282 1

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

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

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

41. 4.587 32.424 ↑ 1.0 14,643 1

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

  • Buckets: 16384 Batches: 1 Memory Usage: 1194kB
42. 10.903 27.837 ↑ 1.0 14,643 1

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

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

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

44. 3.960 9.222 ↑ 1.0 14,643 1

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

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

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

46. 0.449 2.865 ↑ 1.0 1,894 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 105kB
47. 2.416 2.416 ↑ 1.0 1,894 1

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

48. 0.077 0.181 ↑ 1.0 211 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 25kB
49. 0.104 0.104 ↑ 1.0 211 1

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

50. 2.591 6.294 ↑ 1.0 8,552 1

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

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

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

52. 3.506 21.989 ↑ 1.0 8,559 1

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

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

54. 0.152 0.349 ↑ 1.0 517 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 37kB
55. 0.197 0.197 ↑ 1.0 517 1

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

56. 0.103 0.308 ↑ 1.0 304 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 30kB
57. 0.205 0.205 ↑ 1.0 304 1

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

58. 0.105 0.193 ↑ 1.0 229 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
59. 0.088 0.088 ↑ 1.0 229 1

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

60. 0.378 0.924 ↑ 1.0 1,219 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 133kB
61. 0.546 0.546 ↑ 1.0 1,219 1

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

62. 13.925 54.283 ↑ 1.0 40,162 1

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

  • Buckets: 65536 Batches: 1 Memory Usage: 2709kB
63. 21.351 40.358 ↑ 1.0 40,162 1

Hash Join (cost=1,190.35..1,915.41 rows=40,162 width=24) (actual time=12.853..40.358 rows=40,162 loops=1)

  • Hash Cond: (specificke2_.zonfpverzia_id = zonfpverzi1_.id)
64. 6.429 6.429 ↑ 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.014..6.429 rows=40,162 loops=1)

65. 7.044 12.578 ↑ 1.0 38,915 1

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

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

  • Heap Fetches: 0
67. 0.035 0.065 ↑ 1.0 261 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
68. 0.030 0.030 ↑ 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.030 rows=261 loops=1)

  • Heap Fetches: 0
69. 0.040 0.416 ↓ 10.0 260 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
70. 0.000 0.376 ↓ 10.0 260 1

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

71. 0.024 0.182 ↓ 10.0 260 1

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

  • Join Filter: (zaradeniez12_.organ_id = vizibilita14_.organ_id)
72. 0.004 0.080 ↑ 1.0 1 1

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

73. 0.068 0.068 ↑ 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.068..0.068 rows=1 loops=1)

  • Index Cond: (osoba_id = 1088)
  • Filter: (dateinvalidate IS NULL)
  • Rows Removed by Filter: 1
74. 0.008 0.008 ↑ 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=0.008..0.008 rows=1 loops=1)

  • Index Cond: (id = zaradeniez12_.organ_id)
  • Heap Fetches: 0
75. 0.078 0.078 ↓ 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.044..0.078 rows=260 loops=1)

  • Index Cond: (organ_id = organimple13_.id)
  • Heap Fetches: 0
76. 0.260 0.260 ↑ 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.001..0.001 rows=1 loops=260)

  • Index Cond: (id = vizibilita14_.specifickyciel_id)
  • Heap Fetches: 0
77. 0.204 0.452 ↑ 1.0 734 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 113kB
78. 0.248 0.248 ↑ 1.0 734 1

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

Planning time : 19.269 ms
Execution time : 52,534.960 ms