explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DeTd

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

Gather (cost=2,177.76..16,613.94 rows=1 width=639) (actual rows= loops=)

  • Workers Planned: 2
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,177.76..15,613.84 rows=1 width=639) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Parallel Bitmap Heap Scan on items (cost=1,177.19..14,488.22 rows=131 width=639) (actual rows= loops=)

  • Recheck Cond: (name ~ '(?i)service'::text)
  • Filter: ((type = ANY ('{ThresholdMetric,Asset,CalculatedScalar,Chart,StoredCondition,CalculatedCondition,CalculatedSignal,StoredSignal}'::text[])) AND ((NOT (((properties -> 'Archived'::text) ->> 'booleanValue'::text))::boolean) OR ((((properties -> 'Archived'::text) ->> 'booleanValue'::text))::boolean IS NULL)) AND ((NOT (((properties -> 'Unsearchable'::text) ->> 'booleanValue'::text))::boolean) OR ((((properties -> 'Unsearchable'::text) ->> 'booleanValue'::text))::boolean IS NULL)))
4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on trgm_name_desc_idx (cost=0.00..1,177.11 rows=3,348 width=0) (actual rows= loops=)

  • Index Cond: (name ~ '(?i)service'::text)
5. 0.000 0.000 ↓ 0.0

Index Only Scan using hierarchy_paths_pkey on hierarchy_paths hp (cost=0.57..8.59 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((ancestor_guid = 'b961d32a-a87f-4306-ab2f-e51e0f9ecb1a'::uuid) AND (descendant_guid = items.seeq_guid))
  • Filter: (descendant_guid <> 'b961d32a-a87f-4306-ab2f-e51e0f9ecb1a'::uuid)