explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RStQ

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

Limit (cost=29,636.79..29,636.87 rows=30 width=19) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=29,636.79..29,695.31 rows=23,405 width=19) (actual rows= loops=)

  • Sort Key: published_date
3. 0.000 0.000 ↓ 0.0

HashAggregate (cost=28,711.49..28,945.54 rows=23,405 width=19) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on predictions (cost=502.24..28,579.89 rows=26,321 width=19) (actual rows= loops=)

  • Recheck Cond: (publisher_id = 4)
  • Filter: ((published_date <= '2019-02-09 15:30:52'::timestamp without time zone) AND ((language)::text = ANY ('{en,ms,zh}'::text[])))
5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on article_by_publisher (cost=0.00..495.66 rows=26,582 width=0) (actual rows= loops=)