explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Flvm

Settings
# exclusive inclusive rows x rows loops node
1. 0.333 21.909 ↑ 8.5 12 1

Nested Loop (cost=3,311.43..4,136.97 rows=102 width=37) (actual time=21.276..21.909 rows=12 loops=1)

2.          

CTE paths

3. 20.914 20.914 ↑ 8.4 12 1

Seq Scan on suborg_hostnames (cost=0.00..3,308.74 rows=101 width=130) (actual time=0.029..20.914 rows=12 loops=1)

  • Filter: (path ~ 'root.2db04824152a46c2993905dac5fe3033.*{1,}'::lquery)
  • Rows Removed by Filter: 100527
4. 0.197 21.312 ↑ 8.4 12 1

HashAggregate (cost=2.27..3.28 rows=101 width=90) (actual time=21.225..21.312 rows=12 loops=1)

  • Group Key: (paths.organization_id)::text
5. 21.115 21.115 ↑ 8.4 12 1

CTE Scan on paths (cost=0.00..2.02 rows=101 width=90) (actual time=0.051..21.115 rows=12 loops=1)

6. 0.264 0.264 ↑ 1.0 1 12

Index Only Scan using hostname_organization_id_idx on hostname h (cost=0.42..8.16 rows=1 width=37) (actual time=0.015..0.022 rows=1 loops=12)

  • Index Cond: (organization_id = (paths.organization_id)::text)
  • Heap Fetches: 12
Planning time : 0.691 ms
Execution time : 22.105 ms