explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Coe1

Settings
# exclusive inclusive rows x rows loops node
1. 106.607 81,167.053 ↓ 45.0 45 1

Gather (cost=3,414.51..18,276.12 rows=1 width=639) (actual time=13,631.186..81,167.053 rows=45 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 226.338 81,060.446 ↓ 15.0 15 3

Nested Loop (cost=2,414.51..17,276.02 rows=1 width=639) (actual time=7,635.674..81,060.446 rows=15 loops=3)

3. 80,263.406 80,834.097 ↓ 108.6 14,660 3

Parallel Bitmap Heap Scan on items (cost=2,413.94..16,116.03 rows=135 width=639) (actual time=499.639..80,834.097 rows=14,660 loops=3)

  • 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)))
  • Rows Removed by Filter: 2
  • Heap Blocks: exact=14278
4. 570.691 570.691 ↓ 0.0 44,802 1

Bitmap Index Scan on trgm_name_desc_idx (cost=0.00..2413.85rows=3447 width=0) (cost=0..0 rows=0 width=0) (actual time=570.691..570.691 rows=44,802 loops=1)

  • Index Cond: (name ~ '(?i)service'::text)
5. 0.011 0.011 ↓ 0.0 0 43,981

Index Only Scan using hierarchy_paths_pkey on hierarchy_paths hp (cost=0.57..8.59 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=43,981)

  • 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)
  • Heap Fetches: 14