explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0L8E

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 53.275 115.002 ↑ 1.0 1 1

Gather (cost=1,000.00..15,544.43 rows=1 width=18) (actual time=10.340..115.002 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 61.727 61.727 ↓ 0.0 0 3 / 3

Parallel Seq Scan on employees (cost=0.00..14,544.33 rows=1 width=18) (actual time=28.008..61.727 rows=0 loops=3)

  • Filter: (last_name = 'LN 550'::text)
  • Rows Removed by Filter: 333333
Planning time : 0.116 ms
Execution time : 115.050 ms