explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kRdZB

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 22,554.457 ↓ 0.0 0 1

Result (cost=4,391.36..4,391.37 rows=1 width=4) (actual time=22,554.457..22,554.457 rows=0 loops=1)

  • One-Time Filter: $1
2.          

Initplan (for Result)

3. 0.001 22,554.455 ↓ 0.0 0 1

Nested Loop (cost=36.17..4,391.36 rows=1 width=0) (actual time=22,554.455..22,554.455 rows=0 loops=1)

4. 21,992.957 22,554.454 ↓ 0.0 0 1

Bitmap Heap Scan on eventocs (cost=35.75..4,382.90 rows=1 width=8) (actual time=22,554.454..22,554.454 rows=0 loops=1)

  • Recheck Cond: (veiculo_id = 46,609)
  • Filter: ((datahorainicio >= '2020-07-01 11:00:00'::timestamp without time zone) AND (datahorainicio <= '2020-07-01 10:00:00'::timestamp without time zone) AND (tipoevento_codigo = 5))
  • Rows Removed by Filter: 2,212
  • Heap Blocks: exact=1,616
5. 561.497 561.497 ↓ 1.5 2,212 1

Bitmap Index Scan on ev_cs_veiculo_id (cost=0.00..35.74 rows=1,509 width=0) (actual time=561.497..561.497 rows=2,212 loops=1)

  • Index Cond: (veiculo_id = 46,609)
6. 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 : 0.668 ms
Execution time : 22,554.503 ms