explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RDmH

Settings
# exclusive inclusive rows x rows loops node
1. 56.598 74,247.896 ↑ 1.0 1 1

Aggregate (cost=731,601.87..731,601.88 rows=1 width=8) (actual time=74,247.896..74,247.896 rows=1 loops=1)

2. 54,861.883 74,191.298 ↓ 7.4 100,725 1

Hash Left Join (cost=536,815.86..731,567.68 rows=13,675 width=8) (actual time=14,571.185..74,191.298 rows=100,725 loops=1)

  • Hash Cond: (dokumenty8_.dokument_id = dokument9_.id)
  • Filter: ((f_unaccent(lower(dokument6_.nazov)) ~~ '%vypis%'::text) OR (f_unaccent(lower(dokument9_.nazov)) ~~ '%vypis%'::text))
  • Rows Removed by Filter: 2402762
3. 1,097.214 12,081.496 ↓ 5.0 2,503,487 1

Hash Semi Join (cost=107,327.42..222,310.86 rows=503,386 width=53) (actual time=7,290.642..12,081.496 rows=2,503,487 loops=1)

  • Hash Cond: (specificke2_.specifickyciel_id = vizibilita12_.specifickyciel_id)
4. 1,368.445 10,983.097 ↓ 1.2 2,503,487 1

Hash Right Join (cost=107,317.80..211,351.10 rows=2,038,087 width=69) (actual time=7,289.450..10,983.097 rows=2,503,487 loops=1)

  • Hash Cond: (podmienkyp7_.zonfpverzia_id = zonfpverzi1_.id)
5. 924.305 2,325.813 ↓ 1.0 1,768,194 1

Merge Left Join (cost=2.81..77,132.71 rows=1,739,340 width=16) (actual time=0.376..2,325.813 rows=1,768,194 loops=1)

  • Merge Cond: (podmienkyp7_.id = dokumenty8_.podmienkapomocidokumentzonfp_id)
6. 543.811 543.811 ↑ 1.0 756,771 1

Index Scan using d_podmienkapomocidokument_pkey on d_podmienkapomocidokumentzonfp podmienkyp7_ (cost=0.42..20,038.50 rows=756,771 width=16) (actual time=0.026..543.811 rows=756,771 loops=1)

7. 857.697 857.697 ↑ 1.0 1,739,340 1

Index Only Scan using podmienkapomocidokumentzonfp_to_dokument__dokument_id_idx on podmienkapomocidokumentzonfp_to_dokument dokumenty8_ (cost=0.43..33,460.53 rows=1,739,340 width=16) (actual time=0.346..857.697 rows=1,739,340 loops=1)

  • Heap Fetches: 0
8. 32.437 7,288.839 ↓ 1.1 50,329 1

