explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yTB5

Settings
# exclusive inclusive rows x rows loops node
1. 22.716 13,978.171 ↑ 1.0 2,184 1

Hash Semi Join (cost=4,441.38..27,374.12 rows=2,184 width=304) (actual time=55.840..13,978.171 rows=2,184 loops=1)

  • Hash Cond: (aa.id_autor = a_autor_u2_dyscyplina_4polon.id_autor)
2. 13,826.307 13,954.702 ↑ 1.0 39,779 1

Hash Left Join (cost=4,358.24..26,764.47 rows=39,779 width=304) (actual time=55.052..13,954.702 rows=39,779 loops=1)

  • Hash Cond: (aa.id_stanowiska = st.id_stanowiska)
3. 19.293 128.383 ↑ 1.0 39,779 1

Hash Left Join (cost=4,356.82..6,456.89 rows=39,779 width=315) (actual time=53.783..128.383 rows=39,779 loops=1)

  • Hash Cond: (aa.id_tytnauk = tn.id_tytnauk)
4. 46.925 109.074 ↑ 1.0 39,779 1

Hash Right Join (cost=4,355.37..6,237.23 rows=39,779 width=304) (actual time=53.754..109.074 rows=39,779 loops=1)

  • Hash Cond: (em.id_autor = aa.id_autor)
5. 1.374 12.097 ↑ 1.0 7,305 1

Subquery Scan on em (cost=691.18..918.60 rows=7,305 width=36) (actual time=3.512..12.097 rows=7,305 loops=1)

6. 4.758 10.723 ↑ 1.0 7,305 1

GroupAggregate (cost=691.18..845.55 rows=7,305 width=36) (actual time=3.510..10.723 rows=7,305 loops=1)

  • Group Key: a_email.id_autor
7. 5.316 5.965 ↑ 1.0 8,408 1

Sort (cost=691.18..712.20 rows=8,408 width=26) (actual time=3.494..5.965 rows=8,408 loops=1)

  • Sort Key: a_email.id_autor
  • Sort Method: quicksort Memory: 1041kB
8. 0.649 0.649 ↑ 1.0 8,408 1

Seq Scan on a_email (cost=0.00..143.08 rows=8,408 width=26) (actual time=0.012..0.649 rows=8,408 loops=1)

9. 17.163 50.052 ↑ 1.0 39,779 1

Hash (cost=1,728.95..1,728.95 rows=39,779 width=272) (actual time=50.052..50.052 rows=39,779 loops=1)

  • Buckets: 16384 Batches: 4 Memory Usage: 1140kB
10. 11.927 32.889 ↑ 1.0 39,779 1

Hash Left Join (cost=182.22..1,728.95 rows=39,779 width=272) (actual time=3.396..32.889 rows=39,779 loops=1)

  • Hash Cond: (aa.id_jednagh = uj.id_jednagh)
11. 13.913 20.753 ↑ 1.0 39,779 1

Hash Left Join (cost=168.82..1,168.62 rows=39,779 width=189) (actual time=3.161..20.753 rows=39,779 loops=1)

  • Hash Cond: (aa.id_autor = apol.id_autor)
12. 3.713 3.713 ↑ 1.0 39,779 1

Seq Scan on a_autorzy aa (cost=0.00..828.79 rows=39,779 width=84) (actual time=0.004..3.713 rows=39,779 loops=1)

13. 0.691 3.127 ↑ 1.0 2,184 1

