explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZlNa

Settings
# exclusive inclusive rows x rows loops node
1. 40.367 40.367 ↓ 0.0 76,536 1

Seq Scan on invmanufacturer invmanufacturer (cost=0..0 rows=0 width=0) (actual time=0.024..40.367 rows=76,536 loops=1)

  • Filter: (manufacturer_name ~~ '%a%'::citext)
Planning time : 0.1 ms
Execution time : 41.893 ms