explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SxIG : ddd

Settings
# exclusive inclusive rows x rows loops node
1. 0.089 26.632 ↓ 44.0 44 1

Bitmap Heap Scan on ctd_flex_attributes (cost=2,711.11..2,715.13 rows=1 width=150) (actual time=26.554..26.632 rows=44 loops=1)

  • Recheck Cond: ((flex_attributable_id = ANY ('{775,776,886,890}'::integer[])) AND ((type)::text = 'Ctd::ModelInstanceFlexAttribute'::text))
  • Heap Blocks: exact=19
2. 0.023 26.543 ↓ 0.0 0 1

BitmapAnd (cost=2,711.11..2,711.11 rows=1 width=0) (actual time=26.543..26.543 rows=0 loops=1)

3. 0.132 0.132 ↑ 10.8 174 1

Bitmap Index Scan on index_ctd_flex_attributes_on_flex_attributable_id (cost=0.00..48.31 rows=1,872 width=0) (actual time=0.131..0.132 rows=174 loops=1)

  • Index Cond: (flex_attributable_id = ANY ('{775,776,886,890}'::integer[]))
4. 26.388 26.388 ↓ 1.3 89,033 1

Bitmap Index Scan on index_ctd_flex_attributes_on_type_and_position (cost=0.00..2,662.55 rows=69,064 width=0) (actual time=26.388..26.388 rows=89,033 loops=1)

  • Index Cond: ((type)::text = 'Ctd::ModelInstanceFlexAttribute'::text)
Planning time : 0.201 ms