explain.depesz.com

PostgreSQL's explain analyze made readable

Result: plyW

Settings
# exclusive inclusive rows x rows loops node
1. 698.630 2,879.439 ↑ 1.0 1 1

Aggregate (cost=181,162.07..181,162.08 rows=1 width=8) (actual time=2,879.438..2,879.439 rows=1 loops=1)

2. 437.091 2,180.809 ↓ 4.9 2,503,487 1

Hash Semi Join (cost=64,761.66..179,874.73 rows=514,936 width=8) (actual time=531.495..2,180.809 rows=2,503,487 loops=1)

  • Hash Cond: (specificke2_.specifickyciel_id = vizibilita12_.specifickyciel_id)
3. 565.651 1,743.473 ↓ 1.2 2,503,487 1

Hash Right Join (cost=64,752.04..168,786.47 rows=2,038,087 width=24) (actual time=531.243..1,743.473 rows=2,503,487 loops=1)

  • Hash Cond: (podmienkyp7_.zonfpverzia_id = zonfpverzi1_.id)
4. 346.564 646.812 ↓ 1.0 1,768,194 1

Merge Left Join (cost=0.85..77,131.89 rows=1,739,340 width=8) (actual time=0.024..646.812 rows=1,768,194 loops=1)

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

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

6. 175.962 175.962 ↑ 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.011..175.962 rows=1,739,340 loops=1)

  • Heap Fetches: 0
7. 10.468 531.010 ↓ 1.1 50,329 1

