explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hwLL

Settings
# exclusive inclusive rows x rows loops node
1. 1.895 24,689.373 ↑ 23.8 1,164 1

Sort (cost=75,976.41..76,045.80 rows=27,754 width=12) (actual time=24,689.033..24,689.373 rows=1,164 loops=1)

  • Sort Key: create_date DESC, id DESC
  • Sort Method: quicksort Memory: 103kB
2. 24,687.478 24,687.478 ↑ 23.8 1,164 1

Index Scan using wallet_transaction_line_sale_order_id_index on wallet_transaction_line (cost=0.43..73,928.11 rows=27,754 width=12) (actual time=1,622.965..24,687.478 rows=1,164 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: 544291
Planning time : 0.090 ms
Execution time : 24,689.694 ms