explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 95M3

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

Result (cost=6.11..6.12 rows=1 width=4) (actual time=154.298..154.298 rows=1 loops=1)

  • One-Time Filter: $0
2.          

Initplan (for Result)

3. 154.296 154.296 ↑ 1,230.0 1 1

Index Scan using req_veiculo_id on requisicao (cost=0.43..6,993.57 rows=1,230 width=0) (actual time=154.296..154.296 rows=1 loops=1)

  • Index Cond: (veiculo_id = 46408)
  • Filter: (status = ANY ('{0,1}'::integer[]))
Planning time : 0.138 ms
Execution time : 154.314 ms