explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Es0J

Settings
# exclusive inclusive rows x rows loops node
1. 0.883 306.997 ↑ 24.0 1,159 1

Sort (cost=75,998.61..76,068.02 rows=27,763 width=12) (actual time=306.74..306.997 rows=1,159 loops=1)

  • Sort Key: wallet_transaction_line.create_date DESC, wallet_transaction_line.id DESC
  • Sort Method: quicksort Memory: 103kB
  • Buffers: shared hit=476730
2. 306.114 306.114 ↑ 24.0 1,159 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=15.243..306.114 rows=1,159 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=476730
Planning time : 0.092 ms
Execution time : 307.284 ms