explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hlaF

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 34.009 ↑ 1.0 1 1

Result (cost=3.01..3.02 rows=1 width=4) (actual time=34.009..34.009 rows=1 loops=1)

  • One-Time Filter: $0
2.          

Initplan (for Result)

3. 34.007 34.007 ↑ 614.0 1 1

Index Scan using req_veiculo_id on requisicao (cost=0.43..1,583.21 rows=614 width=0) (actual time=34.007..34.007 rows=1 loops=1)

  • Index Cond: (veiculo_id = 68846)
  • Filter: (status = ANY ('{0,1}'::integer[]))
  • Rows Removed by Filter: 5
Planning time : 0.358 ms
Execution time : 34.030 ms