explain.depesz.com

PostgreSQL's explain analyze made readable

Result: r1Fw

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 26.354 14,174.881 ↑ 1.0 2,184 1

Hash Semi Join (cost=4,441.38..27,374.12 rows=2,184 width=304) (actual time=50.556..14,174.881 rows=2,184 loops=1)

  • Hash Cond: (aa.id_autor = a_autor_u2_dyscyplina_4polon.id_autor)
2. 14,024.902 14,147.786 ↑ 1.0 39,779 1

Hash Left Join (cost=4,358.24..26,764.47 rows=39,779 width=304) (actual time=49.786..14,147.786 rows=39,779 loops=1)

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

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

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

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

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

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

6. 4.660 10.341 ↑ 1.0 7,305 1

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

  • Group Key: a_email.id_autor
7. 4.963 5.681 ↑ 1.0 8,408 1

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

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

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

9. 14.938 44.775 ↑ 1.0 39,779 1

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

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

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

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

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

  • Hash Cond: (aa.id_autor = apol.id_autor)
12. 3.105 3.105 ↑ 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.105 rows=39,779 loops=1)

13. 0.633 3.101 ↑ 1.0 2,184 1

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

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

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

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

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

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

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

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

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

  • Hash Cond: (apol.id_u2_dyscyplina_wiodaca = dy_wio.id_dyscyplina2)
18. 0.218 0.218 ↑ 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.002..0.218 rows=2,184 loops=1)

19. 0.035 0.044 ↑ 1.0 47 1

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

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

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

21. 0.014 0.021 ↑ 1.0 47 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
22. 0.007 0.007 ↑ 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.007 rows=47 loops=1)

23. 0.011 0.019 ↑ 1.0 47 1

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

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

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

25. 0.013 0.018 ↑ 1.0 47 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
26. 0.005 0.005 ↑ 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.005 rows=47 loops=1)

27. 0.076 0.182 ↑ 1.0 239 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 37kB
28. 0.075 0.106 ↑ 1.0 239 1

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

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

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

30. 0.005 0.015 ↑ 1.0 34 1

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

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

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

32. 0.005 0.014 ↑ 1.0 20 1

Hash (cost=1.20..1.20 rows=20 width=15) (actual time=0.014..0.014 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.006..0.009 rows=20 loops=1)

34. 0.004 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.008 0.008 ↑ 1.0 19 1

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

36. 0.366 0.741 ↑ 1.0 2,184 1

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

  • Buckets: 4096 Batches: 1 Memory Usage: 109kB
37. 0.375 0.375 ↑ 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.375 rows=2,184 loops=1)

Planning time : 2.522 ms
Execution time : 14,175.790 ms