explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4WER

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 159.357 ↓ 0.0 0 1

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

  • One-Time Filter: $1
2.          

Initplan (for Result)

3. 0.000 159.354 ↓ 0.0 0 1

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

4. 159.354 159.354 ↓ 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=159.353..159.354 rows=0 loops=1)

  • Index Cond: ((veiculo_id = 46,523) 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 : 756.924 ms
Execution time : 159.385 ms