explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mxC

Settings
# exclusive inclusive rows x rows loops node
1. 56.069 181.093 ↑ 1.0 15,628 1

Seq Scan on public.examineposition ep (cost=0.00..123,547.27 rows=15,898 width=476) (actual time=0.072..181.093 rows=15,628 loops=1)

  • Output: ep.epid, ep.examineserialnum, ep.positiontypeid, (SubPlan 1), (SubPlan 2), ep.positiondetailid, (SubPlan 3)
  • Filter: ((ep.isavailable)::text = '1'::text)
  • Rows Removed by Filter: 2883
  • Buffers: shared hit=78015
2.          

SubPlan (forSeq Scan)

3. 46.884 46.884 ↑ 1.0 1 15,628

Seq Scan on public.positiontype pt (cost=0.00..1.23 rows=1 width=13) (actual time=0.002..0.003 rows=1 loops=15,628)

  • Output: pt.positiontypename
  • Filter: (ep.positiontypeid = pt.positiontypeid)
  • Rows Removed by Filter: 17
  • Buffers: shared hit=15628
4. 46.884 46.884 ↑ 1.0 1 15,628

Seq Scan on public.positiontype pt_1 (cost=0.00..1.23 rows=1 width=9) (actual time=0.002..0.003 rows=1 loops=15,628)

  • Output: pt_1.positiontypemarks
  • Filter: (ep.positiontypeid = pt_1.positiontypeid)
  • Rows Removed by Filter: 17
  • Buffers: shared hit=15628
5. 31.256 31.256 ↑ 1.0 1 15,628

Index Scan using positiondetail_pk on public.positiondetail pd (cost=0.27..5.29 rows=1 width=15) (actual time=0.002..0.002 rows=1 loops=15,628)

  • Output: pd.positionname
  • Index Cond: (ep.positiondetailid = pd.positionid)
  • Buffers: shared hit=46499