explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5rxc

Settings
# exclusive inclusive rows x rows loops node
1. 0.023 19,389.297 ↑ 1.0 51 1

Limit (cost=2,044,608.53..2,044,608.66 rows=51 width=735) (actual time=19,389.263..19,389.297 rows=51 loops=1)

  • Buffers: shared hit=53561 read=465080 written=5250
2. 842.743 19,389.274 ↑ 15,863.2 51 1

Sort (cost=2,044,608.53..2,046,631.09 rows=809,024 width=735) (actual time=19,389.261..19,389.274 rows=51 loops=1)

  • Sort Key: date_uploaded, id
  • Sort Method: top-N heapsort Memory: 51kB
  • Buffers: shared hit=53561 read=465080 written=5250
3. 18,275.642 18,546.531 ↑ 1.0 807,272 1

Bitmap Heap Scan on images (cost=30,391.62..2,017,617.77 rows=809,024 width=735) (actual time=445.014..18,546.531 rows=807,272 loops=1)

  • Recheck Cond: ((company_id = 1) AND (status = 2) AND (deleted_at IS NULL))
  • Heap Blocks: exact=513767
  • Buffers: shared hit=53555 read=465080 written=5250
4. 270.889 270.889 ↑ 1.0 807,357 1

Bitmap Index Scan on by_company_status_deleted (cost=0.00..30,189.37 rows=809,024 width=0) (actual time=270.889..270.889 rows=807,357 loops=1)

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