explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wv7b

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 2.812 ↓ 0.0 0 1

Sort (cost=3,788.52..3,788.53 rows=1 width=617) (actual time=2.812..2.812 rows=0 loops=1)

  • Sort Key: created_on DESC
  • Sort Method: quicksort Memory: 25kB
2. 2.524 2.803 ↓ 0.0 0 1

Bitmap Heap Scan on table_logs tl (cost=24.14..3,788.51 rows=1 width=617) (actual time=2.803..2.803 rows=0 loops=1)

  • Recheck Cond: (cid = 1106)
  • Filter: (((table_name)::text = 'contract_properties'::text) AND (reference_number = 96228))
  • Rows Removed by Filter: 1491
  • Heap Blocks: exact=898
3. 0.279 0.279 ↓ 1.5 1,491 1

Bitmap Index Scan on idx_cid_table_logs (cost=0.00..24.14 rows=1,027 width=0) (actual time=0.279..0.279 rows=1,491 loops=1)

  • Index Cond: (cid = 1106)