explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JOi7

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

Result (cost=19,007.43..19,007.44 rows=1 width=4) (actual time=4.353..4.353 rows=0 loops=1)

  • One-Time Filter: $1
2.          

Initplan (for Result)

3. 5.021 5.143 ↓ 0.0 0 1

Gather (cost=1,008.59..19,007.43 rows=1 width=0) (actual time=4.351..5.143 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 0.056 0.122 ↓ 0.0 0 3 / 3

Hash Join (cost=8.59..18,007.33 rows=1 width=0) (actual time=0.122..0.122 rows=0 loops=3)

  • Hash Cond: (requisicao.eventostreamax_id = eventostreamax.id)
5. 0.004 0.004 ↑ 80,841.0 1 3 / 3

Parallel Seq Scan on requisicao (cost=0.00..17,786.53 rows=80,841 width=8) (actual time=0.004..0.004 rows=1 loops=3)

  • Filter: (status <> 0)
6. 0.000 0.062 ↓ 0.0 0 3 / 3

Hash (cost=8.58..8.58 rows=1 width=8) (actual time=0.062..0.062 rows=0 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
7. 0.062 0.062 ↓ 0.0 0 3 / 3

Index Scan using idx_evstx_dh_vei_desc on eventostreamax (cost=0.56..8.58 rows=1 width=8) (actual time=0.062..0.062 rows=0 loops=3)

  • Index Cond: ((datahora >= '2020-07-01 11:00:00'::timestamp without time zone) AND (datahora <= '2020-07-01 10:00:00'::timestamp without time zone) AND (veiculo_id = 63995) AND ((descricao)::text = 'Evento de Ignição On'::text))
Planning time : 1,426.553 ms
Execution time : 5.193 ms