explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SFjz

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 0.018 ↓ 0.0 0 1

Seq Scan on tag_id_container_no_map (cost=0.00..1.40 rows=1 width=8) (actual time=0.018..0.018 rows=0 loops=1)

  • 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: 23