explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rwUd

Settings
# exclusive inclusive rows x rows loops node
1. 2.006 7.305 ↓ 1.2 888 1

Sort (cost=624.61..626.41 rows=719 width=51) (actual time=7.268..7.305 rows=888 loops=1)

  • Sort Key: e.nome
  • Sort Method: quicksort Memory: 120kB
2. 0.000 5.299 ↓ 1.2 888 1

Nested Loop Anti Join (cost=31.52..590.50 rows=719 width=51) (actual time=0.356..5.299 rows=888 loops=1)

3. 1.764 1.864 ↓ 1.3 901 1

Bitmap Heap Scan on entidade e (cost=31.24..374.04 rows=720 width=51) (actual time=0.133..1.864 rows=901 loops=1)

  • Recheck Cond: ((classname)::text = 'Entidade.Pessoa.Organizacao.Fazenda'::text)
  • Filter: (((nome)::text !~~* '%VIRTUAL%'::text) AND (situacao = 1))
  • Rows Removed by Filter: 2
  • Heap Blocks: exact=231
4. 0.100 0.100 ↑ 1.0 903 1

Bitmap Index Scan on idx_entidade_classname (cost=0.00..31.06 rows=903 width=0) (actual time=0.100..0.100 rows=903 loops=1)

  • Index Cond: ((classname)::text = 'Entidade.Pessoa.Organizacao.Fazenda'::text)
5. 3.604 3.604 ↓ 0.0 0 901

Index Only Scan using idx_sigla_fazenda on metasporfazenda a (cost=0.28..4.62 rows=211 width=32) (actual time=0.004..0.004 rows=0 loops=901)

  • Index Cond: (fazenda = (e.cod_objeto)::text)
  • Heap Fetches: 0
Planning time : 4.077 ms