explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7ynf

Settings
# exclusive inclusive rows x rows loops node
1. 3.013 60.945 ↓ 3.4 21,600 1

Limit (cost=0.00..41.02 rows=6,310 width=160) (actual time=0.113..60.945 rows=21,600 loops=1)

  • Output: rt.wtsevent, rt.wtsperf, rt.wtsblocknum, rt.wtsrownum, rt.wtsblockcode, rt.wtsseatstatus, rt.wtsseatpridx, rt.wtsseatftidx, rt.wtslasttseq, p.wtspromoter
  • Buffers: shared hit=6310
2. 32.948 57.932 ↓ 3.4 21,600 1

Nested Loop (cost=0.00..41.02 rows=6,310 width=160) (actual time=0.111..57.932 rows=21,600 loops=1)

  • Output: rt.wtsevent, rt.wtsperf, rt.wtsblocknum, rt.wtsrownum, rt.wtsblockcode, rt.wtsseatstatus, rt.wtsseatpridx, rt.wtsseatftidx, rt.wtslasttseq, p.wtspromoter
  • Buffers: shared hit=6310
3. 0.084 0.084 ↓ 12.0 12 1

Index Scan using wtsperfrec_wtsevent_wtsperf_wtspfdate_idx on public.wtsperfrec p (cost=0.00..3.31 rows=1 width=13) (actual time=0.040..0.084 rows=12 loops=1)

  • Output: p.wtsevent, p.wtsperf, p.wtspfdate, p.wtslayoutcode, p.venuecode, p.wtsperfdesc, p.wtsarea0, p.wtsarea1, p.wtsarea2, p.wtsarea3, p.wtsarea4, p.wtsarea5, p.wtsarea6, p.wtsarea7, p.wtslevel0, p.wtslevel1, p.wtslevel2, p.wtslevel3, p.wtslevel4, p.wtslevel5, p.wtslevel6, p.wtslevel7, p.wtspfctdt, p.wtsseatcnt, p.wtsbarevent, p.wtsnumblocks, p.wtstkno, p.wtstklimit, p.wtsruntime, p.wtssponmsg, p.wtspfextdesc0, p.wtspfextdesc1, p.wtsseasoncd, p.wtspftype, p.wtspromoter, p.wtsawaycd, p.wtscompcd, p.wtsshowtp, p.wtsisactive, p.wtsissuspended, p.wtsismarkedforpurge, p.wtsissumticket, p.wtsisholdcheck, p.wtsissuppressedseas, p.wtsisclubcardpf, p.wtsismemberpf, p.wtsismarketingpf, p.wtsisclubcardrtbpf, p.wtsperfblob, p.wtsidrequired, p.wtspffirstprt, p.wtszeropriceok, p.wtsnewpromoter, p.wtsnewawaycd, p.wtsextbarcodefl, p.wtsslsttime, p.wtsslendtime, p.wtspfdatetp, p.wtsextbarcodetype
  • Index Cond: ((p.wtsevent = '9916A'::bpchar) AND (p.wtspfdate > '2019-04-11 00:00:00+03'::abstime))
  • Buffers: shared hit=14
4. 24.900 24.900 ↓ 54.5 1,800 12

Index Scan using wtsrowtable_wtsevent_wtsperf_idx on public.wtsrowtable rt (cost=0.00..37.38 rows=33 width=157) (actual time=0.061..2.075 rows=1,800 loops=12)

  • Output: rt.wtsevent, rt.wtsperf, rt.wtsblocknum, rt.wtsrownum, rt.wtsirownum, rt.wtsrowstseat, rt.wtsrownumseat, rt.wtsrowoffset, rt.wtsblockcode, rt.wtsrow, rt.wtsprtrow, rt.wtsseatstatus, rt.wtsseatcnsidx, rt.wtsseatpridx, rt.wtsseatftidx, rt.wtsseatsftidx, rt.wtsseatdescidx, rt.wtsseatqlty, rt.wtsseatnumber, rt.wtsseatlr, rt.wtsseatadj, rt.wtslasttseq
  • Index Cond: ((rt.wtsevent = '9916A'::bpchar) AND (rt.wtsperf = p.wtsperf))
  • Buffers: shared hit=6296