explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PFql

Settings
# exclusive inclusive rows x rows loops node
1. 0.022 286,376.554 ↑ 1.0 51 1

Limit (cost=2,957,870.12..2,957,870.25 rows=51 width=735) (actual time=286,376.522..286,376.554 rows=51 loops=1)

2. 1,562.065 286,376.532 ↑ 15,797.3 51 1

Sort (cost=2,957,870.12..2,959,884.28 rows=805,663 width=735) (actual time=286,376.519..286,376.532 rows=51 loops=1)

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

Index Scan using by_company_status_deleted on images (cost=0.56..2,930,991.49 rows=805,663 width=735) (actual time=0.780..284,814.467 rows=807,335 loops=1)

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