explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sRI

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=5.22..200,449.08 rows=20 width=400) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=5.22..199,970.95 rows=20 width=403) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=5.22..199,898.23 rows=17 width=371) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=5.22..199,828.40 rows=17 width=362) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=5.22..199,758.57 rows=17 width=353) (actual rows= loops=)

  • Join Filter: (seatl.altdcode = CASE WHEN (blk.wtsareaidx = 1) THEN prf.wtsarea1 WHEN (blk.wtsareaidx = 2) THEN prf.wtsarea2 WHEN (blk.wtsareaidx = 3) THEN prf.wtsarea3 WHEN (blk.wtsareaidx = 4) THEN prf.wtsarea4 WHEN (blk.wtsareai (...)
6. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=5.22..199,688.49 rows=17 width=367) (actual rows= loops=)

  • Join Filter: ((seatl.altdcode)::text = (st.wtsstdescidx)::text)
7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=5.22..199,248.12 rows=17 width=354) (actual rows= loops=)

  • Join Filter: (prf.venuecode = (vn.btx_venue_id)::bpchar)
8. 0.000 0.000 ↓ 0.0

Seq Scan on venue_text vn (cost=0.00..124.02 rows=712 width=27) (actual rows= loops=)

  • Filter: (lang = 'tr'::text)
9. 0.000 0.000 ↓ 0.0

Materialize (cost=5.22..198,988.86 rows=19 width=330) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Nested Loop (cost=5.22..198,988.77 rows=19 width=330) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=5.22..198,959.21 rows=7 width=230) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Nested Loop (cost=5.22..198,936.33 rows=7 width=216) (actual rows= loops=)

  • Join Filter: (st.wtsblock = blk.wtsblockcode)
13. 0.000 0.000 ↓ 0.0

Nested Loop (cost=5.22..198,823.44 rows=26 width=160) (actual rows= loops=)

  • Join Filter: (NOT (SubPlan 1))
14. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=5.22..67.32 rows=2 width=121) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Nested Loop (cost=5.22..58.28 rows=2 width=62) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Nested Loop (cost=5.22..43.12 rows=2 width=67) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Nested Loop (cost=5.21..34.58 rows=2 width=62) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=5.21..25.67 rows=2 width=48) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on nzrecs nz (cost=5.21..9.23 rows=2 width=44) (actual rows= loops=)

  • Recheck Cond: (wtstseq = ANY ('{12671225,12671226}'::integer[]))
20. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "PKWTSTSEQ" (cost=0.00..5.21 rows=2 width=0) (actual rows= loops=)

  • Index Cond: (wtstseq = ANY ('{12671225,12671226}'::integer[]))
21. 0.000 0.000 ↓ 0.0

Index Scan using wtsfeediscidx on feesdiscounts fees (cost=0.00..8.21 rows=2 width=8) (actual rows= loops=)

  • Index Cond: (wtstseq = nz.wtstseq)
  • Filter: (wtscode = ANY ('{TT,TL}'::bpchar[]))
22. 0.000 0.000 ↓ 0.0

Index Scan using customer_pkey on customer cus (cost=0.00..4.45 rows=1 width=22) (actual rows= loops=)

  • Index Cond: (id = nz.wtsclientid)
23. 0.000 0.000 ↓ 0.0

Index Scan using event_pkey on event ev (cost=0.00..4.26 rows=1 width=5) (actual rows= loops=)

  • Index Cond: ((id)::text = (nz.wtsevent)::text)
24. 0.000 0.000 ↓ 0.0

Index Scan using event_text_btx_event_id_idx on event_text evt (cost=0.00..7.57 rows=1 width=6) (actual rows= loops=)

  • Index Cond: ((btx_event_id)::text = (ev.id)::text)
  • Filter: (lang = 'tr'::text)
25. 0.000 0.000 ↓ 0.0

Index Scan using wtsnmaddpidx on nmrecs nm (cost=0.00..4.51 rows=1 width=63) (actual rows= loops=)

  • Index Cond: (wtsclientid = nz.wtsclientid)
26. 0.000 0.000 ↓ 0.0

Index Scan using wtsseatinfoidx on seatinfo st (cost=0.00..615.99 rows=316 width=47) (actual rows= loops=)

  • Index Cond: (wtstseq = nz.wtstseq)
27.          

SubPlan (forNested Loop)

28. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..624.99 rows=27 width=21) (actual rows= loops=)

29. 0.000 0.000 ↓ 0.0

Index Scan using wtsxtillidx on nzrecs w (cost=0.00..6.95 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (wtsxtill = nz.wtsxtill)
  • Filter: (wtsprtmeth = 'v'::bpchar)
30. 0.000 0.000 ↓ 0.0

Index Scan using wtsseatinfoidx on seatinfo q (cost=0.00..615.66 rows=316 width=25) (actual rows= loops=)

  • Index Cond: (wtstseq = w.wtstseq)
31. 0.000 0.000 ↓ 0.0

Index Scan using wtsblockrecidx on wtsblockrec blk (cost=0.00..4.33 rows=1 width=56) (actual rows= loops=)

  • Index Cond: ((wtsevent = nz.wtsevent) AND (wtsperf = nz.wtsperf))
32. 0.000 0.000 ↓ 0.0

Index Scan using wtscnsidx on wtscnsrec cnsdesc (cost=0.00..3.26 rows=1 width=17) (actual rows= loops=)

  • Index Cond: (wtscnscd = st.wtscnscd)
33. 0.000 0.000 ↓ 0.0

Index Scan using wtsevtpfidx on wtsperfrec prf (cost=0.00..4.21 rows=1 width=120) (actual rows= loops=)

  • Index Cond: ((wtsevent = nz.wtsevent) AND (wtsperf = nz.wtsperf))
34. 0.000 0.000 ↓ 0.0

Index Scan using altd_pkey on altd seatl (cost=0.00..25.62 rows=16 width=18) (actual rows= loops=)

  • Index Cond: ((wtstype = 115) AND (venuecode = prf.venuecode))
35. 0.000 0.000 ↓ 0.0

Index Scan using altd_pkey on altd areadesc (cost=0.00..4.09 rows=1 width=15) (actual rows= loops=)

  • Index Cond: ((wtstype = 97) AND (venuecode = prf.venuecode))
36. 0.000 0.000 ↓ 0.0

Index Scan using altd_pkey on altd turn (cost=0.00..4.10 rows=1 width=18) (actual rows= loops=)

  • Index Cond: ((wtstype = 116) AND (venuecode = prf.venuecode) AND (altdcode = blk.wtststyle))
37. 0.000 0.000 ↓ 0.0

Index Scan using altd_pkey on altd doorleft (cost=0.00..4.10 rows=1 width=18) (actual rows= loops=)

  • Index Cond: ((wtstype = 100) AND (venuecode = prf.venuecode) AND (altdcode = blk.wtsdoorleft))
38. 0.000 0.000 ↓ 0.0

Index Scan using wtstickdescidx on wtstickdescrec tdesc (cost=0.00..4.27 rows=1 width=42) (actual rows= loops=)

  • Index Cond: ((wtsevent = nz.wtsevent) AND (wtsperf = nz.wtsperf))
39. 0.000 0.000 ↓ 0.0

Index Scan using altd_pkey on altd promvat (cost=0.00..23.64 rows=1 width=3) (actual rows= loops=)

  • Index Cond: ((wtstype = 86) AND (altdcode = prf.wtspromoter))