explain.depesz.com

PostgreSQL's explain analyze made readable

Result: S2CB

Settings
# exclusive inclusive rows x rows loops node
1. 0.075 0.270 ↑ 89,143.3 20 1

Sort (cost=749,118.87..753,576.03 rows=1,782,866 width=313) (actual time=0.268..0.270 rows=20 loops=1)

  • Sort Key: created_at
  • Sort Method: quicksort Memory: 30kB
2. 0.134 0.195 ↑ 89,143.3 20 1

Bitmap Heap Scan on eatery_comments (cost=33,361.64..301,971.47 rows=1,782,866 width=313) (actual time=0.079..0.195 rows=20 loops=1)

  • Recheck Cond: (order_id > 0)
  • Heap Blocks: exact=20
3. 0.061 0.061 ↑ 89,143.3 20 1

Bitmap Index Scan on eatery_comments_order_id_idx (cost=0.00..32,915.93 rows=1,782,866 width=0) (actual time=0.061..0.061 rows=20 loops=1)

  • Index Cond: (order_id > 0)