explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Qoem

Settings
# exclusive inclusive rows x rows loops node
1. 0.038 39.327 ↑ 1.0 1 1

Result (cost=27,045.86..27,045.87 rows=1 width=32) (actual time=39.327..39.327 rows=1 loops=1)

2.          

Initplan (for Result)

3. 11.488 39.289 ↑ 4.8 337 1

HashAggregate (cost=27,029.67..27,045.86 rows=1,619 width=16) (actual time=39.236..39.289 rows=337 loops=1)

  • Group Key: offering_merchant_id
4. 27.801 27.801 ↑ 1.0 69,287 1

Index Scan using offers_status_index on offers (cost=0.42..26,856.20 rows=69,389 width=16) (actual time=0.025..27.801 rows=69,287 loops=1)

  • Index Cond: (status = 'ON'::offer_status)
Planning time : 0.207 ms
Execution time : 39.393 ms