explain.depesz.com

PostgreSQL's explain analyze made readable

Result: f2KW

Settings
# exclusive inclusive rows x rows loops node
1. 22.057 343.124 ↑ 1.0 80,899 1

Hash Left Join (cost=6,324.70..15,178.40 rows=82,978 width=440) (actual time=57.346..343.124 rows=80,899 loops=1)

  • Hash Cond: ((gece.sirketid = pans.sirketid) AND (gece.pansiyonid = pans.id))
2. 20.213 321.055 ↑ 1.0 80,899 1

Hash Left Join (cost=6,323.59..14,614.78 rows=82,978 width=380) (actual time=57.327..321.055 rows=80,899 loops=1)

  • Hash Cond: ((gece.sirketid = fiykonum.sirketid) AND (gece.fiyatkonumid = fiykonum.id))
3. 19.722 300.827 ↑ 1.0 80,899 1

Hash Left Join (cost=6,322.37..14,114.41 rows=82,978 width=316) (actual time=57.306..300.827 rows=80,899 loops=1)

  • Hash Cond: ((gece.sirketid = acen.sirketid) AND (gece.acentaid = acen.id))
4. 19.670 281.066 ↑ 1.0 80,899 1

Hash Left Join (cost=6,317.40..13,664.40 rows=82,978 width=301) (actual time=57.261..281.066 rows=80,899 loops=1)

  • Hash Cond: ((gece.sirketid = konum.sirketid) AND (gece.odakonumid = konum.id))
5. 19.403 261.380 ↑ 1.0 80,899 1

Hash Left Join (cost=6,316.19..13,164.02 rows=82,978 width=237) (actual time=57.193..261.380 rows=80,899 loops=1)

  • Hash Cond: ((gece.sirketid = oda.sirketid) AND (gece.odaid = oda.id))
6. 18.934 241.824 ↑ 1.0 80,899 1

Hash Left Join (cost=6,293.39..12,704.39 rows=82,978 width=232) (actual time=57.036..241.824 rows=80,899 loops=1)

  • Hash Cond: ((gece.sirketid = odeme.sirketid) AND (geceek.odemeid = odeme.id))
7. 18.289 222.882 ↑ 1.0 80,899 1

Hash Left Join (cost=6,292.31..12,065.10 rows=82,978 width=168) (actual time=57.023..222.882 rows=80,899 loops=1)

  • Hash Cond: ((gece.sirketid = pazar.sirketid) AND (geceek.pazarid = pazar.id))
8. 19.272 204.570 ↑ 1.0 80,899 1

Hash Left Join (cost=6,290.67..11,607.57 rows=82,978 width=104) (actual time=56.996..204.570 rows=80,899 loops=1)

  • Hash Cond: ((rez.sirketid = ulke.sirketid) AND (rezek.ulkeid = ulke.id))
9. 22.213 185.248 ↑ 1.0 80,899 1

Hash Left Join (cost=6,284.69..11,158.94 rows=82,978 width=96) (actual time=56.939..185.248 rows=80,899 loops=1)

  • Hash Cond: (rez.id = rezek.id)
10. 27.002 160.333 ↑ 1.0 80,899 1

Hash Join (cost=5,888.65..10,545.01 rows=82,978 width=92) (actual time=54.181..160.333 rows=80,899 loops=1)

  • Hash Cond: (gece.rezid = rez.id)
  • Join Filter: (gece.gun <> rez.couttarih)
  • Rows Removed by Join Filter: 10,656
11. 67.681 130.477 ↑ 1.0 91,733 1

Hash Right Join (cost=5,483.31..9,897.22 rows=92,319 width=80) (actual time=51.268..130.477 rows=91,733 loops=1)

  • Hash Cond: (geceek.id = gece.id)
12. 12.480 12.480 ↑ 1.0 111,992 1

Seq Scan on gecelemedetayek geceek (cost=0.00..1,943.92 rows=111,992 width=12) (actual time=0.014..12.480 rows=111,992 loops=1)

  • Filter: (NOT silinmis)
13. 27.790 50.316 ↑ 1.0 91,733 1

Hash (cost=3,247.32..3,247.32 rows=92,319 width=72) (actual time=50.316..50.316 rows=91,733 loops=1)

  • Buckets: 65,536 Batches: 4 Memory Usage: 2,896kB
14. 22.526 22.526 ↑ 1.0 91,733 1

Seq Scan on geceleme gece (cost=0.00..3,247.32 rows=92,319 width=72) (actual time=0.012..22.526 rows=91,733 loops=1)

  • Filter: ((NOT silinmis) AND (gun <> '1900-01-01 00:00:00'::timestamp without time zone) AND (sirketid = 1))
  • Rows Removed by Filter: 20,422
