explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yMtu : Optimization for: plan #r1Fw

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 1.318 2.476 ↑ 1.0 1 1

Nested Loop Left Join (cost=21.78..197.34 rows=1 width=304) (actual time=2.457..2.476 rows=1 loops=1)

  • Join Filter: (aa.id_autor = a_email.id_autor)
2. 0.004 0.236 ↑ 1.0 1 1

Nested Loop Left Join (cost=21.78..32.70 rows=1 width=298) (actual time=0.218..0.236 rows=1 loops=1)

  • Join Filter: (aa.id_stanowiska = st.id_stanowiska)
  • Rows Removed by Join Filter: 18
3. 0.007 0.228 ↑ 1.0 1 1

Nested Loop Left Join (cost=21.78..31.27 rows=1 width=283) (actual time=0.213..0.228 rows=1 loops=1)

  • Join Filter: (aa.id_tytnauk = tn.id_tytnauk)
  • Rows Removed by Join Filter: 19
4. 0.004 0.218 ↑ 1.0 1 1

Nested Loop Left Join (cost=21.78..29.82 rows=1 width=272) (actual time=0.205..0.218 rows=1 loops=1)

5. 0.004 0.212 ↑ 1.0 1 1

Nested Loop Left Join (cost=21.64..29.60 rows=1 width=237) (actual time=0.201..0.212 rows=1 loops=1)

  • Join Filter: (aa.id_autor = apol.id_autor)
6. 0.058 0.096 ↑ 1.0 1 1

Hash Right Join (cost=8.32..14.62 rows=1 width=132) (actual time=0.088..0.096 rows=1 loops=1)

  • Hash Cond: (uj.id_jednagh = aa.id_jednagh)
7. 0.022 0.022 ↑ 1.0 239 1

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

8. 0.005 0.016 ↑ 1.0 1 1

Hash (cost=8.31..8.31 rows=1 width=84) (actual time=0.015..0.016 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
9. 0.011 0.011 ↑ 1.0 1 1

Index Scan using a_autorzy_pkey on a_autorzy aa (cost=0.29..8.31 rows=1 width=84) (actual time=0.010..0.011 rows=1 loops=1)

  • Index Cond: (id_autor = 1111)
10. 0.020 0.112 ↑ 1.0 1 1

Hash Right Join (cost=13.32..14.97 rows=1 width=109) (actual time=0.109..0.112 rows=1 loops=1)

  • Hash Cond: (dy2n.id_dyscyplina2 = apol.dy_n2)
11. 0.004 0.004 ↑ 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.004 rows=47 loops=1)

12. 0.004 0.088 ↑ 1.0 1 1

Hash (cost=13.30..13.30 rows=1 width=90) (actual time=0.088..0.088 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
13. 0.019 0.084 ↑ 1.0 1 1

Hash Right Join (cost=11.65..13.30 rows=1 width=90) (actual time=0.076..0.084 rows=1 loops=1)

  • Hash Cond: (dy1n.id_dyscyplina2 = apol.dy_n)
14. 0.002 0.002 ↑ 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.002 rows=47 loops=1)

15. 0.003 0.063 ↑ 1.0 1 1

Hash (cost=11.63..11.63 rows=1 width=71) (actual time=0.063..0.063 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
16. 0.015 0.060 ↑ 1.0 1 1

Hash Right Join (cost=9.98..11.63 rows=1 width=71) (actual time=0.058..0.060 rows=1 loops=1)

  • Hash Cond: (dy_dod.id_dyscyplina2 = apol.id_u2_dyscyplina_dodatkowa)
17. 0.005 0.005 ↑ 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.005 rows=47 loops=1)

18. 0.004 0.040 ↑ 1.0 1 1

Hash (cost=9.97..9.97 rows=1 width=52) (actual time=0.040..0.040 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
19. 0.020 0.036 ↑ 1.0 1 1

Hash Right Join (cost=8.31..9.97 rows=1 width=52) (actual time=0.025..0.036 rows=1 loops=1)

  • Hash Cond: (dy_wio.id_dyscyplina2 = apol.id_u2_dyscyplina_wiodaca)
20. 0.004 0.004 ↑ 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.004 rows=47 loops=1)

21. 0.003 0.012 ↑ 1.0 1 1

Hash (cost=8.30..8.30 rows=1 width=33) (actual time=0.012..0.012 rows=1 loops=1)

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

Index Scan using a_autor_u2_dyscyplina_4polon_pk on a_autor_u2_dyscyplina_4polon apol (cost=0.28..8.30 rows=1 width=33) (actual time=0.008..0.009 rows=1 loops=1)

  • Index Cond: (id_autor = 1111)
23. 0.002 0.002 ↑ 1.0 1 1

Index Scan using u_wydzialy_pkey on u_wydzialy uw (cost=0.14..0.21 rows=1 width=39) (actual time=0.002..0.002 rows=1 loops=1)

  • Index Cond: (uj.id_wydz = id_wydz)
24. 0.003 0.003 ↑ 1.0 20 1

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

25. 0.004 0.004 ↑ 1.0 19 1

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

26. 0.006 0.922 ↑ 1.0 1 1

GroupAggregate (cost=0.00..164.12 rows=1 width=36) (actual time=0.922..0.922 rows=1 loops=1)

  • Group Key: a_email.id_autor
27. 0.916 0.916 ↑ 1.0 1 1

Seq Scan on a_email (cost=0.00..164.10 rows=1 width=26) (actual time=0.498..0.916 rows=1 loops=1)

  • Filter: (id_autor = 1111)
  • Rows Removed by Filter: 8407
Planning time : 2.087 ms
Execution time : 2.721 ms