explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IQqq : modulo api new

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.054 ↓ 2.0 2 1
→

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

2. 0.025 0.025 ↓ 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.016..0.025 rows=2 loops=1)

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

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

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

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

5. 0.010 0.010 ↓ 0.0 0 2
→

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

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

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

  • Index Cond: (modulo.id = sgr_id2)
Planning time : 0.175 ms
Execution time : 0.075 ms