explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hNkM

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 23.847 ↑ 1.0 10 1
→

Limit (cost=23,142.56..23,142.58 rows=10 width=1,364) (actual time=23.843..23.847 rows=10 loops=1)

2. 1.793 23.844 ↑ 569.3 10 1
→

Sort (cost=23,142.56..23,156.79 rows=5,693 width=1,364) (actual time=23.841..23.844 rows=10 loops=1)

  • Sort Key: published_at DESC
  • Sort Method: top-N heapsort Memory: 38kB
3. 16.737 22.051 ↓ 1.1 6,336
- 64 		1
→

Bitmap Heap Scan on articles (cost=793.91..23,019.53 rows=5,693 width=1,364) (actual time=5.971..22.051 rows=6,336 loops=1)

  • Recheck Cond: (referenced_domains_array @> '{linkedin.com}'::text[])
  • Filter: ((published_at IS NOT NULL) AND (title IS NOT NULL) AND (published_at <= now()))
  • Rows Removed by Filter: 64
  • Heap Blocks: exact=5,951
4. 5.314 5.314 ↓ 1.1 6,400 1
→

Bitmap Index Scan on articles_referenced_domains_array_index (cost=0.00..792.49 rows=5,932 width=0) (actual time=5.313..5.314 rows=6,400 loops=1)

  • Index Cond: (referenced_domains_array @> '{linkedin.com}'::text[])
Planning time : 1.194 ms
Execution time : 23.952 ms