explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OCEo

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 6.248 ↑ 1.0 1 1

Limit (cost=1,639.41..1,639.42 rows=1 width=103) (actual time=6.247..6.248 rows=1 loops=1)

2. 0.009 6.246 ↑ 1.0 1 1

Sort (cost=1,639.41..1,639.42 rows=1 width=103) (actual time=6.246..6.246 rows=1 loops=1)

  • Sort Key: id
  • Sort Method: quicksort Memory: 25kB
3. 6.237 6.237 ↑ 1.0 1 1

Seq Scan on connect_users (cost=0.00..1,639.40 rows=1 width=103) (actual time=4.005..6.237 rows=1 loops=1)

  • Filter: ((deleted_at IS NULL) AND (connect_user_id = '950a3bc8-6bee-406e-a9fb-6c7529ba5cfc'::uuid) AND (code = 'b8adbc178ba3567c'::text))
  • Rows Removed by Filter: 48,228