explain.depesz.com

PostgreSQL's explain analyze made readable

Result: w2mM

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=23,142.56..23,142.58 rows=10 width=1,364)

2. 0.000 0.000 ↓ 0.0

Sort (cost=23,142.56..23,156.79 rows=5,693 width=1,364)

  • Sort Key: published_at DESC
3. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on articles (cost=793.91..23,019.53 rows=5,693 width=1,364)

  • Recheck Cond: (referenced_domains_array @> '{linkedin.com}'::text[])
  • Filter: ((published_at IS NOT NULL) AND (title IS NOT NULL) AND (published_at <= now()))
4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on articles_referenced_domains_array_index (cost=0.00..792.49 rows=5,932 width=0)

  • Index Cond: (referenced_domains_array @> '{linkedin.com}'::text[])