explain.depesz.com

PostgreSQL's explain analyze made readable

Result: t7xA

Settings
# exclusive inclusive rows x rows loops node
1. 1.106 574.459 ↑ 24.0 1,155 1

Sort (cost=75,972.97..76,042.35 rows=27,753 width=12) (actual time=574.196..574.459 rows=1,155 loops=1)

  • Sort Key: create_date DESC, id DESC
  • Sort Method: quicksort Memory: 103kB
2. 573.353 573.353 ↑ 24.0 1,155 1

Index Scan using wallet_transaction_line_sale_order_id_index on wallet_transaction_line (cost=0.43..73,924.75 rows=27,753 width=12) (actual time=25.760..573.353 rows=1,155 loops=1)

  • Index Cond: (sale_order_id IS NOT NULL)
  • Filter: ((account_payment_id IS NULL) AND (account_move_id IS NULL) AND (cashback_type IS NULL))
  • Rows Removed by Filter: 544256
Planning time : 0.116 ms
Execution time : 574.724 ms