explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MBBT

Settings
# exclusive inclusive rows x rows loops node
1. 1.676 247.042 ↑ 1.5 302 1

Bitmap Heap Scan on public.sincronizacao s (cost=24,243.87..28,206.24 rows=448 width=27) (actual time=245.434..247.042 rows=302 loops=1)

  • Output: sin_banco, sin_tabela, sin_operacao
  • Recheck Cond: ((s.sin_banco = 1248) AND ((s.sin_tabela)::text = 'RECPAG'::text))
  • Rows Removed by Index Recheck: 2726
  • Filter: ((s.sin_operacao)::text = 'INSERT'::text)
  • Rows Removed by Filter: 349
  • Heap Blocks: exact=384
2. 5.346 245.366 ↓ 0.0 0 1

BitmapAnd (cost=24,243.87..24,243.87 rows=1,002 width=0) (actual time=245.366..245.366 rows=0 loops=1)

3. 2.740 2.740 ↑ 2.8 14,357 1

Bitmap Index Scan on sincronizacao_pkey (cost=0.00..1,097.90 rows=39,645 width=0) (actual time=2.740..2.740 rows=14,357 loops=1)

  • Index Cond: (s.sin_banco = 1248)
4. 237.280 237.280 ↓ 1.1 1,176,382 1

Bitmap Index Scan on sincronizacao_sin_tabela_idx (cost=0.00..23,145.49 rows=1,093,990 width=0) (actual time=237.280..237.280 rows=1,176,382 loops=1)

  • Index Cond: ((s.sin_tabela)::text = 'RECPAG'::text)