explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sNQr

Settings
# exclusive inclusive rows x rows loops node
1. 664.310 2,829.970 ↑ 1.0 1 1

Aggregate (cost=150,074.53..150,074.54 rows=1 width=8) (actual time=2,829.970..2,829.970 rows=1 loops=1)

2. 438.587 2,165.660 ↓ 4.9 2,503,487 1

Hash Semi Join (cost=33,674.12..148,787.19 rows=514,936 width=8) (actual time=508.940..2,165.660 rows=2,503,487 loops=1)

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

Hash Right Join (cost=33,664.50..137,698.93 rows=2,038,087 width=24) (actual time=508.607..1,726.748 rows=2,503,487 loops=1)

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

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

  • Merge Cond: (podmienkyp7_.id = dokumenty8_.podmienkapomocidokumentzonfp_id)
5. 126.058 126.058 ↑ 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.018..126.058 rows=756,771 loops=1)

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

  • Heap Fetches: 0
7. 8.687 508.354 ↓ 1.1 50,329 1

Hash (cost=33,093.66..33,093.66 rows=45,599 width=32) (actual time=508.353..508.354 rows=50,329 loops=1)

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

Hash Right Join (cost=30,731.70..33,093.66 rows=45,599 width=32) (actual time=473.649..499.667 rows=50,329 loops=1)

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

10. 3.878 473.519 ↓ 1.0 17,856 1

Hash (cost=30,508.75..30,508.75 rows=17,836 width=32) (actual time=473.519..473.519 rows=17,856 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1372kB
11. 3.914 469.641 ↓ 1.0 17,856 1

Hash Join (cost=29,829.16..30,508.75 rows=17,836 width=32) (actual time=449.264..469.641 rows=17,856 loops=1)

  • Hash Cond: (specificke2_.specifickyciel_id = specificky3_.id)
12. 7.462 465.681 ↓ 1.0 17,856 1

Hash Join (cost=29,819.63..30,451.64 rows=17,836 width=24) (actual time=449.214..465.681 rows=17,856 loops=1)

  • Hash Cond: (zonfpverzia.id = zonfpverzi1_.id)
13. 32.262 430.353 ↑ 1.0 17,282 1

Finalize HashAggregate (cost=27,402.20..27,618.22 rows=17,282 width=632) (actual time=421.136..430.353 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
14. 73.615 398.091 ↓ 1.2 17,282 1

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

  • Workers Planned: 2
  • Workers Launched: 2
15. 15.056 324.476 ↑ 1.2 5,761 3 / 3

Partial HashAggregate (cost=24,403.92..24,493.93 rows=7,201 width=320) (actual time=320.968..324.476 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
16. 10.741 309.420 ↑ 1.2 5,761 3 / 3

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

17. 7.720 258.354 ↑ 1.2 5,761 3 / 3

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

18. 2.482 181.506 ↑ 1.2 5,761 3 / 3

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

  • Hash Cond: (workflowst7_.workflowprechod_id = workflowpr9_.id)
19. 3.055 178.298 ↑ 1.2 5,761 3 / 3

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

  • Hash Cond: (stav.faza_id = faza.id)
20. 3.398 175.068 ↑ 1.2 5,761 3 / 3

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

  • Hash Cond: (workflowst8_.stav_id = stav.id)
21. 3.678 171.444 ↑ 1.2 5,761 3 / 3

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

  • Hash Cond: (workflowst7_.workflowstav_id = workflowst8_.id)
22. 5.088 167.430 ↑ 1.2 5,761 3 / 3

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

23. 4.896 122.017 ↑ 1.2 5,761 3 / 3

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

  • Hash Cond: (projekt.aktualnaverzia_id = projektverzia.id)
24. 3.319 111.430 ↑ 1.2 5,761 3 / 3

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

  • Hash Cond: (zonfp.projekt_id = projekt.id)
25. 2.938 103.278 ↑ 1.2 5,761 3 / 3

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

  • Hash Cond: (vyzvaverzia.vyhlasovatel_id = oif.id)
26. 3.582 100.159 ↑ 1.2 5,761 3 / 3

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

  • Hash Cond: (zonfpverzia.vyzvaverzia_id = vyzvaverzia.id)
27. 4.371 94.224 ↑ 1.2 5,761 3 / 3

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

  • Hash Cond: (subjekt.subjektverziaaktualna_id = subjektverzia.id)
28. 4.147 71.232 ↑ 1.2 5,761 3 / 3

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

  • Hash Cond: (zonfpverzia.ziadatel_id = subjekt.id)
29. 9.545 59.230 ↑ 1.2 5,761 3 / 3

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

  • Hash Cond: (zonfpverzia.id = zonfp.verziazonfpaktualna_id)
30. 38.212 38.212 ↑ 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.071..38.212 rows=12,972 loops=3)

31. 4.685 11.473 ↑ 1.0 17,282 3 / 3

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

  • Buckets: 32768 Batches: 1 Memory Usage: 1276kB
32. 6.788 6.788 ↑ 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.038..6.788 rows=17,282 loops=3)

33. 3.235 7.855 ↑ 1.0 14,643 3 / 3

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

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

35. 6.700 18.621 ↑ 1.0 24,517 3 / 3

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

  • Buckets: 32768 Batches: 1 Memory Usage: 2132kB
36. 11.921 11.921 ↑ 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.051..11.921 rows=24,517 loops=3)

