HTML
SOURCE
QUERY
REFORMATTED QUERY
STATS

#	rows x	node
1.	↓ 0.0	→ Limit (cost=23,142.56..23,142.58 rows=10 width=1,364)
2.	↓ 0.0	→ Sort (cost=23,142.56..23,156.79 rows=5,693 width=1,364) Sort Key: published_at DESC
3.	↓ 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.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[])

Limit  (cost=23142.56..23142.58 rows=10 width=1364)
  ->  Sort  (cost=23142.56..23156.79 rows=5693 width=1364)
        Sort Key: published_at DESC
        ->  Bitmap Heap Scan on articles  (cost=793.91..23019.53 rows=5693 width=1364)
              Recheck Cond: (referenced_domains_array @> '{linkedin.com}'::text[])
              Filter: ((published_at IS NOT NULL) AND (title IS NOT NULL) AND (published_at <= now()))
              ->  Bitmap Index Scan on articles_referenced_domains_array_index  (cost=0.00..792.49 rows=5932 width=0)
                    Index Cond: (referenced_domains_array @> '{linkedin.com}'::text[])

SELECT * FROM "articles" WHERE ((published_at <= now()) AND ("published_at" IS NOT NULL) AND ("title" IS NOT NULL) AND ("referenced_domains_array" @> ARRAY['linkedin.com'])) ORDER BY "published_at" DESC LIMIT 10

SELECT
    *
FROM
    articles
WHERE
    published_at <= now() AND
    published_at IS NOT NULL AND
    title IS NOT NULL AND
    referenced_domains_array @> ARRAY[ 'linkedin.com' ]
ORDER BY
    published_at DESC
LIMIT 10;
-- Formatted by Pg::SQL::PrettyPrinter

Per node type stats

node type	count	sum of times	% of query
Bitmap Heap Scan	1	0.000 ms	0.0 %
Bitmap Index Scan	1	0.000 ms	0.0 %
Limit	1	0.000 ms	0.0 %
Sort	1	0.000 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
articles	1	0.000 ms	0.0 %
Bitmap Heap Scan	1	0.000 ms	0.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: w2mM

Color mode:

Visible columns:

Per node type stats

Per table stats