explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SpjK : Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: plan #hvgr; plan #vG1; plan #5uPj; plan #tJir; plan #4Aiq; plan #wXyW; plan #1Q6S; plan #7r6r; plan #fCGR; plan #Op05

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 4.468 61.464 ↓ 0.0 0 1

Gather (cost=1,000.00..19,646.21 rows=1 width=8) (actual time=59.844..61.464 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 56.996 56.996 ↓ 0.0 0 3

Parallel Seq Scan on tag_id_container_no_map (cost=0.00..18,646.11 rows=1 width=8) (actual time=56.996..56.996 rows=0 loops=3)

  • Filter: (((tag_id)::text <> 'param_tag_id'::text) AND ((container_no)::text = 'param_container_no'::text) AND ((tag_status)::text = 'ACTIVE'::text))
  • Rows Removed by Filter: 333171