explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 48rP

Settings
# exclusive inclusive rows x rows loops node
1. 0.022 281,959.906 ↑ 1.0 51 1

Limit (cost=2,044,616.53..2,044,616.66 rows=51 width=735) (actual time=281,959.873..281,959.906 rows=51 loops=1)

  • Buffers: shared hit=71765 read=446886 dirtied=47
2. 1,514.383 281,959.884 ↑ 15,863.2 51 1

Sort (cost=2,044,616.53..2,046,639.09 rows=809,024 width=735) (actual time=281,959.870..281,959.884 rows=51 loops=1)

  • Sort Key: date_uploaded, id
  • Sort Method: top-N heapsort Memory: 51kB
  • Buffers: shared hit=71765 read=446886 dirtied=47
3. 280,034.102 280,445.501 ↑ 1.0 807,282 1

Bitmap Heap Scan on images (cost=30,399.62..2,017,625.77 rows=809,024 width=735) (actual time=596.918..280,445.501 rows=807,282 loops=1)

  • Recheck Cond: ((company_id = 1) AND (status = 2) AND (deleted_at IS NULL))
  • Heap Blocks: exact=513776
  • Buffers: shared hit=71759 read=446886 dirtied=47
4. 411.399 411.399 ↑ 1.0 807,369 1

Bitmap Index Scan on by_company_status_deleted (cost=0.00..30,197.37 rows=809,024 width=0) (actual time=411.399..411.399 rows=807,369 loops=1)

  • Index Cond: ((company_id = 1) AND (status = 2) AND (deleted_at IS NULL))
  • Buffers: shared hit=8 read=4861