explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PizN

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.386 ↓ 0.0 0 1

Result (cost=49,963.78..49,963.79 rows=1 width=4) (actual time=0.386..0.386 rows=0 loops=1)

  • One-Time Filter: $1
2.          

Initplan (for Result)

3. 0.398 0.433 ↓ 0.0 0 1

Gather (cost=1,008.46..49,963.78 rows=1 width=0) (actual time=0.384..0.433 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 0
4. 0.005 0.035 ↓ 0.0 0 1

Hash Join (cost=8.46..48,963.68 rows=1 width=0) (actual time=0.035..0.035 rows=0 loops=1)

  • Hash Cond: (requisicao.eventocs_id = eventocs.id)
5. 0.003 0.003 ↑ 158,265.0 1 1

Parallel Seq Scan on requisicao (cost=0.00..48,539.77 rows=158,265 width=8) (actual time=0.003..0.003 rows=1 loops=1)

  • Filter: (status <> 0)
6. 0.000 0.027 ↓ 0.0 0 1

Hash (cost=8.45..8.45 rows=1 width=8) (actual time=0.027..0.027 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
7. 0.027 0.027 ↓ 0.0 0 1

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

  • Index Cond: ((veiculo_id = 68846) 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)
Planning time : 829.449 ms
Execution time : 0.480 ms