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=2318
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=2318
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.w
  • 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.
  • 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=2014