explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7VgT : Optimization for: Deneme; plan #wxQm

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 6.201 17.142 ↑ 1.1 384 1

Gather (cost=1,051.55..6,533.23 rows=441 width=139) (actual time=7.554..17.142 rows=384 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
2. 0.082 10.941 ↑ 1.3 192 2

Hash Left Join (cost=51.55..5,489.13 rows=259 width=139) (actual time=4.578..10.941 rows=192 loops=2)

  • Hash Cond: (oda.odakonumid = odakonum.id)
3. 0.086 10.839 ↑ 1.3 192 2

Hash Left Join (cost=50.17..5,486.90 rows=259 width=111) (actual time=4.548..10.839 rows=192 loops=2)

  • Hash Cond: (geceleme.odaid = oda.id)
4. 0.088 10.503 ↑ 1.3 192 2

Hash Left Join (cost=25.61..5,461.66 rows=259 width=106) (actual time=4.287..10.503 rows=192 loops=2)

  • Hash Cond: (geceleme.acentaid = acenta.id)
5. 1.740 10.169 ↑ 1.3 192 2

Nested Loop Left Join (cost=4.00..5,439.38 rows=259 width=97) (actual time=4.029..10.169 rows=192 loops=2)

6. 0.156 8.407 ↑ 1.4 78 2

Hash Left Join (cost=2.73..2,687.98 rows=107 width=37) (actual time=3.945..8.407 rows=78 loops=2)

  • Hash Cond: (rezdetayek.ulkeid = ulke.id)
7. 0.341 8.209 ↑ 1.4 78 2

Nested Loop Left Join (cost=0.29..2,685.24 rows=107 width=28) (actual time=3.780..8.209 rows=78 loops=2)

8. 7.864 7.864 ↑ 1.4 78 2

Parallel Seq Scan on rez (cost=0.00..1,930.11 rows=107 width=24) (actual time=3.748..7.864 rows=78 loops=2)

  • Filter: ((NOT silinmis) AND (cintarih = '2018-10-27 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 51011
9. 0.004 0.004 ↑ 1.0 1 155

Index Scan using ""rezdetayek_IX_id"" on rezdetayek (cost=0.29..7.06 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=155)

  • Index Cond: (id = rez.id)
10. 0.015 0.042 ↑ 1.0 64 2

Hash (cost=1.64..1.64 rows=64 width=13) (actual time=0.042..0.042 rows=64 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
11. 0.027 0.027 ↑ 1.0 64 2

Seq Scan on ulke (cost=0.00..1.64 rows=64 width=13) (actual time=0.018..0.027 rows=64 loops=2)

12. 0.006 0.022 ↑ 1.0 2 155

Nested Loop Left Join (cost=1.27..25.69 rows=2 width=64) (actual time=0.011..0.022 rows=2 loops=155)

13. 0.001 0.014 ↑ 1.0 2 155

Nested Loop Left Join (cost=0.85..24.81 rows=2 width=44) (actual time=0.008..0.014 rows=2 loops=155)

14. 0.009 0.009 ↑ 1.0 1 155

Index Scan using mamisil on geceleme (cost=0.42..9.44 rows=1 width=40) (actual time=0.004..0.009 rows=1 loops=155)

  • Index Cond: (rezid = rez.id)
  • Filter: ((gun = '2018-10-27 00:00:00'::timestamp without time zone) AND (gun = rez.cintarih))
  • Rows Removed by Filter: 5
15. 0.004 0.004 ↑ 1.5 2 155

Index Scan using mamisil2 on gecelememusteri (cost=0.43..15.34 rows=3 width=8) (actual time=0.003..0.004 rows=2 loops=155)

  • Index Cond: (gecelemeid = geceleme.id)
16. 0.002 0.002 ↑ 1.0 1 384

Index Scan using ""PK_public.musteri"" on musteri (cost=0.42..0.44 rows=1 width=28) (actual time=0.002..0.002 rows=1 loops=384)

  • Index Cond: (id = gecelememusteri.musteriid)
17. 0.124 0.246 ↑ 1.0 649 2

Hash (cost=13.49..13.49 rows=649 width=17) (actual time=0.246..0.246 rows=649 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 41kB
18. 0.122 0.122 ↑ 1.0 649 2

Seq Scan on acenta (cost=0.00..13.49 rows=649 width=17) (actual time=0.010..0.122 rows=649 loops=2)

19. 0.113 0.250 ↑ 1.0 736 2

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

  • Buckets: 1024 Batches: 1 Memory Usage: 43kB
20. 0.137 0.137 ↑ 1.0 736 2

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

21. 0.006 0.020 ↑ 1.0 17 2

Hash (cost=1.17..1.17 rows=17 width=36) (actual time=0.020..0.020 rows=17 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
22. 0.014 0.014 ↑ 1.0 17 2

Seq Scan on odakonum (cost=0.00..1.17 rows=17 width=36) (actual time=0.011..0.014 rows=17 loops=2)

Planning time : 2.281 ms