explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tqZ1

Settings
# exclusive inclusive rows x rows loops node
1. 20.429 23,682.867 ↑ 1.0 1 1

Aggregate (cost=514,884.67..514,884.68 rows=1 width=8) (actual time=23,682.867..23,682.867 rows=1 loops=1)

2. 6.967 23,662.438 ↓ 12.9 34,615 1

Merge Semi Join (cost=514,667.48..514,877.94 rows=2,693 width=8) (actual time=23,638.195..23,662.438 rows=34,615 loops=1)

  • Merge Cond: (specificke2_.specifickyciel_id = vizibilita12_.specifickyciel_id)
3. 13.365 23,654.672 ↓ 3.2 34,615 1

Merge Join (cost=514,657.58..514,827.89 rows=10,903 width=24) (actual time=23,637.419..23,654.672 rows=34,615 loops=1)

  • Merge Cond: (specificke2_.specifickyciel_id = specificky3_.id)
4. 12.247 23,641.160 ↓ 3.2 34,615 1

Sort (cost=514,657.43..514,684.69 rows=10,903 width=16) (actual time=23,637.333..23,641.160 rows=34,615 loops=1)

  • Sort Key: specificke2_.specifickyciel_id
  • Sort Method: quicksort Memory: 3159kB
5. 14.357 23,628.913 ↓ 3.2 34,615 1

Hash Join (cost=512,964.42..513,926.25 rows=10,903 width=16) (actual time=23,589.302..23,628.913 rows=34,615 loops=1)

  • Hash Cond: (zonfpverzia.id = zonfpverzi1_.id)
6. 12.232 278.096 ↑ 1.0 17,856 1

Hash Join (cost=32,775.05..33,559.63 rows=17,971 width=32) (actual time=252.728..278.096 rows=17,856 loops=1)

  • Hash Cond: (zonfpverzia.id = specificke2_.zonfpverzia_id)
7. 28.527 257.631 ↑ 1.0 17,282 1

