explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pMPm

Settings
# exclusive inclusive rows x rows loops node
1. 0.055 0.055 ↓ 1.1 23 1

Sort (cost=125895.69..125946.69 rows=20401 width=1619) (actual time=13.373..13.585 rows=196 loops=1)Sort Key: (CASE WHEN consumers.enable_notifications THEN 1 ELSE 2 END), verification_attempts.created_atSort Method: quicksort Memory: 425kB-> Hash Join (cost=169.50..110067.85 rows=20401 width=1619) (actual time=9.268..12.433 rows=196 loops=1)Hash Cond: (verification_attempts.consumer_id = consumers.id)-> Nested Loop (cost=0.56..109845.29 rows=20401 width=1230) (actual time=0.095..2.682 rows=196 loops=1)-> Seq Scan on options (cost=0.00..2.69 rows=21 width=118) (actual time=0.013..0.055 rows=23 loops=1)