explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Le9

Settings
# exclusive inclusive rows x rows loops node
1. 0.037 0.214 ↑ 2.2 24 1

Unique (cost=196.19..196.45 rows=52 width=77) (actual time=0.161..0.214 rows=24 loops=1)

2. 0.096 0.177 ↑ 1.9 27 1

Sort (cost=196.19..196.32 rows=52 width=77) (actual time=0.159..0.177 rows=27 loops=1)

  • Sort Key: preference_desc
  • Sort Method: quicksort Memory: 28kB
3. 0.060 0.081 ↑ 1.9 27 1

Bitmap Heap Scan on provider_preferences (cost=4.69..194.70 rows=52 width=77) (actual time=0.035..0.081 rows=27 loops=1)

  • Recheck Cond: ((provider_id)::text = '1'::text)
  • Filter: (eff_end_ts > now())
  • Rows Removed by Filter: 18
  • Heap Blocks: exact=20
4. 0.021 0.021 ↑ 1.2 45 1

Bitmap Index Scan on provider_preferences_provider_id_idx (cost=0.00..4.68 rows=52 width=0) (actual time=0.020..0.021 rows=45 loops=1)

  • Index Cond: ((provider_id)::text = '1'::text)