explain.depesz.com

PostgreSQL's explain analyze made readable

Result: t0z : Of-prob1

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 0.773 ↓ 0.0 0 1

Nested Loop (cost=10.73..36.13 rows=1 width=0) (actual time=0.773..0.773 rows=0 loops=1)

2. 0.759 0.759 ↓ 0.0 0 1

Seq Scan on cfg_dimension_value cdv (cost=0.00..21.38 rows=1 width=5) (actual time=0.759..0.759 rows=0 loops=1)

  • Filter: ((value)::text = '1234'::text)
  • Rows Removed by Filter: 830
3. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on dta_dimension_combo ddc (cost=10.73..14.74 rows=1 width=5) (never executed)

  • Recheck Cond: ((dimension_set_id = 12344::numeric) AND (dimension_value_id = cdv.id))
4. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=10.73..10.73 rows=1 width=0) (never executed)

5. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on dim_set_combo_dim_set_fk_i (cost=0.00..5.06 rows=102 width=0) (never executed)

  • Index Cond: (dimension_set_id = 12344::numeric)
6. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on dim_set_combo_dim_value_fk_i (cost=0.00..5.40 rows=147 width=0) (never executed)

  • Index Cond: (dimension_value_id = cdv.id)
Planning time : 1.487 ms
Execution time : 0.884 ms