explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oR6U

Settings
# exclusive inclusive rows x rows loops node
1. 3.567 17.968 ↓ 10.8 323 1

Gather (cost=1,000.00..5,690.06 rows=30 width=35) (actual time=0.240..17.968 rows=323 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
  • Buffers: shared hit=2481
2. 14.401 14.401 ↓ 9.0 162 2

Parallel Seq Scan on employees (cost=0.00..4,687.06 rows=18 width=35) (actual time=0.057..14.401 rows=162 loops=2)

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