explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yBkl

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.033 ↓ 0.0 0 1

Result (cost=16.91..16.92 rows=1 width=4) (actual time=0.033..0.033 rows=0 loops=1)

  • One-Time Filter: $1
2.          

Initplan (for Result)

3. 0.000 0.032 ↓ 0.0 0 1

Nested Loop (cost=0.85..16.91 rows=1 width=0) (actual time=0.032..0.032 rows=0 loops=1)

4. 0.032 0.032 ↓ 0.0 0 1

Index Scan using eventocs_veiculo_id_datahorainicio_idx on eventocs (cost=0.43..8.45 rows=1 width=8) (actual time=0.032..0.032 rows=0 loops=1)

  • Index Cond: ((veiculo_id = 47937) AND (datahorainicio >= '2020-07-01 11:00:00'::timestamp without time zone) AND (datahorainicio <= '2020-07-01 10:00:00'::timestamp without time zone))
  • Filter: (tipoevento_codigo = 5)
5. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_req_ev_cs on requisicao (cost=0.43..8.45 rows=1 width=8) (never executed)

  • Index Cond: (eventocs_id = eventocs.id)
  • Filter: (status <> 0)
Planning time : 460.832 ms
Execution time : 0.069 ms