explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7YzO

Settings
# exclusive inclusive rows x rows loops node
1. 3.502 20.193 ↓ 11.1 323 1

Gather (cost=1,000.00..5,689.96 rows=29 width=8) (actual time=0.221..20.193 rows=323 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
  • Buffers: shared hit=2481
2. 16.691 16.691 ↓ 9.5 162 2

Parallel Seq Scan on employees (cost=0.00..4,687.06 rows=17 width=8) (actual time=0.162..16.691 rows=162 loops=2)

  • Filter: (last_name ~~ 'Bau%'::text)
  • Rows Removed by Filter: 149850
  • Buffers: shared hit=2481
Planning time : 0.071 ms
Execution time : 20.233 ms