explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1kH5

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 11.660 ↓ 0.0 0 1

Limit (cost=34.73..34.74 rows=1 width=1,193) (actual time=11.660..11.660 rows=0 loops=1)

2. 0.005 11.659 ↓ 0.0 0 1

Sort (cost=34.73..34.74 rows=1 width=1,193) (actual time=11.659..11.659 rows=0 loops=1)

  • Sort Key: offer_clicks.created_at DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.020 11.654 ↓ 0.0 0 1

Hash Semi Join (cost=10.99..34.72 rows=1 width=1,193) (actual time=11.654..11.654 rows=0 loops=1)

  • Hash Cond: (offer_clicks.offer_id = offers.id)
4. 11.507 11.507 ↑ 2.7 23 1

Index Scan using index_offer_clicks_on_device_id_partial_status on offer_clicks (cost=0.44..24.00 rows=63 width=1,193) (actual time=0.992..11.507 rows=23 loops=1)

  • Index Cond: (device_id = 7,693,492)
5. 0.006 0.127 ↓ 5.6 45 1

Hash (cost=10.45..10.45 rows=8 width=4) (actual time=0.127..0.127 rows=45 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
6. 0.121 0.121 ↓ 5.6 45 1

Index Scan using index_offers_on_bundle_id on offers (cost=0.41..10.45 rows=8 width=4) (actual time=0.022..0.121 rows=45 loops=1)

  • Index Cond: ((bundle_id)::text = 'com.azino.online'::text)
Planning time : 0.424 ms
Execution time : 11.695 ms