Hash (cost=106,745.01..106,745.01 rows=45,599 width=69) (actual time=7,288.839..7,288.839 rows=50,329 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 6174kB
9. 44.294 7,256.402 ↓ 1.1 50,329 1

Hash Join (cost=34,732.73..106,745.01 rows=45,599 width=69) (actual time=459.946..7,256.402 rows=50,329 loops=1)

  • Hash Cond: (zonfpverzia.id = specificke2_.zonfpverzia_id)
10. 72.819 7,195.960 ↓ 1.1 48,722 1

Nested Loop Left Join (cost=33,494.43..104,494.96 rows=44,183 width=61) (actual time=443.591..7,195.960 rows=48,722 loops=1)

11. 34.643 496.949 ↓ 1.1 48,722 1

Hash Right Join (cost=33,493.99..35,841.80 rows=44,183 width=24) (actual time=442.739..496.949 rows=48,722 loops=1)

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

13. 2.994 442.599 ↑ 1.0 17,282 1

Hash (cost=33,277.97..33,277.97 rows=17,282 width=16) (actual time=442.599..442.599 rows=17,282 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1067kB
14. 5.776 439.605 ↑ 1.0 17,282 1

Hash Join (cost=32,843.76..33,277.97 rows=17,282 width=16) (actual time=425.464..439.605 rows=17,282 loops=1)

  • Hash Cond: (zonfpverzia.id = zonfpverzi1_.id)
15. 26.491 423.188 ↑ 1.0 17,282 1

HashAggregate (cost=31,653.41..31,869.43 rows=17,282 width=632) (actual time=414.567..423.188 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. 30.303 396.697 ↑ 1.0 17,282 1

Hash Right Join (cost=26,879.47..31,091.74 rows=17,282 width=320) (actual time=337.940..396.697 rows=17,282 loops=1)

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

18. 10.888 337.559 ↑ 1.0 17,282 1

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

  • Buckets: 32768 Batches: 1 Memory Usage: 5313kB
19. 3.728 326.671 ↑ 1.0 17,282 1

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

  • Hash Cond: (workflowst7_.workflowprechod_id = workflowpr9_.id)
20. 4.663 322.506 ↑ 1.0 17,282 1

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

  • Hash Cond: (stav.faza_id = faza.id)
21. 4.586 317.747 ↑ 1.0 17,282 1

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

  • Hash Cond: (workflowst8_.stav_id = stav.id)
22. 4.876 313.042 ↑ 1.0 17,282 1

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

  • Hash Cond: (workflowst7_.workflowstav_id = workflowst8_.id)
23. 23.104 307.951 ↑ 1.0 17,282 1

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

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

25. 8.653 226.808 ↑ 1.0 17,282 1

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

  • Buckets: 32768 Batches: 1 Memory Usage: 4962kB
26. 30.077 218.155 ↑ 1.0 17,282 1

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

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

28. 11.508 163.998 ↑ 1.0 17,282 1

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

  • Buckets: 32768 Batches: 1 Memory Usage: 4820kB
29. 6.144 152.490 ↑ 1.0 17,282 1

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

  • Hash Cond: (projekt.aktualnaverzia_id = projektverzia.id)
30. 5.827 131.905 ↑ 1.0 17,282 1

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

  • Hash Cond: (zonfp.projekt_id = projekt.id)
31. 4.509 123.411 ↑ 1.0 17,282 1

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

  • Hash Cond: (vyzvaverzia.vyhlasovatel_id = oif.id)
32. 5.307 118.815 ↑ 1.0 17,282 1

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

  • Hash Cond: (zonfpverzia.vyzvaverzia_id = vyzvaverzia.id)
33. 9.263 111.600 ↑ 1.0 17,282 1

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

  • Hash Cond: (zonfpverzia.ziadatel_id = subjekt.id)
34. 16.897 82.740 ↑ 1.0 17,282 1

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

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

36. 2.934 8.358 ↑ 1.0 17,282 1

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

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

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

38. 2.728 19.597 ↑ 1.0 14,643 1

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

  • Buckets: 16384 Batches: 1 Memory Usage: 1194kB
39. 5.841 16.869 ↑ 1.0 14,643 1

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

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

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

41. 2.014 5.194 ↑ 1.0 14,643 1

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

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

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

43. 0.227 1.908 ↑ 1.0 1,894 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 105kB
44. 1.681 1.681 ↑ 1.0 1,894 1

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

45. 0.034 0.087 ↑ 1.0 211 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 25kB
46. 0.053 0.053 ↑ 1.0 211 1

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

47. 0.944 2.667 ↑ 1.0 8,552 1

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

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

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

49. 1.926 14.441 ↑ 1.0 8,559 1

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

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

51. 0.118 0.215 ↑ 1.0 517 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 37kB
52. 0.097 0.097 ↑ 1.0 517 1

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

53. 0.046 0.119 ↑ 1.0 304 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 30kB
54. 0.073 0.073 ↑ 1.0 304 1

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

55. 0.027 0.096 ↑ 1.0 229 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
56. 0.069 0.069 ↑ 1.0 229 1

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

57. 0.173 0.437 ↑ 1.0 1,219 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 133kB
58. 0.264 0.264 ↑ 1.0 1,219 1

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

59. 5.523 10.641 ↑ 1.0 38,915 1

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

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

  • Heap Fetches: 0
61. 6,626.192 6,626.192 ↑ 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.136..0.136 rows=1 loops=48,722)

  • Index Cond: (dokumenty5_.dokument_id = id)
62. 5.717 16.148 ↑ 1.0 40,162 1

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

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

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

  • Hash Cond: (specificke2_.specifickyciel_id = specificky3_.id)
64. 3.546 3.546 ↑ 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.010..3.546 rows=40,162 loops=1)

65. 0.025 0.044 ↑ 1.0 261 1

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

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

  • Heap Fetches: 0
67. 0.032 1.185 ↓ 10.0 260 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
68. 0.152 1.153 ↓ 10.0 260 1

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

69. 0.018 1.001 ↓ 10.0 260 1

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

  • Join Filter: (zaradeniez10_.organ_id = vizibilita12_.organ_id)
70. 0.003 0.418 ↑ 1.0 1 1

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

71. 0.408 0.408 ↑ 1.0 1 1

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

  • Index Cond: (osoba_id = 1088)
  • Filter: (dateinvalidate IS NULL)
  • Rows Removed by Filter: 1
72. 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
73. 0.565 0.565 ↓ 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.396..0.565 rows=260 loops=1)

  • Index Cond: (organ_id = organimple11_.id)
  • Heap Fetches: 0
74. 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
75. 2,117.058 7,247.919 ↓ 1.0 7,807,125 1

Hash (cost=263,288.75..263,288.75 rows=7,806,775 width=45) (actual time=7,247.919..7,247.919 rows=7,807,125 loops=1)

  • Buckets: 262144 Batches: 64 Memory Usage: 11361kB
76. 5,130.861 5,130.861 ↓ 1.0 7,807,125 1

Seq Scan on d_dokument dokument9_ (cost=0.00..263,288.75 rows=7,806,775 width=45) (actual time=0.178..5,130.861 rows=7,807,125 loops=1)

Planning time : 61.714 ms
Execution time : 74,253.941 ms