explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cS5x

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

Limit (cost=37,125.93..37,126.00 rows=30 width=2,848) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=37,125.93..37,155.01 rows=11,633 width=2,848) (actual rows= loops=)

  • Sort Key: id DESC NULLS LAST
3. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on users (cost=358.19..36,782.35 rows=11,633 width=2,848) (actual rows= loops=)

  • Recheck Cond: (deleted_at IS NULL)
4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on <25686539>btree_users_deleted_at_id (cost=0.00..355.28 rows=11,633 width=0) (actual rows= loops=)

  • Index Cond: (deleted_at IS NULL)