explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LX5a : ddd

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 65.298 3,385.392 ↓ 122.5 245 1

Gather (cost=1,002.13..29,953.36 rows=2 width=243) (actual time=65.276..3,385.392 rows=245 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
2. 1.988 3,320.094 ↓ 122.0 122 2

Nested Loop Left Join (cost=2.13..28,953.16 rows=1 width=243) (actual time=54.939..3,320.094 rows=122 loops=2)

3. 1.581 3,318.096 ↓ 122.0 122 2

Nested Loop Left Join (cost=1.85..28,952.74 rows=1 width=225) (actual time=54.878..3,318.096 rows=122 loops=2)

4. 2.027 3,316.508 ↓ 122.0 122 2

Nested Loop Left Join (cost=1.71..28,952.44 rows=1 width=161) (actual time=54.857..3,316.508 rows=122 loops=2)

5. 3.409 3,314.471 ↓ 122.0 122 2

Nested Loop Left Join (cost=1.43..28,952.02 rows=1 width=156) (actual time=54.837..3,314.471 rows=122 loops=2)

6. 3,097.868 3,311.046 ↓ 122.0 122 2

Nested Loop Left Join (cost=1.01..28,951.57 rows=1 width=140) (actual time=54.788..3,311.046 rows=122 loops=2)

7. 1.080 156.351 ↓ 56.0 56 2

Nested Loop Left Join (cost=0.58..15,763.67 rows=1 width=132) (actual time=49.718..156.351 rows=56 loops=2)

8. 2.662 155.258 ↓ 56.0 56 2

Nested Loop (cost=0.29..15,756.24 rows=1 width=92) (actual time=49.691..155.258 rows=56 loops=2)

9. 152.587 152.587 ↑ 1.1 210 2

Parallel Seq Scan on geceleme gece (cost=0.00..14,182.92 rows=235 width=52) (actual time=49.596..152.587 rows=210 loops=2)

  • Filter: (gun = '2017-01-26 00:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 359776
10. 0.009 0.009 ↓ 0.0 0 420

Index Scan using PK_public.rez on rez (cost=0.29..6.68 rows=1 width=44) (actual time=0.008..0.009 rows=0 loops=420)

  • Index Cond: (id = gece.rezid)
  • Filter: ((NOT silinmis) AND (sirketid = 1) AND (cintarih = '2017-01-26 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 1
11. 0.013 0.013 ↑ 1.0 1 111

Index Scan using PK_public.voucher on voucher vouc (cost=0.29..7.42 rows=1 width=44) (actual time=0.010..0.013 rows=1 loops=111)

  • Index Cond: (rez.voucherid = id)
12. 56.827 56.827 ↑ 1.5 2 111

Index Only Scan using gecelememusteri_SirketKod on gecelememusteri gecemus (cost=0.43..13,187.87 rows=3 width=12) (actual time=4.738..56.827 rows=2 loops=111)

  • Index Cond: (gecelemeid = gece.id)
  • Heap Fetches: 130
13. 0.016 0.016 ↑ 1.0 1 245

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

  • Index Cond: (gecemus.musteriid = id)
14. 0.010 0.010 ↑ 1.0 1 245

Index Scan using PK_public.oda on oda (cost=0.28..0.41 rows=1 width=9) (actual time=0.009..0.010 rows=1 loops=245)

  • Index Cond: (gece.odaid = id)
15. 0.007 0.007 ↑ 1.0 1 245

Index Scan using PK_public.odakonum on odakonum konum (cost=0.15..0.29 rows=1 width=68) (actual time=0.006..0.007 rows=1 loops=245)

  • Index Cond: (gece.odakonumid = id)
16. 0.010 0.010 ↑ 1.0 1 245

Index Scan using PK_public.acenta on acenta acen (cost=0.28..0.41 rows=1 width=22) (actual time=0.009..0.010 rows=1 loops=245)

  • Index Cond: (gece.acentaid = id)