explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KHF8

Settings
# exclusive inclusive rows x rows loops node
1. 1,102.409 1,102.428 ↓ 1.0 7,167 1

Seq Scan on user_relevance (cost=2.30..2,020.96 rows=7,162 width=24) (actual time=0.443..1,102.428 rows=7,167 loops=1)

  • Filter: (user_id <> 'c8e8664c-dda5-489d-8141-f0f7bc54d245'::uuid)
  • Rows Removed by Filter: 1
2.          

Initplan (for Seq Scan)

3. 0.019 0.019 ↑ 1.0 1 1

Index Scan using user_relevance_pk on user_relevance user_relevance_1 (cost=0.28..2.30 rows=1 width=26) (actual time=0.017..0.019 rows=1 loops=1)

  • Index Cond: (user_id = 'c8e8664c-dda5-489d-8141-f0f7bc54d245'::uuid)
Planning time : 0.127 ms
Execution time : 1,103.400 ms