explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2PSN

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.319 ↑ 1.9 16 1

Limit (cost=6,489.77..6,489.84 rows=30 width=24) (actual time=0.316..0.319 rows=16 loops=1)

  • Buffers: shared read=43
2. 0.015 0.316 ↑ 89.1 16 1

Sort (cost=6,489.77..6,493.33 rows=1,426 width=24) (actual time=0.315..0.316 rows=16 loops=1)

  • Sort Key: created_at DESC
  • Sort Method: quicksort Memory: 26kB
  • Buffers: shared read=43
3. 0.301 0.301 ↑ 89.1 16 1

Index Scan using crypto_trades_completed_offer_id_index on crypto_trades_completed (cost=0.57..6,447.65 rows=1,426 width=24) (actual time=0.087..0.301 rows=16 loops=1)

  • Index Cond: (offer_id = 656148)
  • Filter: ((crypto_amount_requested >= 100000) AND (crypto_trade_status_id = 9) AND (offer_type = 2))
  • Rows Removed by Filter: 24
  • Buffers: shared read=43
Planning time : 0.230 ms
Execution time : 0.342 ms