explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1dq5

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on t_attribute (cost=228.22..2,716.77 rows=1,770 width=244) (actual rows= loops=)

  • Recheck Cond: (c_attribute_value_jsonb @> '{"type": "Vin"}'::jsonb)
2. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on t_attribute_jsonb_value_idx (cost=0.00..227.78 rows=1,770 width=0) (actual rows= loops=)

  • Index Cond: (c_attribute_value_jsonb @> '{"type": "Vin"}'::jsonb)