explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 16ZT

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 285.852 ↓ 0.0 0 1

Nested Loop (cost=3,088.30..269,640.30 rows=1 width=4) (actual time=285.850..285.852 rows=0 loops=1)

2. 233.421 285.846 ↓ 0.0 0 1

Bitmap Heap Scan on verification_attempts (cost=3,087.86..269,631.84 rows=1 width=4) (actual time=285.845..285.846 rows=0 loops=1)

  • Recheck Cond: ((status)::text = 'waiting'::text)
  • Filter: ((NOT sandbox) AND (user_id <> 9193534) AND (group_id = 5) AND (((request -> 'social'::text) = 'MIGOBgkqhkiG9w0BBwaggYAwfgIBADB5BgkqhkiG9w0BBwEwWgYKYIZIAYb9HgUBBjBMBAAMSHRyb29waWQ6MDcwMTAxMDAwMDAwWjp2b2x0YWdlLnRyb29waWQuY29tIzEzNTcyNDc0NjQ6ZGF0YTpBRVMtRU1FUzoyNTY6OoAQxu61NxKB19y0iGW4gG3jig=='::text) OR (((request -> 'birth_date'::text) = 'MIGOBgkqhkiG9w0BBwaggYAwfgIBADB5BgkqhkiG9w0BBwEwWgYKYIZIAYb9HgUBBjBMBAAMSHRyb29waWQ6MDcwMTAxMDAwMDAwWjp2b2x0YWdlLnRyb29waWQuY29tIzEzNTcyNDc0NjQ6ZGF0YTpBRVMtRU1FUzoyNTY6OoAQvoNTVjZGiousk5vZQkf25Q=='::text) AND ((request -> 'last_name'::text) = 'HARTMANN'::text) AND ((request -> 'first_name'::text) = 'MICHAEL'::text))))
  • Rows Removed by Filter: 92,483
  • Heap Blocks: exact=169,160
3. 52.425 52.425 ↓ 3.3 246,879 1

Bitmap Index Scan on index_verification_attempts_on_status (cost=0.00..3,087.86 rows=75,106 width=0) (actual time=52.423..52.425 rows=246,879 loops=1)

  • Index Cond: ((status)::text = 'waiting'::text)
4. 0.000 0.000 ↓ 0.0 0

Index Scan using users_pkey on users (cost=0.44..8.46 rows=1 width=4) (never executed)

  • Index Cond: (id = verification_attempts.user_id)
  • Filter: (purged_at IS NULL)
Planning time : 0.561 ms
Execution time : 285.918 ms