37. 0.352 2.353 ↑ 1.0 1,894 3 / 3

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

  • Buckets: 2048 Batches: 1 Memory Usage: 105kB
38. 2.001 2.001 ↑ 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.032..2.001 rows=1,894 loops=3)

39. 0.063 0.181 ↑ 1.0 211 3 / 3

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

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

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

41. 1.942 4.833 ↑ 1.0 8,552 3 / 3

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

  • Buckets: 16384 Batches: 1 Memory Usage: 529kB
42. 2.891 2.891 ↑ 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.891 rows=8,552 loops=3)

43. 1.040 5.691 ↑ 1.8 2,853 3 / 3

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

  • Buckets: 16384 Batches: 1 Memory Usage: 1088kB
44. 4.651 4.651 ↓ 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.031..13.952 rows=8,559 loops=1)

45. 40.325 40.325 ↑ 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.007..0.007 rows=1 loops=17,282)

  • Index Cond: (zonfp.workflowstavaktualny_id = id)
46. 0.127 0.336 ↑ 1.0 517 3 / 3

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

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

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

48. 0.084 0.226 ↑ 1.0 304 3 / 3

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

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

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

50. 0.049 0.175 ↑ 1.0 229 3 / 3

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

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

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

52. 0.315 0.726 ↑ 1.0 1,219 3 / 3

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

  • Buckets: 2048 Batches: 1 Memory Usage: 133kB
53. 0.411 0.411 ↑ 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.032..0.411 rows=1,219 loops=3)

54. 69.128 69.128 ↑ 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.012..0.012 rows=1 loops=17,282)

  • Index Cond: (id = zonfpverzia.draftzonfp_id)
55. 40.325 40.325 ↑ 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.007..0.007 rows=1 loops=17,282)

  • Index Cond: (id = dv.odoslanie_id)
56. 7.090 27.866 ↑ 1.0 40,162 1

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

  • Buckets: 65536 Batches: 1 Memory Usage: 2709kB
57. 9.613 20.776 ↑ 1.0 40,162 1

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

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

59. 4.135 7.540 ↑ 1.0 38,915 1

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

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

  • Heap Fetches: 0
61. 0.023 0.046 ↑ 1.0 261 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
62. 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
63. 0.032 0.325 ↓ 10.0 260 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
64. 0.152 0.293 ↓ 10.0 260 1

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

65. 0.022 0.141 ↓ 10.0 260 1

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

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

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

67. 0.059 0.059 ↑ 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.058..0.059 rows=1 loops=1)

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

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

  • Index Cond: (organ_id = organimple11_.id)
  • Heap Fetches: 0
70. 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 : 14.258 ms
Execution time : 2,834.995 ms