explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1fRp : Optimization for: plan #YBf7

Settings

Optimization path:

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

Limit (cost=12.57..12.57 rows=1 width=1,236) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=12.57..12.57 rows=1 width=1,236) (actual rows= loops=)

  • Sort Key: sr_candidates.updatedon DESC
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=8.17..12.56 rows=1 width=1,236) (actual rows= loops=)

  • Hash Cond: ((sr_candidates.id)::text = ("T".idcandidate)::text)
4. 0.000 0.000 ↓ 0.0

Seq Scan on sr_candidates (cost=0.00..4.00 rows=100 width=204) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash (cost=8.16..8.16 rows=1 width=1,032) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Index Scan using sr_candidates_tags_has_tag_index on sr_candidates_tags_has "T" (cost=0.14..8.16 rows=1 width=1,032) (actual rows= loops=)

  • Index Cond: ((tag)::text = 'NS20-JAY'::text)