explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BJXI

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 10,992.769 ↓ 2.0 2 1

Limit (cost=144.59..28,482.03 rows=1 width=31) (actual time=3,537.614..10,992.769 rows=2 loops=1)

2. 0.066 10,992.764 ↓ 2.0 2 1

Nested Loop (cost=144.59..28,482.03 rows=1 width=31) (actual time=3,537.613..10,992.764 rows=2 loops=1)

3. 212.670 10,986.482 ↓ 24.0 24 1

Nested Loop (cost=144.02..28,479.23 rows=1 width=31) (actual time=3,537.449..10,986.482 rows=24 loops=1)

4. 918.443 996.887 ↓ 9.6 102,915 1

Bitmap Heap Scan on "historicoFuncionalRais" a (cost=143.45..10,484.43 rows=10,734 width=31) (actual time=92.381..996.887 rows=102,915 loops=1)

  • Recheck Cond: ((admissao >= '2017-09-01'::date) AND (admissao <= '2017-11-01'::date))
  • Heap Blocks: exact=42429
5. 78.444 78.444 ↓ 9.6 102,917 1

Bitmap Index Scan on "historicoFuncionalRais_admissao_idx" (cost=0.00..140.77 rows=10,734 width=0) (actual time=78.444..78.444 rows=102,917 loops=1)

  • Index Cond: ((admissao >= '2017-09-01'::date) AND (admissao <= '2017-11-01'::date))
6. 9,776.925 9,776.925 ↓ 0.0 0 102,915

Index Only Scan using "empresa_cnpj_atividadeEconomicaPrincipalCodigo_enderecoMuni_idx" on empresa b (cost=0.56..1.67 rows=1 width=15) (actual time=0.095..0.095 rows=0 loops=102,915)

  • Index Cond: ((cnpj = a.cnpj) AND ("atividadeEconomicaPrincipalCodigo" = '2121101'::text) AND ("enderecoMunicipio" = 'GOIANIA'::text) AND ("enderecoUf" = 'GO'::text))
  • Heap Fetches: 0
7. 6.216 6.216 ↓ 0.0 0 24

Index Scan using pessoa_fisica_n_pkey on pessoa_fisica d (cost=0.57..2.79 rows=1 width=12) (actual time=0.259..0.259 rows=0 loops=24)

  • Index Cond: (cd_cpf = a.cpf)
  • Filter: ((dt_nascimento >= '1987-01-01'::date) AND (dt_nascimento <= '1988-01-01'::date))
  • Rows Removed by Filter: 1