explain.depesz.com

PostgreSQL's explain analyze made readable

Result: w66

Settings
# exclusive inclusive rows x rows loops node
1. 8.068 106.276 ↑ 1.0 1 1

Aggregate (cost=588,453.85..588,453.86 rows=1 width=8) (actual time=106.276..106.276 rows=1 loops=1)

2. 98.208 98.208 ↑ 4.9 123,950 1

Index Scan using idx_contact_emailaicache_emails_0_emailserverai on contact (cost=0.42..586,922.21 rows=612,653 width=0) (actual time=0.019..98.208 rows=123,950 loops=1)

  • Index Cond: ((((emailaicache -> 'emails'::text) -> 0) ->> 'Email Server AI'::text) = 'valid'::text)