explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KmM5

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

Limit (cost=64.81..72.33 rows=1 width=976) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Result (cost=64.81..72.33 rows=1 width=976) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Sort (cost=64.81..64.82 rows=1 width=880) (actual rows= loops=)

  • Sort Key: time_end DESC
4. 0.000 0.000 ↓ 0.0

Index Scan using asdu_id_time_start_time_end_index on instruction (cost=0.42..64.80 rows=1 width=880) (actual rows= loops=)

  • Index Cond: (((asdu_id)::text = '60224'::text) AND (time_start < now()) AND (time_end > now()))