explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jgpZ : Optimization for: Optimization for: Optimization for: Optimization for: plan #inB6; plan #vEcT; plan #upJl; plan #T8xt

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.011 2.490 ↑ 1.0 1 1

Aggregate (cost=53,169.36..53,169.37 rows=1 width=8) (actual time=2.490..2.490 rows=1 loops=1)

2. 0.627 2.479 ↓ 0.0 0 1

Sort (cost=53,168.11..53,168.32 rows=83 width=8) (actual time=2.479..2.479 rows=0 loops=1)

  • Sort Key: x2.created DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.014 1.852 ↓ 0.0 0 1

Hash Join (cost=962.35..53,165.46 rows=83 width=8) (actual time=1.852..1.852 rows=0 loops=1)

  • Hash Cond: (fake_profile_ancestor_view.child_profile_id = x2.aggregate_id)
4. 0.005 0.046 ↓ 0.0 0 1

Bitmap Heap Scan on fake_profile_ancestor_view (cost=860.07..52,923.18 rows=37,115 width=16) (actual time=0.046..0.046 rows=0 loops=1)

  • Recheck Cond: (parent_profile_id = 1aea7152-1fd3-45c1-b4f6-03639a6acc73::uuid)
5. 0.041 0.041 ↓ 0.0 0 1

Bitmap Index Scan on dummy_index (cost=0.00..850.79 rows=37,115 width=0) (actual time=0.041..0.041 rows=0 loops=1)

  • Index Cond: (parent_profile_id = 1aea7152-1fd3-45c1-b4f6-03639a6acc73::uuid)
6. 0.008 1.792 ↑ 1.0 6 1

Hash (cost=102.20..102.20 rows=6 width=24) (actual time=1.791..1.792 rows=6 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
7. 0.013 1.784 ↑ 1.0 6 1

Nested Loop (cost=0.28..102.20 rows=6 width=24) (actual time=0.045..1.784 rows=6 loops=1)

8. 1.573 1.573 ↑ 1.0 6 1

Seq Scan on partner_user_roles (cost=0.00..56.41 rows=6 width=8) (actual time=0.024..1.573 rows=6 loops=1)

  • Filter: (role = AGENT::text)
  • Rows Removed by Filter: 2,667
9. 0.198 0.198 ↑ 1.0 1 6

Index Scan using partner_user_profiles_pkey on partner_user_profiles x2 (cost=0.28..7.63 rows=1 width=32) (actual time=0.033..0.033 rows=1 loops=6)

  • Index Cond: (id = partner_user_roles.user_profile_id)