explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aoj5

Settings
# exclusive inclusive rows x rows loops node
1. 12.676 177.431 ↑ 1.1 915 1

Nested Loop Left Join (cost=1,051.21..21,142.36 rows=970 width=243) (actual time=29.338..177.431 rows=915 loops=1)

  • Join Filter: (gece.odakonumid = konum.id)
  • Rows Removed by Join Filter: 14640
2. 0.000 145.540 ↑ 1.1 915 1

Gather (cost=1,051.06..20,909.10 rows=970 width=183) (actual time=25.337..145.540 rows=915 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
3. 36.572 154.882 ↑ 1.2 458 2

Nested Loop Left Join (cost=51.05..19,812.10 rows=571 width=183) (actual time=19.175..154.882 rows=458 loops=2)

4. 2.614 118.233 ↑ 1.2 458 2

Nested Loop Left Join (cost=50.63..19,553.44 rows=571 width=167) (actual time=19.147..118.233 rows=458 loops=2)

  • Join Filter: (rez.sirketid = gecemus.sirketid)
5. 0.479 115.612 ↑ 1.1 210 2

Hash Left Join (cost=50.21..15,895.99 rows=235 width=159) (actual time=19.098..115.612 rows=210 loops=2)

  • Hash Cond: ((gece.acentaid = acen.id) AND (rez.sirketid = acen.sirketid))
6. 0.654 113.882 ↑ 1.1 210 2

Hash Left Join (cost=26.98..15,868.65 rows=235 width=141) (actual time=17.822..113.882 rows=210 loops=2)

  • Hash Cond: ((gece.odaid = oda.id) AND (rez.sirketid = oda.sirketid))
7. 39.118 111.763 ↑ 1.1 210 2

Nested Loop Left Join (cost=0.58..15,838.56 rows=235 width=136) (actual time=16.178..111.763 rows=210 loops=2)

8. 2.002 72.461 ↑ 1.1 210 2

Nested Loop (cost=0.29..15,755.66 rows=235 width=96) (actual time=14.163..72.461 rows=210 loops=2)

9. 70.453 70.453 ↑ 1.1 210 2

Parallel Seq Scan on geceleme gece (cost=0.00..14,182.92 rows=235 width=56) (actual time=14.100..70.453 rows=210 loops=2)

  • Filter: (gun = '2017-01-26 00:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 359776
10. 0.006 0.006 ↑ 1.0 1 420

Index Scan using PK_public.rez on rez (cost=0.29..6.68 rows=1 width=48) (actual time=0.005..0.006 rows=1 loops=420)

  • Index Cond: (id = gece.rezid)
  • Filter: (gece.sirketid = sirketid)
11. 0.184 0.184 ↑ 1.0 1 420

Index Scan using PK_public.voucher on voucher vouc (cost=0.29..0.34 rows=1 width=48) (actual time=0.183..0.184 rows=1 loops=420)

  • Index Cond: (rez.voucherid = id)
  • Filter: (rez.sirketid = sirketid)
12. 0.677 1.465 ↑ 1.0 736 2

Hash (cost=15.36..15.36 rows=736 width=13) (actual time=1.465..1.465 rows=736 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 43kB
13. 0.788 0.788 ↑ 1.0 736 2

Seq Scan on oda (cost=0.00..15.36 rows=736 width=13) (actual time=0.097..0.788 rows=736 loops=2)

14. 0.642 1.251 ↑ 1.0 649 2

Hash (cost=13.49..13.49 rows=649 width=26) (actual time=1.250..1.251 rows=649 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 47kB
15. 0.609 0.609 ↑ 1.0 649 2

Seq Scan on acenta acen (cost=0.00..13.49 rows=649 width=26) (actual time=0.020..0.609 rows=649 loops=2)

16. 0.007 0.007 ↑ 1.5 2 420

Index Scan using mamisil2 on gecelememusteri gecemus (cost=0.43..15.53 rows=3 width=16) (actual time=0.004..0.007 rows=2 loops=420)

  • Index Cond: (gece.id = gecelemeid)
17. 0.077 0.077 ↑ 1.0 1 915

Index Scan using PK_public.musteri on musteri mus (cost=0.42..0.44 rows=1 width=20) (actual time=0.076..0.077 rows=1 loops=915)

  • Index Cond: (gecemus.musteriid = id)
18. 19.215 19.215 ↓ 5.7 17 915

Index Scan using odakonum_SirketKod on odakonum konum (cost=0.15..0.20 rows=3 width=72) (actual time=0.007..0.021 rows=17 loops=915)

  • Index Cond: (rez.sirketid = sirketid)