explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5ovTa

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Unique (cost=531,817.16..535,632.69 rows=466,624 width=15) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=531,817.16..533,724.92 rows=763,106 width=15) (actual rows= loops=)

  • Sort Key: cnpj
3. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on cnpj_dados_cnae_secundario_pj cnae (cost=14,246.58..444,211.39 rows=763,106 width=15) (actual rows= loops=)

  • Recheck Cond: (cnae_secundario = ANY ('{6911701,8291100,8220200,7020400,6461100,8599604,6204000,6209100}'::text[]))
4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_cnae (cost=0.00..14,055.80 rows=763,106 width=0) (actual rows= loops=)

  • Index Cond: (cnae_secundario = ANY ('{6911701,8291100,8220200,7020400,6461100,8599604,6204000,6209100}'::text[]))