explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 68Zf

Settings
# exclusive inclusive rows x rows loops node
1. 1.070 645.127 ↑ 23.8 1,166 1

Sort (cost=75,998.61..76,068.02 rows=27,763 width=12) (actual time=644.861..645.127 rows=1,166 loops=1)

  • Sort Key: wallet_transaction_line.create_date DESC, wallet_transaction_line.id DESC
  • Sort Method: quicksort Memory: 103kB
  • Buffers: shared hit=419,827 read=56,908 written=44
2. 644.057 644.057 ↑ 23.8 1,166 1

Index Scan using wallet_transaction_line_sale_order_id_index on wallet_transaction_line wallet_transaction_line (cost=0.43..73,949.58 rows=27,763 width=12) (actual time=25.813..644.057 rows=1,166 loops=1)

  • 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))
  • Buffers: shared hit=419,827 read=56,908 written=44
Planning time : 0.072 ms
Execution time : 645.395 ms