explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OC6J

Settings
# exclusive inclusive rows x rows loops node
1. 0.318 1.044 ↑ 1.0 195 1

Nested Loop (cost=6.10..1,499.94 rows=197 width=40) (actual time=0.052..1.044 rows=195 loops=1)

2. 0.113 0.141 ↑ 1.0 195 1

Bitmap Heap Scan on tst_contrato (cost=5.81..169.39 rows=197 width=16) (actual time=0.038..0.141 rows=195 loops=1)

  • Recheck Cond: ((matricula)::date > (CURRENT_DATE - 90))
  • Heap Blocks: exact=28
3. 0.028 0.028 ↑ 1.0 195 1

Bitmap Index Scan on tstcontratomatricula (cost=0.00..5.76 rows=197 width=0) (actual time=0.027..0.028 rows=195 loops=1)

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

Index Only Scan using tstpkpessoa on tst_pessoa (cost=0.29..6.74 rows=1 width=28) (actual time=0.003..0.003 rows=1 loops=195)

  • Index Cond: (pessoa_id = (tst_contrato.pessoa_id)::integer)
  • Heap Fetches: 195