explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vzw9

Settings
# exclusive inclusive rows x rows loops node
1. 38.764 38.764 ↓ 0.0 8,426 1

Seq Scan on invmanufacturer invmanufacturer (cost=0..0 rows=0 width=0) (actual time=0.072..38.764 rows=8,426 loops=1)

  • Filter: (manufacturer_name ~~ 'a%'::citext)
Planning time : 0.319 ms
Execution time : 39.054 ms