explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QAbY

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 133.222 ↑ 1.0 30 1

Limit (cost=29,639.22..29,639.30 rows=30 width=19) (actual time=133.216..133.222 rows=30 loops=1)

2. 2.778 133.212 ↑ 780.2 30 1

Sort (cost=29,639.22..29,697.74 rows=23,407 width=19) (actual time=133.211..133.212 rows=30 loops=1)

  • Sort Key: published_date
  • Sort Method: top-N heapsort Memory: 27kB
3. 24.762 130.434 ↑ 1.1 21,355 1

HashAggregate (cost=28,713.84..28,947.91 rows=23,407 width=19) (actual time=122.720..130.434 rows=21,355 loops=1)

4. 101.254 105.672 ↓ 1.0 26,427 1

Bitmap Heap Scan on predictions (cost=502.26..28,582.23 rows=26,323 width=19) (actual time=6.458..105.672 rows=26,427 loops=1)

  • 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[])))
  • Rows Removed by Filter: 87
5. 4.418 4.418 ↓ 1.0 26,726 1

Bitmap Index Scan on article_by_publisher (cost=0.00..495.67 rows=26,584 width=0) (actual time=4.418..4.418 rows=26,726 loops=1)

  • Index Cond: (publisher_id = 4)