Hash (cost=64,181.20..64,181.20 rows=45,599 width=32) (actual time=531.010..531.010 rows=50,329 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 3658kB
8. 15.618 520.542 ↓ 1.1 50,329 1

Hash Join (cost=30,481.53..64,181.20 rows=45,599 width=32) (actual time=346.282..520.542 rows=50,329 loops=1)

  • Hash Cond: (zonfpverzia.id = specificke2_.zonfpverzia_id)
9. 32.882 488.224 ↓ 1.1 48,722 1

Nested Loop Left Join (cost=29,243.22..61,931.43 rows=44,183 width=24) (actual time=329.383..488.224 rows=48,722 loops=1)

10. 22.839 357.898 ↓ 1.1 48,722 1

Hash Right Join (cost=29,242.79..31,590.59 rows=44,183 width=24) (actual time=329.272..357.898 rows=48,722 loops=1)

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

12. 4.218 329.130 ↑ 1.0 17,282 1

Hash (cost=29,026.76..29,026.76 rows=17,282 width=16) (actual time=329.130..329.130 rows=17,282 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1067kB
13. 8.881 324.912 ↑ 1.0 17,282 1

Hash Join (cost=28,592.55..29,026.76 rows=17,282 width=16) (actual time=303.343..324.912 rows=17,282 loops=1)

  • Hash Cond: (zonfpverzia.id = zonfpverzi1_.id)
14. 35.597 308.228 ↑ 1.0 17,282 1

Finalize HashAggregate (cost=27,402.20..27,618.22 rows=17,282 width=632) (actual time=295.325..308.228 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
15. 52.075 272.631 ↓ 1.2 17,282 1

Gather (cost=25,403.92..26,934.13 rows=14,402 width=320) (actual time=262.681..272.631 rows=17,282 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
16. 13.742 220.556 ↑ 1.2 5,761 3 / 3

Partial HashAggregate (cost=24,403.92..24,493.93 rows=7,201 width=320) (actual time=217.156..220.556 rows=5,761 loops=3)

  • 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
17. 10.523 206.814 ↑ 1.2 5,761 3 / 3

Nested Loop Left Join (cost=4,879.19..24,169.89 rows=7,201 width=320) (actual time=52.051..206.814 rows=5,761 loops=3)

18. 8.027 173.248 ↑ 1.2 5,761 3 / 3

Nested Loop Left Join (cost=4,878.77..20,489.64 rows=7,201 width=324) (actual time=51.983..173.248 rows=5,761 loops=3)

19. 2.190 136.418 ↑ 1.2 5,761 3 / 3

Hash Left Join (cost=4,878.48..16,723.89 rows=7,201 width=324) (actual time=51.944..136.418 rows=5,761 loops=3)

  • Hash Cond: (workflowst7_.workflowprechod_id = workflowpr9_.id)
20. 2.788 133.468 ↑ 1.2 5,761 3 / 3

Hash Left Join (cost=4,828.06..16,654.56 rows=7,201 width=278) (actual time=51.169..133.468 rows=5,761 loops=3)

  • Hash Cond: (stav.faza_id = faza.id)
21. 3.005 130.496 ↑ 1.2 5,761 3 / 3

Hash Left Join (cost=4,817.90..16,625.16 rows=7,201 width=282) (actual time=50.945..130.496 rows=5,761 loops=3)

  • Hash Cond: (workflowst8_.stav_id = stav.id)
22. 3.544 127.256 ↑ 1.2 5,761 3 / 3

Hash Left Join (cost=4,804.06..16,592.15 rows=7,201 width=262) (actual time=50.694..127.256 rows=5,761 loops=3)

  • Hash Cond: (workflowst7_.workflowstav_id = workflowst8_.id)
23. 2.985 123.352 ↑ 1.2 5,761 3 / 3

Nested Loop Left Join (cost=4,785.43..16,554.46 rows=7,201 width=256) (actual time=50.321..123.352 rows=5,761 loops=3)

24. 4.037 91.564 ↑ 1.2 5,761 3 / 3

Parallel Hash Left Join (cost=4,785.01..12,206.82 rows=7,201 width=247) (actual time=50.277..91.564 rows=5,761 loops=3)

  • Hash Cond: (projekt.aktualnaverzia_id = projektverzia.id)
25. 3.030 84.913 ↑ 1.2 5,761 3 / 3

Hash Left Join (cost=3,006.73..10,409.63 rows=7,201 width=188) (actual time=47.529..84.913 rows=5,761 loops=3)

  • Hash Cond: (zonfp.projekt_id = projekt.id)
26. 2.811 76.811 ↑ 1.2 5,761 3 / 3

Hash Join (cost=2,679.31..10,063.30 rows=7,201 width=180) (actual time=42.364..76.811 rows=5,761 loops=3)

  • Hash Cond: (vyzvaverzia.vyhlasovatel_id = oif.id)
27. 3.160 73.785 ↑ 1.2 5,761 3 / 3

Hash Join (cost=2,670.56..10,035.27 rows=7,201 width=151) (actual time=42.133..73.785 rows=5,761 loops=3)

  • Hash Cond: (zonfpverzia.vyzvaverzia_id = vyzvaverzia.id)
28. 4.020 68.249 ↑ 1.2 5,761 3 / 3

Hash Join (cost=2,424.95..9,770.71 rows=7,201 width=151) (actual time=39.734..68.249 rows=5,761 loops=3)

  • Hash Cond: (subjekt.subjektverziaaktualna_id = subjektverzia.id)
29. 3.934 45.139 ↑ 1.2 5,761 3 / 3

Hash Join (cost=1,242.31..8,569.18 rows=7,201 width=124) (actual time=20.456..45.139 rows=5,761 loops=3)

  • Hash Cond: (zonfpverzia.ziadatel_id = subjekt.id)
30. 14.161 33.601 ↑ 1.2 5,761 3 / 3

Hash Join (cost=726.85..8,034.81 rows=7,201 width=124) (actual time=12.773..33.601 rows=5,761 loops=3)

  • Hash Cond: (zonfpverzia.id = zonfp.verziazonfpaktualna_id)
31. 6.857 6.857 ↑ 1.2 12,972 3 / 3

Parallel Seq Scan on d_zonfpverzia zonfpverzia (cost=0.00..7,175.15 rows=16,215 width=116) (actual time=0.010..6.857 rows=12,972 loops=3)

32. 5.459 12.583 ↑ 1.0 17,282 3 / 3

Hash (cost=510.82..510.82 rows=17,282 width=40) (actual time=12.582..12.583 rows=17,282 loops=3)

  • Buckets: 32768 Batches: 1 Memory Usage: 1276kB
33. 7.124 7.124 ↑ 1.0 17,282 3 / 3

Seq Scan on d_zonfp zonfp (cost=0.00..510.82 rows=17,282 width=40) (actual time=0.061..7.124 rows=17,282 loops=3)

34. 3.265 7.604 ↑ 1.0 14,643 3 / 3

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

  • Buckets: 16384 Batches: 1 Memory Usage: 815kB
35. 4.339 4.339 ↑ 1.0 14,643 3 / 3

Seq Scan on d_subjekt subjekt (cost=0.00..332.43 rows=14,643 width=16) (actual time=0.053..4.339 rows=14,643 loops=3)

36. 7.302 19.090 ↑ 1.0 24,517 3 / 3

Hash (cost=876.17..876.17 rows=24,517 width=43) (actual time=19.090..19.090 rows=24,517 loops=3)

  • Buckets: 32768 Batches: 1 Memory Usage: 2132kB
37. 11.788 11.788 ↑ 1.0 24,517 3 / 3

Seq Scan on d_subjektverzia subjektverzia (cost=0.00..876.17 rows=24,517 width=43) (actual time=0.054..11.788 rows=24,517 loops=3)

38. 0.391 2.376 ↑ 1.0 1,894 3 / 3

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

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

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

40. 0.070 0.215 ↑ 1.0 211 3 / 3

Hash (cost=6.11..6.11 rows=211 width=45) (actual time=0.215..0.215 rows=211 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 25kB
41. 0.145 0.145 ↑ 1.0 211 3 / 3

Seq Scan on d_organimplementaciefondov oif (cost=0.00..6.11 rows=211 width=45) (actual time=0.065..0.145 rows=211 loops=3)

42. 2.092 5.072 ↑ 1.0 8,552 3 / 3

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

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

Seq Scan on d_projekt projekt (cost=0.00..220.52 rows=8,552 width=16) (actual time=0.063..2.980 rows=8,552 loops=3)

44. 1.068 2.614 ↑ 1.8 2,853 3 / 3

Parallel Hash (cost=1,715.35..1,715.35 rows=5,035 width=75) (actual time=2.614..2.614 rows=2,853 loops=3)

  • Buckets: 16384 Batches: 1 Memory Usage: 1088kB
45. 1.546 1.546 ↓ 1.7 8,559 1 / 3

Parallel Seq Scan on d_projektverzia projektverzia (cost=0.00..1,715.35 rows=5,035 width=75) (actual time=0.007..4.637 rows=8,559 loops=1)

46. 28.803 28.803 ↑ 1.0 1 17,282 / 3

Index Scan using d_workflowstavaktualny_pkey on d_workflowstavaktualny workflowst7_ (cost=0.42..0.60 rows=1 width=25) (actual time=0.005..0.005 rows=1 loops=17,282)

  • Index Cond: (zonfp.workflowstavaktualny_id = id)
47. 0.139 0.360 ↑ 1.0 517 3 / 3

Hash (cost=12.17..12.17 rows=517 width=22) (actual time=0.360..0.360 rows=517 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 37kB
48. 0.221 0.221 ↑ 1.0 517 3 / 3

Seq Scan on d_workflowstav workflowst8_ (cost=0.00..12.17 rows=517 width=22) (actual time=0.053..0.221 rows=517 loops=3)

49. 0.097 0.235 ↑ 1.0 304 3 / 3

Hash (cost=10.04..10.04 rows=304 width=36) (actual time=0.235..0.235 rows=304 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 30kB
50. 0.138 0.138 ↑ 1.0 304 3 / 3

Seq Scan on d_stav stav (cost=0.00..10.04 rows=304 width=36) (actual time=0.030..0.138 rows=304 loops=3)

51. 0.056 0.184 ↑ 1.0 229 3 / 3

Hash (cost=7.29..7.29 rows=229 width=12) (actual time=0.184..0.184 rows=229 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
52. 0.128 0.128 ↑ 1.0 229 3 / 3

Seq Scan on d_faza faza (cost=0.00..7.29 rows=229 width=12) (actual time=0.035..0.128 rows=229 loops=3)

53. 0.348 0.760 ↑ 1.0 1,219 3 / 3

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

  • Buckets: 2048 Batches: 1 Memory Usage: 133kB
54. 0.412 0.412 ↑ 1.0 1,219 3 / 3

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

55. 28.803 28.803 ↑ 1.0 1 17,282 / 3

Index Scan using d_zonfpdraftverzia_pkey on d_zonfpdraftverzia dv (cost=0.29..0.52 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=17,282)

  • Index Cond: (id = zonfpverzia.draftzonfp_id)
56. 23.043 23.043 ↑ 1.0 1 17,282 / 3

Index Scan using d_odoslanie_pkey on d_odoslanie odoslanie (cost=0.42..0.51 rows=1 width=17) (actual time=0.004..0.004 rows=1 loops=17,282)

  • Index Cond: (id = dv.odoslanie_id)
57. 4.586 7.803 ↑ 1.0 38,915 1

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

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

  • Heap Fetches: 0
59. 97.444 97.444 ↑ 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.002..0.002 rows=1 loops=48,722)

  • Index Cond: (id = dokumenty5_.dokument_id)
  • Heap Fetches: 0
60. 6.450 16.700 ↑ 1.0 40,162 1

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

  • Buckets: 65536 Batches: 1 Memory Usage: 2709kB
61. 7.936 10.250 ↑ 1.0 40,162 1

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

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

63. 0.025 0.048 ↑ 1.0 261 1

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

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

  • Heap Fetches: 0
65. 0.029 0.245 ↓ 10.0 260 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
66. 0.148 0.216 ↓ 10.0 260 1

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

67. 0.018 0.068 ↓ 10.0 260 1

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

  • Join Filter: (zaradeniez10_.organ_id = vizibilita12_.organ_id)
68. 0.003 0.018 ↑ 1.0 1 1

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

69. 0.010 0.010 ↑ 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.010..0.010 rows=1 loops=1)

  • Index Cond: (osoba_id = 1088)
  • Filter: (dateinvalidate IS NULL)
  • Rows Removed by Filter: 1
70. 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
71. 0.032 0.032 ↓ 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.009..0.032 rows=260 loops=1)

  • Index Cond: (organ_id = organimple11_.id)
  • Heap Fetches: 0
72. 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
Planning time : 13.419 ms
Execution time : 2,883.905 ms