explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TDMW

Settings
# exclusive inclusive rows x rows loops node
1. 0.242 1.014 ↑ 1.0 195 1

Nested Loop (cost=10.10..1,457.33 rows=196 width=40) (actual time=0.066..1.014 rows=195 loops=1)

2. 0.149 0.187 ↑ 1.0 195 1

Bitmap Heap Scan on mov_contrato (cost=9.81..233.06 rows=196 width=16) (actual time=0.052..0.187 rows=195 loops=1)

  • Recheck Cond: ((matricula)::date > (CURRENT_DATE - 90))
  • Heap Blocks: exact=41
3. 0.038 0.038 ↓ 1.4 267 1

Bitmap Index Scan on idxcontratomatricula (cost=0.00..9.76 rows=196 width=0) (actual time=0.038..0.038 rows=267 loops=1)

  • Index Cond: ((matricula)::date > (CURRENT_DATE - 90))
4. 0.585 0.585 ↑ 1.0 1 195

Index Scan using pkpessoa on cad_pessoa (cost=0.29..6.25 rows=1 width=28) (actual time=0.003..0.003 rows=1 loops=195)

  • Index Cond: ((pessoa_id)::integer = (mov_contrato.pessoa_id)::integer)