explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ssay

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.138 ↑ 1.0 1 1

Limit (cost=27,731.44..27,731.44 rows=1 width=8) (actual time=0.136..0.138 rows=1 loops=1)

  • Buffers: shared read=10
2. 0.011 0.135 ↑ 6,997.0 1 1

Sort (cost=27,731.44..27,748.93 rows=6,997 width=8) (actual time=0.135..0.135 rows=1 loops=1)

  • Sort Key: trade_started_at
  • Sort Method: top-N heapsort Memory: 25kB
  • Buffers: shared read=10
3. 0.029 0.124 ↑ 1,399.4 5 1

Bitmap Heap Scan on crypto_trades_completed (cost=141.11..27,696.45 rows=6,997 width=8) (actual time=0.110..0.124 rows=5 loops=1)

  • Recheck Cond: ((offer_owner_id = 3108854) OR (offer_responder_id = 3108847))
  • Heap Blocks: exact=2
  • Buffers: shared read=10
4. 0.001 0.095 ↓ 0.0 0 1

BitmapOr (cost=141.11..141.11 rows=6,997 width=0) (actual time=0.095..0.095 rows=0 loops=1)

  • Buffers: shared read=8
5. 0.058 0.058 ↓ 0.0 0 1

Bitmap Index Scan on crypto_trades_completed_offer_owner_id_index (cost=0.00..119.28 rows=6,228 width=0) (actual time=0.058..0.058 rows=0 loops=1)

  • Index Cond: (offer_owner_id = 3108854)
  • Buffers: shared read=4
6. 0.036 0.036 ↑ 153.8 5 1

Bitmap Index Scan on crypto_trades_completed_offer_responder_id_index (cost=0.00..18.33 rows=769 width=0) (actual time=0.036..0.036 rows=5 loops=1)

  • Index Cond: (offer_responder_id = 3108847)
  • Buffers: shared read=4
Planning time : 0.181 ms
Execution time : 0.165 ms