explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HHqF

Settings
# exclusive inclusive rows x rows loops node
1. 32.318 155.840 ↑ 4,968.2 12 1

Nested Loop (cost=4,472.66..6,051.25 rows=59,618 width=37) (actual time=81.215..155.840 rows=12 loops=1)

2.          

CTE paths

3. 21.409 23.807 ↓ 2.2 2,587 1

Bitmap Heap Scan on organizations (cost=165.60..4,445.56 rows=1,186 width=122) (actual time=2.696..23.807 rows=2,587 loops=1)

  • Recheck Cond: (path ~ 'root.2db04824152a46c2993905dac5fe3033.*{1,}'::lquery)
  • Heap Blocks: exact=2113
4. 2.398 2.398 ↓ 2.2 2,587 1

Bitmap Index Scan on path_gist_idx (cost=0.00..165.31 rows=1,186 width=0) (actual time=2.393..2.398 rows=2,587 loops=1)

  • Index Cond: (path ~ 'root.2db04824152a46c2993905dac5fe3033.*{1,}'::lquery)
5. 34.931 95.065 ↓ 12.9 2,587 1

HashAggregate (cost=26.68..28.68 rows=200 width=90) (actual time=79.002..95.065 rows=2,587 loops=1)

  • Group Key: (paths.id)::text
6. 60.134 60.134 ↓ 2.2 2,587 1

CTE Scan on paths (cost=0.00..23.72 rows=1,186 width=90) (actual time=2.719..60.134 rows=2,587 loops=1)

7. 28.457 28.457 ↓ 0.0 0 2,587

Index Only Scan using hostname_organization_id_idx on hostname h (cost=0.42..7.88 rows=1 width=37) (actual time=0.011..0.011 rows=0 loops=2,587)

  • Index Cond: (organization_id = (paths.id)::text)
  • Heap Fetches: 12
Planning time : 0.644 ms
Execution time : 156.227 ms