explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nEBF

Settings
# exclusive inclusive rows x rows loops node
1. 2.251 25,765.394 ↑ 24.0 1,163 1

Sort (cost=76,278.96..76,348.64 rows=27,872 width=12) (actual time=25,764.913..25,765.394 rows=1,163 loops=1)

  • Output: id, create_date
  • Sort Key: wallet_transaction_line.create_date DESC, wallet_transaction_line.id DESC
  • Sort Method: quicksort Memory: 103kB
  • Buffers: shared hit=420433 read=56956 dirtied=3
2. 25,763.143 25,763.143 ↑ 24.0 1,163 1

Index Scan using wallet_transaction_line_sale_order_id_index on public.wallet_transaction_line (cost=0.43..74,221.10 rows=27,872 width=12) (actual time=42.534..25,763.143 rows=1,163 loops=1)

  • Output: id, create_date
  • Index Cond: (wallet_transaction_line.sale_order_id IS NOT NULL)
  • Filter: ((wallet_transaction_line.account_payment_id IS NULL) AND (wallet_transaction_line.account_move_id IS NULL) AND (wallet_transaction_line.cashback_type IS NULL))
  • Rows Removed by Filter: 545381
  • Buffers: shared hit=420433 read=56956 dirtied=3
Planning time : 0.096 ms
Execution time : 25,765.892 ms