explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8MKM

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 1,166.609 ↑ 1.0 1 1

Aggregate (cost=117,561.72..117,561.73 rows=1 width=8) (actual time=1,166.609..1,166.609 rows=1 loops=1)

2. 0.005 1,166.600 ↓ 0.0 0 1

Hash Semi Join (cost=33,279.09..117,561.34 rows=154 width=8) (actual time=1,166.600..1,166.600 rows=0 loops=1)

  • Hash Cond: (specificke2_.specifickyciel_id = vizibilita12_.specifickyciel_id)
3. 0.004 1,166.118 ↓ 0.0 0 1

Hash Join (cost=33,269.47..117,548.37 rows=624 width=24) (actual time=1,166.118..1,166.118 rows=0 loops=1)

  • Hash Cond: (specificke2_.specifickyciel_id = specificky3_.id)
4. 0.001 1,166.058 ↓ 0.0 0 1

Nested Loop (cost=33,259.95..117,537.19 rows=624 width=16) (actual time=1,166.058..1,166.058 rows=0 loops=1)

  • Join Filter: (zonfpview0_.verziaid = specificke2_.zonfpverzia_id)
5. 29.114 1,166.057 ↓ 0.0 0 1

Nested Loop (cost=33,259.66..117,341.70 rows=604 width=32) (actual time=1,166.057..1,166.057 rows=0 loops=1)

6. 19.583 454.835 ↓ 1.1 48,722 1

Merge Join (cost=33,259.22..37,421.87 rows=44,183 width=40) (actual time=375.485..454.835 rows=48,722 loops=1)

  • Merge Cond: (zonfpview0_.verziaid = dokumenty5_.zonfpverzia_id)
7. 9.662 393.998 ↑ 1.0 17,282 1

Merge Join (cost=33,258.93..34,319.07 rows=17,282 width=24) (actual time=375.437..393.998 rows=17,282 loops=1)

  • Merge Cond: (zonfpview0_.verziaid = zonfpverzi1_.id)
8. 6.956 378.600 ↑ 1.0 17,282 1

Sort (cost=33,258.64..33,301.85 rows=17,282 width=16) (actual time=375.406..378.600 rows=17,282 loops=1)

  • Sort Key: zonfpview0_.verziaid
  • Sort Method: quicksort Memory: 1579kB
9. 0.893 371.644 ↑ 1.0 17,282 1

Subquery Scan on zonfpview0_ (cost=31,653.41..32,042.25 rows=17,282 width=16) (actual time=364.264..371.644 rows=17,282 loops=1)

10. 23.085 370.751 ↑ 1.0 17,282 1

HashAggregate (cost=31,653.41..31,869.43 rows=17,282 width=632) (actual time=364.263..370.751 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
11. 27.711 347.666 ↑ 1.0 17,282 1

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

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

13. 9.804 297.937 ↑ 1.0 17,282 1

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

  • Buckets: 32768 Batches: 1 Memory Usage: 5313kB
14. 3.351 288.133 ↑ 1.0 17,282 1

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

  • Hash Cond: (workflowst7_.workflowprechod_id = workflowpr9_.id)
15. 4.010 284.376 ↑ 1.0 17,282 1

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

  • Hash Cond: (stav.faza_id = faza.id)
16. 4.232 280.287 ↑ 1.0 17,282 1

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

  • Hash Cond: (workflowst8_.stav_id = stav.id)
17. 4.320 275.945 ↑ 1.0 17,282 1

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

  • Hash Cond: (workflowst7_.workflowstav_id = workflowst8_.id)
18. 21.452 271.472 ↑ 1.0 17,282 1

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

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

20. 9.256 202.326 ↑ 1.0 17,282 1

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

  • Buckets: 32768 Batches: 1 Memory Usage: 4962kB
21. 30.934 193.070 ↑ 1.0 17,282 1

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

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

23. 9.025 139.533 ↑ 1.0 17,282 1

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

  • Buckets: 32768 Batches: 1 Memory Usage: 4820kB
24. 5.645 130.508 ↑ 1.0 17,282 1

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

  • Hash Cond: (projekt.aktualnaverzia_id = projektverzia.id)
25. 5.513 112.726 ↑ 1.0 17,282 1

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

  • Hash Cond: (zonfp.projekt_id = projekt.id)
26. 4.021 104.567 ↑ 1.0 17,282 1

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

  • Hash Cond: (vyzvaverzia.vyhlasovatel_id = oif.id)
27. 4.480 100.420 ↑ 1.0 17,282 1

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

  • Hash Cond: (zonfpverzia.vyzvaverzia_id = vyzvaverzia.id)
28. 8.047 93.987 ↑ 1.0 17,282 1

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

  • Hash Cond: (zonfpverzia.ziadatel_id = subjekt.id)
29. 15.629 64.862 ↑ 1.0 17,282 1

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

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

31. 2.403 6.610 ↑ 1.0 17,282 1

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

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

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

33. 3.101 21.078 ↑ 1.0 14,643 1

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

  • Buckets: 16384 Batches: 1 Memory Usage: 1194kB
34. 7.429 17.977 ↑ 1.0 14,643 1

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

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

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

36. 1.914 5.120 ↑ 1.0 14,643 1

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

  • Buckets: 16384 Batches: 1 Memory Usage: 815kB
37. 3.206 3.206 ↑ 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..3.206 rows=14,643 loops=1)

