explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UK6R : new

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 2.151 ↓ 2.0 2 1

Nested Loop Left Join (cost=4.89..17.16 rows=1 width=27) (actual time=1.306..2.151 rows=2 loops=1)

2. 1.264 1.264 ↓ 2.0 2 1

Index Scan using modulo_id_fornecedor_idx on modulo (cost=0.29..8.57 rows=1 width=19) (actual time=0.857..1.264 rows=2 loops=1)

  • Index Cond: ((id_fornecedor)::text = ANY ('{0060030EDD,00600284B4}'::text[]))
  • Filter: (computador_bordo_id = ANY ('{8,11}'::integer[]))
3. 0.010 0.876 ↑ 2.0 1 2

Bitmap Heap Scan on veiculo v (cost=4.60..8.57 rows=2 width=32) (actual time=0.438..0.438 rows=1 loops=2)

  • Recheck Cond: ((modulo.id = sgr_id) OR (modulo.id = sgr_id2))
  • Heap Blocks: exact=2
4. 0.006 0.866 ↓ 0.0 0 2

BitmapOr (cost=4.60..4.60 rows=2 width=0) (actual time=0.433..0.433 rows=0 loops=2)

5. 0.444 0.444 ↓ 0.0 0 2

Bitmap Index Scan on idx_veiculo_modulo (cost=0.00..2.30 rows=1 width=0) (actual time=0.222..0.222 rows=0 loops=2)

  • Index Cond: (modulo.id = sgr_id)
6. 0.416 0.416 ↓ 0.0 0 2

Bitmap Index Scan on veiculo_sgr_id2_idx (cost=0.00..2.30 rows=1 width=0) (actual time=0.208..0.208 rows=0 loops=2)

  • Index Cond: (modulo.id = sgr_id2)
Planning time : 0.454 ms
Execution time : 2.216 ms