explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hRdN : Optimization for: plan #6GDP

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.024 1.813 ↑ 1.0 100 1

Limit (cost=0.06..60.92 rows=100 width=2,111) (actual time=1.117..1.813 rows=100 loops=1)

2. 1.789 1.789 ↑ 129.0 100 1

Index Scan using alt_sms_modifdt_iderr on a_alt_sms_status altsmsstat0_ (cost=0.06..7,853.88 rows=12,904 width=2,111) (actual time=1.114..1.789 rows=100 loops=1)

  • Index Cond: (modify_date_ IS NULL)
  • Filter: ((alt_sms_id_)::text <> 'ERROR'::text)
Planning time : 0.840 ms
Execution time : 1.897 ms