38. 0.274 1.953 ↑ 1.0 1,894 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 105kB
39. 1.679 1.679 ↑ 1.0 1,894 1

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

40. 0.047 0.126 ↑ 1.0 211 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 25kB
41. 0.079 0.079 ↑ 1.0 211 1

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

42. 1.077 2.646 ↑ 1.0 8,552 1

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

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

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

44. 1.848 12.137 ↑ 1.0 8,559 1

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

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

46. 0.069 0.153 ↑ 1.0 517 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 37kB
47. 0.084 0.084 ↑ 1.0 517 1

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

48. 0.042 0.110 ↑ 1.0 304 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 30kB
49. 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.014..0.068 rows=304 loops=1)

50. 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
51. 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.007..0.051 rows=229 loops=1)

52. 0.180 0.406 ↑ 1.0 1,219 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 133kB
53. 0.226 0.226 ↑ 1.0 1,219 1

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

54. 5.736 5.736 ↑ 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.025..5.736 rows=38,915 loops=1)

  • Heap Fetches: 0
55. 41.254 41.254 ↑ 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.014..41.254 rows=99,489 loops=1)

56. 682.108 682.108 ↓ 0.0 0 48,722

Index Scan using d_dokument_pkey on d_dokument dokument6_ (cost=0.43..1.81 rows=1 width=8) (actual time=0.014..0.014 rows=0 loops=48,722)

  • Index Cond: (id = dokumenty5_.dokument_id)
  • Filter: (f_unaccent(lower(nazov)) ~~ '%vypis%'::text)
  • Rows Removed by Filter: 1
57. 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.31 rows=1 width=16) (never executed)

  • Index Cond: (zonfpverzia_id = dokumenty5_.zonfpverzia_id)
58. 0.029 0.056 ↑ 1.0 261 1

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

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

  • Heap Fetches: 0
60. 0.047 0.477 ↓ 10.0 260 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
61. 0.004 0.430 ↓ 10.0 260 1

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

62. 0.032 0.166 ↓ 10.0 260 1

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

  • Join Filter: (zaradeniez10_.organ_id = vizibilita12_.organ_id)
63. 0.002 0.067 ↑ 1.0 1 1

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

64. 0.060 0.060 ↑ 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.060..0.060 rows=1 loops=1)

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

  • Index Cond: (id = zaradeniez10_.organ_id)
  • Heap Fetches: 0
66. 0.067 0.067 ↓ 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.030..0.067 rows=260 loops=1)

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

  • Index Cond: (id = vizibilita12_.specifickyciel_id)
  • Heap Fetches: 0
Planning time : 14.523 ms
Execution time : 1,170.940 ms