15. 1.243 2.854 ↑ 1.0 10,713 1

Hash (cost=271.43..271.43 rows=10,713 width=16) (actual time=2.854..2.854 rows=10,713 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 631kB
16. 1.611 1.611 ↑ 1.0 10,713 1

Seq Scan on rez (cost=0.00..271.43 rows=10,713 width=16) (actual time=0.015..1.611 rows=10,713 loops=1)

  • Filter: ((NOT silinmis) AND (sirketid = 1))
  • Rows Removed by Filter: 1,161
17. 1.212 2.702 ↑ 1.0 11,866 1

Hash (cost=247.71..247.71 rows=11,866 width=8) (actual time=2.701..2.702 rows=11,866 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 592kB
18. 1.490 1.490 ↑ 1.0 11,866 1

Seq Scan on rezdetayek rezek (cost=0.00..247.71 rows=11,866 width=8) (actual time=0.010..1.490 rows=11,866 loops=1)

  • Filter: (NOT silinmis)
  • Rows Removed by Filter: 5
19. 0.024 0.050 ↑ 1.0 145 1

Hash (cost=3.81..3.81 rows=145 width=20) (actual time=0.050..0.050 rows=145 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 16kB
20. 0.026 0.026 ↑ 1.0 145 1

Seq Scan on ulke (cost=0.00..3.81 rows=145 width=20) (actual time=0.009..0.026 rows=145 loops=1)

  • Filter: ((NOT silinmis) AND (sirketid = 1))
21. 0.010 0.023 ↓ 50.0 50 1

Hash (cost=1.63..1.63 rows=1 width=72) (actual time=0.023..0.023 rows=50 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
22. 0.013 0.013 ↓ 50.0 50 1

Seq Scan on pazar (cost=0.00..1.63 rows=1 width=72) (actual time=0.007..0.013 rows=50 loops=1)

  • Filter: ((NOT silinmis) AND (sirketid = 1))
23. 0.001 0.008 ↓ 5.0 5 1

Hash (cost=1.06..1.06 rows=1 width=72) (actual time=0.008..0.008 rows=5 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
24. 0.007 0.007 ↓ 5.0 5 1

Seq Scan on odeme (cost=0.00..1.06 rows=1 width=72) (actual time=0.006..0.007 rows=5 loops=1)

  • Filter: ((NOT silinmis) AND (sirketid = 1))
25. 0.062 0.153 ↑ 1.0 538 1

Hash (cost=14.73..14.73 rows=538 width=13) (actual time=0.153..0.153 rows=538 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 34kB
26. 0.091 0.091 ↑ 1.0 538 1

Seq Scan on oda (cost=0.00..14.73 rows=538 width=13) (actual time=0.007..0.091 rows=538 loops=1)

  • Filter: ((NOT silinmis) AND (sirketid = 1))
27. 0.007 0.016 ↓ 16.0 16 1

Hash (cost=1.20..1.20 rows=1 width=72) (actual time=0.016..0.016 rows=16 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
28. 0.009 0.009 ↓ 16.0 16 1

Seq Scan on odakonum konum (cost=0.00..1.20 rows=1 width=72) (actual time=0.007..0.009 rows=16 loops=1)

  • Filter: ((NOT silinmis) AND (sirketid = 1))
29. 0.018 0.039 ↑ 1.0 108 1

Hash (cost=3.35..3.35 rows=108 width=23) (actual time=0.039..0.039 rows=108 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 15kB
30. 0.021 0.021 ↑ 1.0 108 1

Seq Scan on acenta acen (cost=0.00..3.35 rows=108 width=23) (actual time=0.008..0.021 rows=108 loops=1)

  • Filter: ((NOT silinmis) AND (sirketid = 1))
31. 0.007 0.015 ↓ 16.0 16 1

Hash (cost=1.20..1.20 rows=1 width=72) (actual time=0.015..0.015 rows=16 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
32. 0.008 0.008 ↓ 16.0 16 1

Seq Scan on fiyatkonum fiykonum (cost=0.00..1.20 rows=1 width=72) (actual time=0.006..0.008 rows=16 loops=1)

  • Filter: ((NOT silinmis) AND (sirketid = 1))
33. 0.005 0.012 ↓ 8.0 8 1

Hash (cost=1.10..1.10 rows=1 width=72) (actual time=0.012..0.012 rows=8 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
34. 0.007 0.007 ↓ 8.0 8 1

Seq Scan on pansiyon pans (cost=0.00..1.10 rows=1 width=72) (actual time=0.006..0.007 rows=8 loops=1)

  • Filter: ((NOT silinmis) AND (sirketid = 1))
Planning time : 3.568 ms
Execution time : 345.437 ms