explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eUqx

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.133 ↑ 1.0 1 1

Limit (cost=12.32..12.33 rows=1 width=392) (actual time=0.132..0.133 rows=1 loops=1)

2. 0.085 0.130 ↑ 2.0 1 1

Sort (cost=12.32..12.33 rows=2 width=392) (actual time=0.130..0.130 rows=1 loops=1)

  • Sort Key: created_at DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.019 0.045 ↑ 2.0 1 1

Bitmap Heap Scan on cards (cost=4.30..12.31 rows=2 width=392) (actual time=0.044..0.045 rows=1 loops=1)

  • Recheck Cond: (thread_reply_id = 'efd1be89-070c-4a17-a5a4-b5becd463589'::uuid)
  • Filter: ((deleted_at IS NULL) AND (shadowbanned_at IS NULL) AND (owner_id <> '405ae78a-9f7d-4ef8-8224-42011b4fadac'::uuid))
  • Heap Blocks: exact=1
4. 0.026 0.026 ↑ 2.0 1 1

Bitmap Index Scan on cards_thread_reply_id_idx (cost=0.00..4.30 rows=2 width=0) (actual time=0.026..0.026 rows=1 loops=1)

  • Index Cond: (thread_reply_id = 'efd1be89-070c-4a17-a5a4-b5becd463589'::uuid)