explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7oBn

Settings
# exclusive inclusive rows x rows loops node
1. 83.384 402.864 ↓ 2.7 39,840 1

Nested Loop (cost=1.00..50,459.83 rows=15,005 width=734) (actual time=0.191..402.864 rows=39,840 loops=1)

  • Buffers: shared hit=198,607
2. 80.440 80.440 ↓ 2.5 39,840 1

Index Scan using index_routes_on_path_text_pattern_ops_and_source_type on public.routes rs (cost=0.56..3.59 rows=15,658 width=4) (actual time=0.170..80.440 rows=39,840 loops=1)

  • Index Cond: (((rs.path)::text ~>=~ 'gbobject/'::text) AND ((rs.path)::text ~<~ 'gbobject0'::text) AND ((rs.source_type)::text = 'Project'::text))
  • Filter: ((rs.path)::text ~~ 'gbobject/%'::text)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=39,150
3. 239.040 239.040 ↑ 1.0 1 39,840

Index Scan using projects_pkey on public.projects (cost=0.43..3.22 rows=1 width=734) (actual time=0.006..0.006 rows=1 loops=39,840)

  • Index Cond: (projects.id = rs.source_id)
  • Buffers: shared hit=159,457