explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Wk63

Settings
# exclusive inclusive rows x rows loops node
1. 47.758 78,743.524 ↑ 1.0 1 1

Aggregate (cost=7,963,512,938.96..7,963,512,938.97 rows=1 width=8) (actual time=78,743.524..78,743.524 rows=1 loops=1)

2. 44.794 78,695.766 ↓ 7.3 100,725 1

Hash Semi Join (cost=41,831.80..7,963,512,904.53 rows=13,769 width=8) (actual time=457.251..78,695.766 rows=100,725 loops=1)

  • Hash Cond: (specificke2_.specifickyciel_id = vizibilita12_.specifickyciel_id)
3. 58,501.808 78,650.673 ↓ 1.8 100,725 1

Nested Loop Left Join (cost=41,822.18..7,963,512,595.40 rows=55,749 width=24) (actual time=456.947..78,650.673 rows=100,725 loops=1)

  • Filter: (f_unaccent(lower(dokument9_.nazov)) ~~ '%vypis%'::text)
  • Rows Removed by Filter: 4867516
4. 911.833 2,624.456 ↓ 1.2 2,503,487 1

Hash Right Join (cost=37,917.66..141,950.96 rows=2,038,087 width=40) (actual time=456.264..2,624.456 rows=2,503,487 loops=1)

  • Hash Cond: (podmienkyp7_.zonfpverzia_id = zonfpverzi1_.id)
5. 628.263 1,256.648 ↓ 1.0 1,768,194 1

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

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

7. 353.255 353.255 ↑ 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.053..353.255 rows=1,739,340 loops=1)

  • Heap Fetches: 0
8. 8.605 455.975 ↓ 1.1 50,329 1

