explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GAXH

Settings
# exclusive inclusive rows x rows loops node
1. 7.070 20,207.247 ↑ 1.0 1 1

Aggregate (cost=512,428.49..512,428.50 rows=1 width=8) (actual time=20,207.247..20,207.247 rows=1 loops=1)

2. 8.538 20,200.177 ↓ 3.2 33,986 1

Hash Join (cost=511,842.78..512,402.08 rows=10,564 width=8) (actual time=20,182.844..20,200.177 rows=33,986 loops=1)

  • Hash Cond: (zonfpverzia.id = zonfpverzi1_.id)
3. 23.752 375.055 ↑ 1.0 17,282 1

HashAggregate (cost=31,653.41..31,869.43 rows=17,282 width=632) (actual time=366.136..375.055 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
4. 24.368 351.303 ↑ 1.0 17,282 1

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

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

6. 9.766 307.219 ↑ 1.0 17,282 1

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

  • Buckets: 32768 Batches: 1 Memory Usage: 5313kB
7. 3.528 297.453 ↑ 1.0 17,282 1

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

  • Hash Cond: (workflowst7_.workflowprechod_id = workflowpr9_.id)
8. 4.250 293.529 ↑ 1.0 17,282 1

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

  • Hash Cond: (stav.faza_id = faza.id)
9. 4.216 289.199 ↑ 1.0 17,282 1

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

  • Hash Cond: (workflowst8_.stav_id = stav.id)
10. 4.487 284.873 ↑ 1.0 17,282 1

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

  • Hash Cond: (workflowst7_.workflowstav_id = workflowst8_.id)
11. 22.737 280.226 ↑ 1.0 17,282 1

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

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

13. 7.278 209.818 ↑ 1.0 17,282 1

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

  • Buckets: 32768 Batches: 1 Memory Usage: 4962kB
14. 27.728 202.540 ↑ 1.0 17,282 1

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

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

16. 9.671 151.785 ↑ 1.0 17,282 1

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

  • Buckets: 32768 Batches: 1 Memory Usage: 4820kB
17. 5.893 142.114 ↑ 1.0 17,282 1

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

  • Hash Cond: (projekt.aktualnaverzia_id = projektverzia.id)
18. 5.682 122.806 ↑ 1.0 17,282 1

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

  • Hash Cond: (zonfp.projekt_id = projekt.id)
19. 4.470 114.324 ↑ 1.0 17,282 1

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

  • Hash Cond: (vyzvaverzia.vyhlasovatel_id = oif.id)
20. 4.852 109.758 ↑ 1.0 17,282 1

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

  • Hash Cond: (zonfpverzia.vyzvaverzia_id = vyzvaverzia.id)
21. 8.658 103.154 ↑ 1.0 17,282 1

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

  • Hash Cond: (zonfpverzia.ziadatel_id = subjekt.id)
22. 16.162 74.492 ↑ 1.0 17,282 1

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

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

24. 3.200 8.476 ↑ 1.0 17,282 1

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

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

26. 2.944 20.004 ↑ 1.0 14,643 1

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

  • Buckets: 16384 Batches: 1 Memory Usage: 1194kB
27. 7.034 17.060 ↑ 1.0 14,643 1

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

  • Hash Cond: (subjektverzia.id = subjekt.subjektverziaaktualna_id)
28. 5.524 5.524 ↑ 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.524 rows=24,517 loops=1)

29. 1.771 4.502 ↑ 1.0 14,643 1

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

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

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

31. 0.224 1.752 ↑ 1.0 1,894 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 105kB
32. 1.528 1.528 ↑ 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.528 rows=1,894 loops=1)

33. 0.034 0.096 ↑ 1.0 211 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 25kB
34. 0.062 0.062 ↑ 1.0 211 1

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

35. 1.004 2.800 ↑ 1.0 8,552 1

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

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

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

37. 1.808 13.415 ↑ 1.0 8,559 1

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

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

39. 0.067 0.160 ↑ 1.0 517 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 37kB
40. 0.093 0.093 ↑ 1.0 517 1

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

41. 0.044 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
42. 0.066 0.066 ↑ 1.0 304 1

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

43. 0.028 0.080 ↑ 1.0 229 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
44. 0.052 0.052 ↑ 1.0 229 1

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

45. 0.169 0.396 ↑ 1.0 1,219 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 133kB
46. 0.227 0.227 ↑ 1.0 1,219 1

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

47. 22.956 19,816.584 ↓ 2.9 69,949 1

Hash (cost=479,892.01..479,892.01 rows=23,789 width=8) (actual time=19,816.584..19,816.584 rows=69,949 loops=1)

  • Buckets: 131072 (originally 32768) Batches: 1 (originally 1) Memory Usage: 3757kB
48. 13,519.636 19,793.628 ↓ 2.9 69,949 1

Hash Right Join (cost=28,314.56..479,892.01 rows=23,789 width=8) (actual time=263.460..19,793.628 rows=69,949 loops=1)

  • Hash Cond: (podmienkyp7_.zonfpverzia_id = zonfpverzi1_.id)
  • Filter: (f_unaccent(lower(dokument9_.nazov)) ~~ '%vypis%'::text)
  • Rows Removed by Filter: 1700045
49. 1,203.666 6,265.831 ↓ 1.0 1,768,194 1

Hash Right Join (cost=27,124.21..474,123.91 rows=1,739,340 width=45) (actual time=254.761..6,265.831 rows=1,768,194 loops=1)

  • Hash Cond: (dokumenty8_.podmienkapomocidokumentzonfp_id = podmienkyp7_.id)
50. 1,054.782 4,809.730 ↑ 1.0 1,739,340 1

Merge Left Join (cost=0.86..408,162.78 rows=1,739,340 width=45) (actual time=0.193..4,809.730 rows=1,739,340 loops=1)

  • Merge Cond: (dokumenty8_.dokument_id = dokument9_.id)
51. 419.852 419.852 ↑ 1.0 1,739,340 1

Index Scan using podmienkapomocidokumentzonfp_to_dokument_dokument_id_idx on podmienkapomocidokumentzonfp_to_dokument dokumenty8_ (cost=0.43..40,744.74 rows=1,739,340 width=16) (actual time=0.027..419.852 rows=1,739,340 loops=1)

52. 3,335.096 3,335.096 ↓ 1.0 7,807,009 1

Index Scan using d_dokument_pkey on d_dokument dokument9_ (cost=0.43..326,179.72 rows=7,806,775 width=45) (actual time=0.030..3,335.096 rows=7,807,009 loops=1)

53. 129.772 252.435 ↑ 1.0 756,771 1

Hash (cost=13,967.71..13,967.71 rows=756,771 width=16) (actual time=252.435..252.435 rows=756,771 loops=1)

  • Buckets: 524288 Batches: 4 Memory Usage: 12965kB
54. 122.663 122.663 ↑ 1.0 756,771 1

Seq Scan on d_podmienkapomocidokumentzonfp podmienkyp7_ (cost=0.00..13,967.71 rows=756,771 width=16) (actual time=0.035..122.663 rows=756,771 loops=1)

55. 4.550 8.161 ↑ 1.0 38,915 1

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

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

  • Heap Fetches: 0
Planning time : 11.335 ms
Execution time : 20,213.343 ms