explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ky62

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 12.590 ↓ 1.6 36 1

Unique (cost=45.37..45.48 rows=22 width=412) (actual time=12.576..12.590 rows=36 loops=1)

2. 0.101 12.578 ↓ 2.1 46 1

Sort (cost=45.37..45.42 rows=22 width=412) (actual time=12.575..12.578 rows=46 loops=1)

  • Sort Key: statementid, versionid_ DESC
  • Sort Method: quicksort Memory: 48kB
3. 12.477 12.477 ↓ 2.1 46 1

Index Scan using dba_idx_factuphiststmtfinancial_entityid on factuphiststmtfinancial (cost=0.43..44.88 rows=22 width=412) (actual time=0.764..12.477 rows=46 loops=1)

  • Index Cond: ((entityid)::text = '11496'::text)
  • Filter: (NOT isdeleted_)
  • Rows Removed by Filter: 26