explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oXxP

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 17.859 66.613 ↓ 0.0 0 1

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

  • Workers Planned: 2
  • Workers Launched: 2
2. 48.754 48.754 ↓ 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=48.754..48.754 rows=0 loops=3)

  • Filter: (((tag_id)::text <> 'Abc'::text) AND ((container_no)::text = 'abc'::text) AND ((tag_status)::text = 'ACTIVE'::text))
  • Rows Removed by Filter: 333171
Planning time : 0.059 ms