explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TOGw

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[
  • "Plan": {
  • "Node Type": "Sort",
  • "Parallel Aware": false,
  • "Startup Cost": 75998.61,
  • "Total Cost": 76068.02,
  • "Plan Rows": 27763,
  • "Plan Width": 12,
  • "Actual Startup Time": 644.861,
  • "Actual Total Time": 645.127,
  • "Actual Rows": 1166,
  • "Actual Loops": 1,
  • "Output": [
  • "id",
  • "create_date
  • ],
  • "Sort Key": [
  • "wallet_transaction_line.create_date DESC",
  • "wallet_transaction_line.id DESC
  • ],
  • "Sort Method": "quicksort",
  • "Sort Space Used": 103,
  • "Sort Space Type": "Memory",
  • "Shared Hit Blocks": 419827,
  • "Shared Read Blocks": 56908,
  • "Shared Dirtied Blocks": 0,
  • "Shared Written Blocks": 44,
  • "Local Hit Blocks": 0,
  • "Local Read Blocks": 0,
  • "Local Dirtied Blocks": 0,
  • "Local Written Blocks": 0,
  • "Temp Read Blocks": 0,
  • "Temp Written Blocks": 0,
  • "Plans": [
  • "Node Type": "Index Scan",
  • "Parent Relationship": "Outer",
  • "Parallel Aware": false,
  • "Scan Direction": "Forward",
  • "Index Name": "wallet_transaction_line_sale_order_id_index",
  • "Relation Name": "wallet_transaction_line",
  • "Schema": "public",
  • "Alias": "wallet_transaction_line",
  • "Startup Cost": 0.43,
  • "Total Cost": 73949.58,
  • "Plan Rows": 27763,
  • "Plan Width": 12,
  • "Actual Startup Time": 25.813,
  • "Actual Total Time": 644.057,
  • "Actual Rows": 1166,
  • "Actual Loops": 1,
  • "Output": [
  • "id",
  • "create_date
  • ],
  • "Index Cond": "(wallet_transaction_line.sale_order_id IS NOT NULL)",
  • "Rows Removed by Index Recheck": 0,
  • "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": 544509,
  • "Shared Hit Blocks": 419827,
  • "Shared Read Blocks": 56908,
  • "Shared Dirtied Blocks": 0,
  • "Shared Written Blocks": 44,
  • "Local Hit Blocks": 0,
  • "Local Read Blocks": 0,
  • "Local Dirtied Blocks": 0,
  • "Local Written Blocks": 0,
  • "Temp Read Blocks": 0,
  • "Temp Written Blocks": 0
  • },
  • "Planning Time": 0.072,
  • "Triggers": [
  • ],
  • "Execution Time": 645.395
  • Buffers: shared hit=420433 read=56956 dirtied=3
Planning time : 0.096 ms
Execution time : 25,765.892 ms