explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hZWT

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 6.862 ↑ 1.0 1 1

Limit (cost=0.00..856,201.71 rows=1 width=29) (actual time=6.861..6.862 rows=1 loops=1)

  • Output: s.wtsseatoffset, n.wtsxtseq, n.wtsxtill, s.wtsseatblob, s.wtstseq
  • Buffers: shared hit=2,318
2. 0.000 6.860 ↑ 1.0 1 1

Nested Loop (cost=0.00..856,201.71 rows=1 width=29) (actual time=6.860..6.860 rows=1 loops=1)

  • Output: s.wtsseatoffset, n.wtsxtseq, n.wtsxtill, s.wtsseatblob, s.wtstseq
  • Buffers: shared hit=2,318
3. 2.853 2.853 ↑ 1.4 401 1

Index Scan Backward using idx_wtsevtpftseq on public.nzrecs n (cost=0.00..729.91 rows=552 width=12) (actual time=0.173..2.853 rows=401 loops=1)

  • Output: n.wtstseq, n.wtsnzblob, n.wtsevent, n.wtsperf, n.wtspaymeth, n.wtspayno, n.wtstrxtm, n.wtscpu, n.wtsuser, n.wtstill, n.wtstillseq, n.wtsxtill, n.wtsxtillseq, n.wtsnmsort, n.wtsclientid, n.wtsxtseq, n.wtsiscanceled, n.wtsispaid, n.wtstranstp, n.wtstranssubtp, n.wtstranssltp, n.wtsiscredit, n.wtsmember, n.wtsseascode, n.wtspayamt, n.wtsprtuser, n.wtsprtcpu, n.wtsbatch, n.wtssecret, n.wtstktp, n.wtsseasseq, n.wtsmemberflag, n.wtsptrexptm, n.wtsfunc, n.wtssfunc, n.wtsprtmeth, n.wtsprtstatus, n.wtsccstart, n.wtsnumitems, n.wtsitembundles, n.wtsitemgross, n.wtsitemnet, n.wtstransdiscounts, n.wtstransfees, n.wtsgbbits, n.wtsspaymeth, n.wtsprvers, n.wtsreqdeldt, n.wtsrespcds, n.wtsretloc, n.wtspostcd, n.wtstotalamount, n.wtsisrenewal, n.wtsrenewdiscount, n.wtsrenewdiscountreason, n.wtsrenewaccessgroup, n.wtsrenewcardcat,n.wtsrenewhardcardtype, n.wtsrenewstatus, n.wtsrenewpaytype, n.wtsrenewpaysubtype, n.wtsrenewcardexpire, n.wtsauth, n.wtsnexpr, n.wtsisconsideredpaid, n.wtsposteddttm, n.wtsnzaddblob, n.wtsnauth, n.wtsticketstocktype
  • Index Cond: ((n.wtsevent = 'YBS01'::bpchar) AND (n.wtsperf = '001'::bpchar))
  • Filter: ((n.wtstranssubtp <> 'A'::bpchar) AND (n.wtstranstp = 'T'::bpchar))
  • Rows Removed by Filter: 35
  • Buffers: shared hit=304
4. 4.010 4.010 ↓ 0.0 0 401

Index Scan using seatinfo_wtstseq_idx on public.seatinfo s (cost=0.00..1,549.76 rows=1 width=21) (actual time=0.010..0.010 rows=0 loops=401)

  • Output: s.wtstseq, s.wtsseatitem, s.wtsbundle, s.wtsbundleitem, s.wtsseatoffset, s.wtsblock, s.wtsrow, s.wtsseat, s.wtsnumblock, s.wtsnumrow, s.wtsopenflag, s.wtsstgross, s.wtsstnet, s.wtscnscd, s.wtscnsidx, s.wtsstaccessgp, s.wtselevatorflag, s.wtsstfct, s.wtsstpricelevel, s.wtsstsubfct, s.wtsseatblob, s.wtsstdescidx, s.wtscnsreas, s.wtsststatus, s.wtsrprseq, s.wtsqty, s.wtsbarcode, s.wtsattendid, s.wtsverifiedflag, s.wtsextbarcodeid, s.wtscustomid
  • Index Cond: (s.wtstseq = n.wtstseq)
  • Filter: ((s.wtsblock = 'PAR2'::bpchar) AND (s.wtsrow = '1 '::bpchar) AND (s.wtsseat = 15))
  • Rows Removed by Filter: 2
  • Buffers: shared hit=2,014
Total runtime : 7.012 ms