explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HCPVf

Settings
# exclusive inclusive rows x rows loops node
1. 0.035 0.128 ↑ 180,432.0 1 1

Bitmap Heap Scan on placas (cost=3,378.91..415,589.81 rows=180,432 width=828) (actual time=0.128..0.128 rows=1 loops=1)

  • Recheck Cond: ((placa)::text = 'QKM9900'::text)
  • Heap Blocks: exact=1
2. 0.093 0.093 ↑ 180,432.0 1 1

Bitmap Index Scan on idx_52825_placa_index (cost=0.00..3,333.80 rows=180,432 width=0) (actual time=0.093..0.093 rows=1 loops=1)

  • Index Cond: ((placa)::text = 'QKM9900'::text)
Planning time : 8.019 ms
Execution time : 0.203 ms