explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MfYNq

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 25,522.103 ↑ 1.0 51 1

Limit (cost=10,002,038,826.73..10,002,038,826.86 rows=51 width=735) (actual time=25,522.070..25,522.103 rows=51 loops=1)

2. 910.538 25,522.083 ↑ 15,797.3 51 1

Sort (cost=10,002,038,826.73..10,002,040,840.89 rows=805,663 width=735) (actual time=25,522.068..25,522.083 rows=51 loops=1)

  • Sort Key: date_uploaded, id
  • Sort Method: top-N heapsort Memory: 51kB
3. 24,327.210 24,611.545 ↓ 1.0 807,336 1

Bitmap Heap Scan on images (cost=30,412.77..2,011,948.10 rows=805,663 width=735) (actual time=472.038..24,611.545 rows=807,336 loops=1)

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

Bitmap Index Scan on by_company_status_deleted (cost=0.00..30,211.35 rows=805,663 width=0) (actual time=284.335..284.335 rows=807,336 loops=1)

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