explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zesF : Test

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

Sort (cost=1,571.03..1,571.03 rows=1 width=342) (actual rows= loops=)

  • Sort Key: last_answer_created_at DESC
2. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on questions (cost=11.74..1,571.02 rows=1 width=342) (actual rows= loops=)

  • Recheck Cond: (deleted_at IS NULL)
  • Filter: ((promo IS TRUE) AND (hide IS NULL) AND (created_at > '2019-07-09 08:30:07.060002'::timestamp without time zone))
3. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on index_questions_on_deleted_at (cost=0.00..11.74 rows=460 width=0) (actual rows= loops=)

  • Index Cond: (deleted_at IS NULL)