explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IU3P : Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: plan #DvmL; plan #ktWN; plan #MZj; plan #7w9C; plan #auss

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.015 0.104 ↓ 1.8 7 1

Limit (cost=16.67..16.68 rows=4 width=221) (actual time=0.086..0.104 rows=7 loops=1)

2. 0.044 0.089 ↓ 1.8 7 1

Sort (cost=16.67..16.68 rows=4 width=221) (actual time=0.083..0.089 rows=7 loops=1)

  • Sort Key: is_use_stars, create_txtime
  • Sort Method: quicksort Memory: 26kB
3. 0.027 0.045 ↓ 1.8 7 1

Bitmap Heap Scan on reviews r (cost=4.32..16.63 rows=4 width=221) (actual time=0.031..0.045 rows=7 loops=1)

  • Recheck Cond: ((recipient_id = 121201089) AND (status = 1))
  • Filter: (shop_id IS NULL)
  • Heap Blocks: exact=3
4. 0.018 0.018 ↓ 1.8 7 1

Bitmap Index Scan on reviews_recipient_id_status_index (cost=0.00..4.32 rows=4 width=0) (actual time=0.018..0.018 rows=7 loops=1)

  • Index Cond: ((recipient_id = 121201089) AND (status = 1))