HashAggregate (cost=31,653.41..31,869.43 rows=17,282 width=632) (actual time=244.078..257.631 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
8. 27.675 229.104 ↑ 1.0 17,282 1

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

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

10. 9.976 195.012 ↑ 1.0 17,282 1

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

  • Buckets: 32768 Batches: 1 Memory Usage: 5313kB
11. 3.527 185.036 ↑ 1.0 17,282 1

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

  • Hash Cond: (workflowst7_.workflowprechod_id = workflowpr9_.id)
12. 4.488 181.197 ↑ 1.0 17,282 1

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

  • Hash Cond: (stav.faza_id = faza.id)
13. 4.520 176.644 ↑ 1.0 17,282 1

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

  • Hash Cond: (workflowst8_.stav_id = stav.id)
14. 4.737 172.035 ↑ 1.0 17,282 1

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

  • Hash Cond: (workflowst7_.workflowstav_id = workflowst8_.id)
15. 26.745 167.166 ↑ 1.0 17,282 1

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

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

17. 8.487 133.468 ↑ 1.0 17,282 1

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

  • Buckets: 32768 Batches: 1 Memory Usage: 4962kB
18. 29.591 124.981 ↑ 1.0 17,282 1

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

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

20. 8.747 85.413 ↑ 1.0 17,282 1

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

  • Buckets: 32768 Batches: 1 Memory Usage: 4820kB
21. 5.147 76.666 ↑ 1.0 17,282 1

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

  • Hash Cond: (projekt.aktualnaverzia_id = projektverzia.id)
22. 5.211 66.063 ↑ 1.0 17,282 1

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

  • Hash Cond: (zonfp.projekt_id = projekt.id)
23. 3.663 58.708 ↑ 1.0 17,282 1

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

  • Hash Cond: (vyzvaverzia.vyhlasovatel_id = oif.id)
24. 4.199 54.972 ↑ 1.0 17,282 1

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

  • Hash Cond: (zonfpverzia.vyzvaverzia_id = vyzvaverzia.id)
25. 7.157 49.720 ↑ 1.0 17,282 1

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

  • Hash Cond: (zonfpverzia.ziadatel_id = subjekt.id)
26. 16.294 27.196 ↑ 1.0 17,282 1

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

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

28. 2.400 5.038 ↑ 1.0 17,282 1

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

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

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

30. 2.562 15.367 ↑ 1.0 14,643 1

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

  • Buckets: 16384 Batches: 1 Memory Usage: 1194kB
31. 7.131 12.805 ↑ 1.0 14,643 1

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

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

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

33. 2.012 4.161 ↑ 1.0 14,643 1

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

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

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

35. 0.253 1.053 ↑ 1.0 1,894 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 105kB
36. 0.800 0.800 ↑ 1.0 1,894 1

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

37. 0.034 0.073 ↑ 1.0 211 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 25kB
38. 0.039 0.039 ↑ 1.0 211 1

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

39. 0.994 2.144 ↑ 1.0 8,552 1

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

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

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

41. 2.256 5.456 ↑ 1.0 8,559 1

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

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

43. 0.064 0.132 ↑ 1.0 517 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 37kB
44. 0.068 0.068 ↑ 1.0 517 1

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

45. 0.042 0.089 ↑ 1.0 304 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 30kB
46. 0.047 0.047 ↑ 1.0 304 1

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

47. 0.028 0.065 ↑ 1.0 229 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
48. 0.037 0.037 ↑ 1.0 229 1

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

49. 0.165 0.312 ↑ 1.0 1,219 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 133kB
50. 0.147 0.147 ↑ 1.0 1,219 1

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

51. 4.648 8.233 ↑ 1.0 40,162 1

Hash (cost=619.62..619.62 rows=40,162 width=16) (actual time=8.233..8.233 rows=40,162 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2395kB
52. 3.585 3.585 ↑ 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.141..3.585 rows=40,162 loops=1)

53. 29.283 23,336.460 ↓ 2.9 69,949 1

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

  • Buckets: 131072 (originally 32768) Batches: 1 (originally 1) Memory Usage: 3757kB
54. 16,799.079 23,307.177 ↓ 2.9 69,949 1

Hash Right Join (cost=28,314.56..479,892.01 rows=23,789 width=8) (actual time=257.505..23,307.177 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
55. 1,443.007 6,501.480 ↓ 1.0 1,768,194 1

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

  • Hash Cond: (dokumenty8_.podmienkapomocidokumentzonfp_id = podmienkyp7_.id)
56. 1,066.146 4,810.279 ↑ 1.0 1,739,340 1

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

  • Merge Cond: (dokumenty8_.dokument_id = dokument9_.id)
57. 414.536 414.536 ↑ 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.029..414.536 rows=1,739,340 loops=1)

58. 3,329.597 3,329.597 ↓ 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.007..3,329.597 rows=7,807,009 loops=1)

59. 127.146 248.194 ↑ 1.0 756,771 1

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

  • Buckets: 524288 Batches: 4 Memory Usage: 12965kB
60. 121.048 121.048 ↑ 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.041..121.048 rows=756,771 loops=1)

61. 3.956 6.618 ↑ 1.0 38,915 1

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

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

  • Heap Fetches: 0
63. 0.147 0.147 ↑ 1.0 252 1

Index Only Scan using d_specifickyciel_pkey on d_specifickyciel specificky3_ (cost=0.15..6.26 rows=261 width=8) (actual time=0.081..0.147 rows=252 loops=1)

  • Heap Fetches: 0
64. 0.092 0.799 ↓ 9.7 252 1

Sort (cost=9.90..9.97 rows=26 width=16) (actual time=0.773..0.799 rows=252 loops=1)

  • Sort Key: vizibilita12_.specifickyciel_id
  • Sort Method: quicksort Memory: 37kB
65. 0.164 0.707 ↓ 10.0 260 1

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

66. 0.069 0.283 ↓ 10.0 260 1

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

  • Join Filter: (zaradeniez10_.organ_id = vizibilita12_.organ_id)
67. 0.002 0.103 ↑ 1.0 1 1

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

68. 0.066 0.066 ↑ 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.064..0.066 rows=1 loops=1)

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

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

  • Index Cond: (organ_id = organimple11_.id)
  • Heap Fetches: 0
71. 0.260 0.260 ↑ 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.001..0.001 rows=1 loops=260)

  • Index Cond: (id = vizibilita12_.specifickyciel_id)
  • Heap Fetches: 0
Planning time : 12.517 ms
Execution time : 23,696.508 ms