explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SYvg : Optimization for: plan #fuXN8

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=1.05..1.06 rows=1 width=15) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=1.05..1.06 rows=1 width=15) (actual rows= loops=)

  • Sort Key: created_at DESC
3. 0.000 0.000 ↓ 0.0

Seq Scan on hl7_message (cost=0.00..1.04 rows=1 width=15) (actual rows= loops=)

  • Filter: (((status)::text <> 'DUPLICATE'::text) AND ((hl7_route_id)::text = ''::text))