explain.depesz.com

PostgreSQL's explain analyze made readable

Result: s7Qn

Settings
# exclusive inclusive rows x rows loops node
1. 0.529 265.816 ↓ 175.0 175 1

Sort (cost=91,096.71..91,096.72 rows=1 width=15) (actual time=265.805..265.816 rows=175 loops=1)

  • Sort Key: account_number
  • Sort Method: quicksort Memory: 33kB
2. 265.287 265.287 ↓ 175.0 175 1

Seq Scan on rep_account_detail (cost=0.00..91,096.70 rows=1 width=15) (actual time=3.070..265.287 rows=175 loops=1)

  • Filter: ((circ_cd IS NULL) AND (id_acc_flusso = '5000000021'::numeric))
  • Rows Removed by Filter: 2,712,041