explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sKat

Settings
# exclusive inclusive rows x rows loops node
1. 0.019 0.204 ↑ 1.0 1 1

Aggregate (cost=109.00..109.20 rows=1 width=8) (actual time=0.203..0.204 rows=1 loops=1)

2. 0.136 0.185 ↓ 1.0 28 1

Bitmap Heap Scan on cards (cost=4.51..108.93 rows=27 width=0) (actual time=0.092..0.185 rows=28 loops=1)

  • Recheck Cond: (thread_reply_id = '85d4dcce-d170-4374-9754-4ba3a03e206e'::uuid)
  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=28
3. 0.049 0.049 ↑ 1.0 29 1

Bitmap Index Scan on cards_thread_reply_id_idx (cost=0.00..4.50 rows=29 width=0) (actual time=0.049..0.049 rows=29 loops=1)

  • Index Cond: (thread_reply_id = '85d4dcce-d170-4374-9754-4ba3a03e206e'::uuid)