explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XTO

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

"Limit (cost=122.33..122.50 rows=67 width=532) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=122.33..122.50 rows=67 width=532) (actual rows= loops=)

  • Sort Key: updatedon DESC
3. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on nomination (cost=4.80..120.30 rows=67 width=532) (actual rows= loops=)

  • Recheck Cond: ((organisation_id)::text = 'b8c2d284-7450-4876-baf3-bb3b95f7fe47'::text)
4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on pk_nomination_updatedon_orgid (cost=0.00..4.78 rows=67 width=0) (actual rows= loops=)

  • Index Cond: ((organisation_id)::text = 'b8c2d284-7450-4876-baf3-bb3b95f7fe47'::text)