Hash (cost=141.52..141.52 rows=2,184 width=109) (actual time=3.127..3.127 rows=2,184 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 271kB
14. 0.501 2.436 ↑ 1.0 2,184 1

Hash Left Join (cost=8.23..141.52 rows=2,184 width=109) (actual time=0.142..2.436 rows=2,184 loops=1)

  • Hash Cond: (apol.dy_n2 = dy2n.id_dyscyplina2)
15. 0.576 1.906 ↑ 1.0 2,184 1

Hash Left Join (cost=6.17..128.03 rows=2,184 width=90) (actual time=0.103..1.906 rows=2,184 loops=1)

  • Hash Cond: (apol.dy_n = dy1n.id_dyscyplina2)
16. 0.380 1.311 ↑ 1.0 2,184 1

Hash Left Join (cost=4.12..102.27 rows=2,184 width=71) (actual time=0.074..1.311 rows=2,184 loops=1)

  • Hash Cond: (apol.id_u2_dyscyplina_dodatkowa = dy_dod.id_dyscyplina2)
17. 0.697 0.911 ↑ 1.0 2,184 1

Hash Left Join (cost=2.06..87.93 rows=2,184 width=52) (actual time=0.043..0.911 rows=2,184 loops=1)

  • Hash Cond: (apol.id_u2_dyscyplina_wiodaca = dy_wio.id_dyscyplina2)
18. 0.192 0.192 ↑ 1.0 2,184 1

Seq Scan on a_autor_u2_dyscyplina_4polon apol (cost=0.00..55.84 rows=2,184 width=33) (actual time=0.003..0.192 rows=2,184 loops=1)

19. 0.010 0.022 ↑ 1.0 47 1

Hash (cost=1.47..1.47 rows=47 width=27) (actual time=0.022..0.022 rows=47 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
20. 0.012 0.012 ↑ 1.0 47 1

Seq Scan on n_u2_dyscypliny dy_wio (cost=0.00..1.47 rows=47 width=27) (actual time=0.003..0.012 rows=47 loops=1)

21. 0.011 0.020 ↑ 1.0 47 1

Hash (cost=1.47..1.47 rows=47 width=27) (actual time=0.020..0.020 rows=47 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
22. 0.009 0.009 ↑ 1.0 47 1

Seq Scan on n_u2_dyscypliny dy_dod (cost=0.00..1.47 rows=47 width=27) (actual time=0.002..0.009 rows=47 loops=1)

23. 0.014 0.019 ↑ 1.0 47 1

Hash (cost=1.47..1.47 rows=47 width=27) (actual time=0.018..0.019 rows=47 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
24. 0.005 0.005 ↑ 1.0 47 1

Seq Scan on n_u2_dyscypliny dy1n (cost=0.00..1.47 rows=47 width=27) (actual time=0.001..0.005 rows=47 loops=1)

25. 0.010 0.029 ↑ 1.0 47 1

Hash (cost=1.47..1.47 rows=47 width=27) (actual time=0.029..0.029 rows=47 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
26. 0.019 0.019 ↑ 1.0 47 1

Seq Scan on n_u2_dyscypliny dy2n (cost=0.00..1.47 rows=47 width=27) (actual time=0.001..0.019 rows=47 loops=1)

27. 0.071 0.209 ↑ 1.0 239 1

Hash (cost=10.41..10.41 rows=239 width=85) (actual time=0.209..0.209 rows=239 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 37kB
28. 0.085 0.138 ↑ 1.0 239 1

Hash Left Join (cost=1.77..10.41 rows=239 width=85) (actual time=0.042..0.138 rows=239 loops=1)

  • Hash Cond: (uj.id_wydz = uw.id_wydz)
29. 0.029 0.029 ↑ 1.0 239 1

Seq Scan on u_jednostki uj (cost=0.00..5.39 rows=239 width=50) (actual time=0.005..0.029 rows=239 loops=1)

30. 0.013 0.024 ↑ 1.0 34 1

Hash (cost=1.34..1.34 rows=34 width=39) (actual time=0.024..0.024 rows=34 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
31. 0.011 0.011 ↑ 1.0 34 1

Seq Scan on u_wydzialy uw (cost=0.00..1.34 rows=34 width=39) (actual time=0.008..0.011 rows=34 loops=1)

32. 0.007 0.016 ↑ 1.0 20 1

Hash (cost=1.20..1.20 rows=20 width=15) (actual time=0.016..0.016 rows=20 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
33. 0.009 0.009 ↑ 1.0 20 1

Seq Scan on a_tytulnaukowy tn (cost=0.00..1.20 rows=20 width=15) (actual time=0.007..0.009 rows=20 loops=1)

34. 0.005 0.012 ↑ 1.0 19 1

Hash (cost=1.19..1.19 rows=19 width=19) (actual time=0.012..0.012 rows=19 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
35. 0.007 0.007 ↑ 1.0 19 1

Seq Scan on a_stanowiska st (cost=0.00..1.19 rows=19 width=19) (actual time=0.004..0.007 rows=19 loops=1)

36. 0.365 0.753 ↑ 1.0 2,184 1

Hash (cost=55.84..55.84 rows=2,184 width=4) (actual time=0.753..0.753 rows=2,184 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 109kB
37. 0.388 0.388 ↑ 1.0 2,184 1

Seq Scan on a_autor_u2_dyscyplina_4polon (cost=0.00..55.84 rows=2,184 width=4) (actual time=0.010..0.388 rows=2,184 loops=1)

Planning time : 2.368 ms
Execution time : 13,979.015 ms