explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ubDH

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 0.696 ↓ 1.6 36 1

Unique (cost=46.27..46.38 rows=22 width=412) (actual time=0.683..0.696 rows=36 loops=1)

2. 0.069 0.685 ↓ 2.1 46 1

Sort (cost=46.27..46.32 rows=22 width=412) (actual time=0.682..0.685 rows=46 loops=1)

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

Index Scan using dba_idx_factuphiststmtfinancial_entityid on factuphiststmtfinancial (cost=0.43..45.78 rows=22 width=412) (actual time=0.080..0.616 rows=46 loops=1)

  • Index Cond: (((entityid)::text = '11496'::text) AND (isdeleted_ = false))
  • Filter: (NOT isdeleted_)