explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jRMQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 1.337 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.88..12.95 rows=1 width=63) (actual time=1.335..1.337 rows=1 loops=1)

2. 0.003 0.909 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.58..8.63 rows=1 width=63) (actual time=0.907..0.909 rows=1 loops=1)

3. 0.897 0.897 ↑ 1.0 1 1

Index Scan using modulo_id_fornecedor_idx on modulo (cost=0.29..4.31 rows=1 width=47) (actual time=0.896..0.897 rows=1 loops=1)

  • Index Cond: ((id_fornecedor)::text = '0060030EDD'::text)
  • Filter: (computador_bordo_id = ANY ('{8,11}'::integer[]))
4. 0.009 0.009 ↓ 0.0 0 1

Index Scan using idx_veiculo_modulo on veiculo v1 (cost=0.29..4.31 rows=1 width=24) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (modulo.id = sgr_id)
5. 0.426 0.426 ↑ 1.0 1 1

Index Scan using veiculo_sgr_id2_idx on veiculo v2 (cost=0.29..4.31 rows=1 width=24) (actual time=0.426..0.426 rows=1 loops=1)

  • Index Cond: (modulo.id = sgr_id2)
Planning time : 0.452 ms
Execution time : 1.399 ms