explain.depesz.com

PostgreSQL's explain analyze made readable

Result: I7us

Settings
# exclusive inclusive rows x rows loops node
1. 44.629 74,299.057 ↑ 1.0 1 1

Aggregate (cost=113,259,582.41..113,259,582.42 rows=1 width=8) (actual time=74,299.057..74,299.057 rows=1 loops=1)

2. 71.932 74,254.428 ↓ 1.8 100,725 1

Nested Loop Left Join (cost=68,421.09..113,259,443.03 rows=55,749 width=8) (actual time=1,151.881..74,254.428 rows=100,725 loops=1)

3. 13,245.038 73,985.012 ↓ 1.8 98,742 1

Nested Loop (cost=68,420.80..113,241,788.44 rows=54,018 width=16) (actual time=1,151.860..73,985.012 rows=98,742 loops=1)

4. 732.940 2,968.158 ↓ 1.2 2,407,159 1

Hash Join (cost=68,366.28..154,744.12 rows=1,974,799 width=32) (actual time=1,151.282..2,968.158 rows=2,407,159 loops=1)

  • Hash Cond: (zonfpverzia.id = dokumenty5_.zonfpverzia_id)
5. 858.834 2,213.539 ↓ 1.1 841,760 1

Hash Join (cost=65,589.78..126,244.04 rows=772,434 width=40) (actual time=1,129.043..2,213.539 rows=841,760 loops=1)

  • Hash Cond: (dokumenty8_.podmienkapomocidokumentzonfp_id = podmienkyp7_.id)
6. 226.700 226.700 ↑ 1.0 1,739,340 1

Seq Scan on podmienkapomocidokumentzonfp_to_dokument dokumenty8_ (cost=0.00..26,795.40 rows=1,739,340 width=16) (actual time=0.012..226.700 rows=1,739,340 loops=1)

7. 86.991 1,128.005 ↓ 1.0 340,233 1

Hash (cost=58,762.79..58,762.79 rows=336,079 width=40) (actual time=1,128.005..1,128.005 rows=340,233 loops=1)

  • Buckets: 262144 Batches: 2 Memory Usage: 14043kB
8. 52.182 1,041.014 ↓ 1.0 340,233 1

Nested Loop (cost=32,844.18..58,762.79 rows=336,079 width=40) (actual time=380.975..1,041.014 rows=340,233 loops=1)

  • Join Filter: (zonfpverzia.id = podmienkyp7_.zonfpverzia_id)
9. 8.645 401.244 ↑ 1.0 17,282 1

Hash Join (cost=32,843.76..33,277.97 rows=17,282 width=24) (actual time=379.963..401.244 rows=17,282 loops=1)

  • Hash Cond: (zonfpverzia.id = zonfpverzi1_.id)
10. 29.621 382.866 ↑ 1.0 17,282 1

HashAggregate (cost=31,653.41..31,869.43 rows=17,282 width=632) (actual time=369.905..382.866 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. 28.800 353.245 ↑ 1.0 17,282 1

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

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

13. 10.602 303.274 ↑ 1.0 17,282 1

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

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

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

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

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

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

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

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

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

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

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

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

20. 7.741 202.016 ↑ 1.0 17,282 1

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

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

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

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

23. 9.301 145.574 ↑ 1.0 17,282 1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

31. 2.990 7.662 ↑ 1.0 17,282 1

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

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

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

33. 3.173 20.502 ↑ 1.0 14,643 1

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

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

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

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

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

36. 1.915 4.414 ↑ 1.0 14,643 1

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

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

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

38. 0.323 2.217 ↑ 1.0 1,894 1

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

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

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

40. 0.037 0.094 ↑ 1.0 211 1

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

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

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

42. 1.624 4.347 ↑ 1.0 8,552 1

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

  • Buckets: 16384 Batches: 1 Memory Usage: 529kB
43. 2.723 2.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.045..2.723 rows=8,552 loops=1)

44. 2.034 12.847 ↑ 1.0 8,559 1

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

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

46. 0.099 0.228 ↑ 1.0 517 1

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

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

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

48. 0.061 0.148 ↑ 1.0 304 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 30kB
49. 0.087 0.087 ↑ 1.0 304 1

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

50. 0.036 0.108 ↑ 1.0 229 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
51. 0.072 0.072 ↑ 1.0 229 1

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

52. 0.244 0.549 ↑ 1.0 1,219 1

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

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

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

54. 5.591 9.733 ↑ 1.0 38,915 1

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

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

  • Heap Fetches: 0
56. 587.588 587.588 ↑ 1.4 20 17,282

Index Scan using d_podmienkapomocidokument__zonfpverzia_id_idx on d_podmienkapomocidokumentzonfp podmienkyp7_ (cost=0.42..1.14 rows=27 width=16) (actual time=0.029..0.034 rows=20 loops=17,282)

  • Index Cond: (zonfpverzia_id = zonfpverzi1_.id)
57. 12.666 21.679 ↑ 1.0 99,489 1

Hash (cost=1,532.89..1,532.89 rows=99,489 width=16) (actual time=21.679..21.679 rows=99,489 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 5688kB
58. 9.013 9.013 ↑ 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.014..9.013 rows=99,489 loops=1)

59. 48,143.180 57,771.816 ↓ 0.0 0 2,407,159

Bitmap Heap Scan on d_dokument dokument9_ (cost=54.52..57.26 rows=1 width=8) (actual time=0.024..0.024 rows=0 loops=2,407,159)

  • Recheck Cond: ((dokumenty8_.dokument_id = id) OR (dokumenty5_.dokument_id = id))
  • Filter: (f_unaccent(lower(nazov)) ~~ '%vypis%'::text)
  • Rows Removed by Filter: 2
  • Heap Blocks: exact=4520528
60. 0.000 9,628.636 ↓ 0.0 0 2,407,159

BitmapOr (cost=54.52..54.52 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=2,407,159)

61. 4,814.318 4,814.318 ↑ 1.0 1 2,407,159

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,407,159)

  • Index Cond: (dokumenty8_.dokument_id = id)
62. 4,814.318 4,814.318 ↑ 1.0 1 2,407,159

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,407,159)

  • Index Cond: (dokumenty5_.dokument_id = id)
63. 197.484 197.484 ↑ 1.0 1 98,742

Index Scan using zonfpverzia_to_specifickyciel__zonfpverzia_id_idx on zonfpverzia_to_specifickyciel specificke2_ (cost=0.29..0.32 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=98,742)

  • Index Cond: (zonfpverzi1_.id = zonfpverzia_id)
Planning time : 15.464 ms
Execution time : 74,305.369 ms