explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jeSQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.017 255,176.931 ↑ 1.0 51 1

Limit (cost=2,038,806.73..2,038,806.86 rows=51 width=735) (actual time=255,176.898..255,176.931 rows=51 loops=1)

2. 1,549.648 255,176.914 ↑ 15,797.3 51 1

Sort (cost=2,038,806.73..2,040,820.89 rows=805,663 width=735) (actual time=255,176.897..255,176.914 rows=51 loops=1)

  • Sort Key: date_uploaded, id
  • Sort Method: top-N heapsort Memory: 51kB
3. 253,133.805 253,627.266 ↓ 1.0 807,335 1

Bitmap Heap Scan on images (cost=30,392.77..2,011,928.10 rows=805,663 width=735) (actual time=679.276..253,627.266 rows=807,335 loops=1)

  • Recheck Cond: ((company_id = 1) AND (status = 2) AND (deleted_at IS NULL))
  • Heap Blocks: exact=513829
4. 493.461 493.461 ↓ 1.0 807,446 1

Bitmap Index Scan on by_company_status_deleted (cost=0.00..30,191.35 rows=805,663 width=0) (actual time=493.461..493.461 rows=807,446 loops=1)

  • Index Cond: ((company_id = 1) AND (status = 2) AND (deleted_at IS NULL))