Hash (cost=37,344.87..37,344.87 rows=45,599 width=40) (actual time=455.975..455.975 rows=50,329 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 4051kB
9. 17.631 447.370 ↓ 1.1 50,329 1

Hash Right Join (cost=34,982.90..37,344.87 rows=45,599 width=40) (actual time=422.449..447.370 rows=50,329 loops=1)

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

11. 3.036 422.300 ↓ 1.0 17,856 1

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

  • Buckets: 32768 Batches: 1 Memory Usage: 1372kB
12. 2.828 419.264 ↓ 1.0 17,856 1

Hash Join (cost=34,080.36..34,759.95 rows=17,836 width=32) (actual time=403.360..419.264 rows=17,856 loops=1)

  • Hash Cond: (specificke2_.specifickyciel_id = specificky3_.id)
13. 5.975 416.383 ↓ 1.0 17,856 1

Hash Join (cost=34,070.84..34,702.85 rows=17,836 width=24) (actual time=403.302..416.383 rows=17,856 loops=1)

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

HashAggregate (cost=31,653.41..31,869.43 rows=17,282 width=632) (actual time=376.672..383.990 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. 26.884 360.626 ↑ 1.0 17,282 1

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

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

17. 10.882 313.966 ↑ 1.0 17,282 1

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

  • Buckets: 32768 Batches: 1 Memory Usage: 5313kB
18. 3.714 303.084 ↑ 1.0 17,282 1

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

  • Hash Cond: (workflowst7_.workflowprechod_id = workflowpr9_.id)
19. 4.601 298.998 ↑ 1.0 17,282 1

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

  • Hash Cond: (stav.faza_id = faza.id)
20. 4.719 294.321 ↑ 1.0 17,282 1

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

  • Hash Cond: (workflowst8_.stav_id = stav.id)
21. 4.903 289.495 ↑ 1.0 17,282 1

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

  • Hash Cond: (workflowst7_.workflowstav_id = workflowst8_.id)
22. 23.476 284.438 ↑ 1.0 17,282 1

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

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

24. 9.372 214.046 ↑ 1.0 17,282 1

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

  • Buckets: 32768 Batches: 1 Memory Usage: 4962kB
25. 34.421 204.674 ↑ 1.0 17,282 1

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

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

27. 9.351 144.199 ↑ 1.0 17,282 1

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

  • Buckets: 32768 Batches: 1 Memory Usage: 4820kB
28. 5.711 134.848 ↑ 1.0 17,282 1

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

  • Hash Cond: (projekt.aktualnaverzia_id = projektverzia.id)
29. 5.692 116.316 ↑ 1.0 17,282 1

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

  • Hash Cond: (zonfp.projekt_id = projekt.id)
30. 4.297 108.149 ↑ 1.0 17,282 1

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

  • Hash Cond: (vyzvaverzia.vyhlasovatel_id = oif.id)
31. 4.742 103.768 ↑ 1.0 17,282 1

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

  • Hash Cond: (zonfpverzia.vyzvaverzia_id = vyzvaverzia.id)
32. 8.428 97.514 ↑ 1.0 17,282 1

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

  • Hash Cond: (zonfpverzia.ziadatel_id = subjekt.id)
33. 15.618 68.692 ↑ 1.0 17,282 1

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

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

35. 3.167 8.025 ↑ 1.0 17,282 1

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

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

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

37. 2.803 20.394 ↑ 1.0 14,643 1

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

  • Buckets: 16384 Batches: 1 Memory Usage: 1194kB
38. 7.148 17.591 ↑ 1.0 14,643 1

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

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

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

40. 2.483 5.784 ↑ 1.0 14,643 1

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

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

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

42. 0.230 1.512 ↑ 1.0 1,894 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 105kB
43. 1.282 1.282 ↑ 1.0 1,894 1

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

44. 0.036 0.084 ↑ 1.0 211 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 25kB
45. 0.048 0.048 ↑ 1.0 211 1

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

46. 1.000 2.475 ↑ 1.0 8,552 1

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

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

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

48. 1.969 12.821 ↑ 1.0 8,559 1

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

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

50. 0.066 0.154 ↑ 1.0 517 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 37kB
51. 0.088 0.088 ↑ 1.0 517 1

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

52. 0.042 0.107 ↑ 1.0 304 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 30kB
53. 0.065 0.065 ↑ 1.0 304 1

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

54. 0.027 0.076 ↑ 1.0 229 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
55. 0.049 0.049 ↑ 1.0 229 1

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

56. 0.167 0.372 ↑ 1.0 1,219 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 133kB
57. 0.205 0.205 ↑ 1.0 1,219 1

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

58. 6.396 26.418 ↑ 1.0 40,162 1

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

  • Buckets: 65536 Batches: 1 Memory Usage: 2709kB
59. 8.415 20.022 ↑ 1.0 40,162 1

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

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

61. 4.976 8.591 ↑ 1.0 38,915 1

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

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

  • Heap Fetches: 0
63. 0.028 0.053 ↑ 1.0 261 1

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

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

  • Heap Fetches: 0
65. 7,510.461 17,524.409 ↑ 1.0 2 2,503,487

Bitmap Heap Scan on d_dokument dokument9_ (cost=3,904.52..3,906.75 rows=2 width=45) (actual time=0.006..0.007 rows=2 loops=2,503,487)

  • Recheck Cond: ((dokumenty8_.dokument_id = id) OR (dokumenty5_.dokument_id = id))
  • Heap Blocks: exact=4664406
66. 0.000 10,013.948 ↓ 0.0 0 2,503,487

BitmapOr (cost=3,904.52..3,904.52 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=2,503,487)

67. 5,006.974 5,006.974 ↑ 1.0 1 2,503,487

Bitmap Index Scan on d_dokument_pkey (cost=0.00..0.45 rows=1 width=0) (actual time=0.002..0.002 rows=1 loops=2,503,487)

  • Index Cond: (dokumenty8_.dokument_id = id)
68. 5,006.974 5,006.974 ↑ 1.0 1 2,503,487

Bitmap Index Scan on d_dokument_pkey (cost=0.00..0.68 rows=1 width=0) (actual time=0.002..0.002 rows=1 loops=2,503,487)

  • Index Cond: (dokumenty5_.dokument_id = id)
69. 0.032 0.299 ↓ 10.0 260 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
70. 0.158 0.267 ↓ 10.0 260 1

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

71. 0.021 0.109 ↓ 10.0 260 1

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

  • Join Filter: (zaradeniez10_.organ_id = vizibilita12_.organ_id)
72. 0.001 0.042 ↑ 1.0 1 1

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

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

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

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

  • Index Cond: (organ_id = organimple11_.id)
  • Heap Fetches: 0
76. 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.217 ms
Execution time : 78,747.934 ms