explain.depesz.com

PostgreSQL's explain analyze made readable

Result: U774

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 484.448 ↑ 1.0 1 1

Nested Loop Left Join (cost=134,117.85..134,125.90 rows=1 width=48) (actual time=484.444..484.448 rows=1 loops=1)

  • Functions: 9
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 4.175 ms, Inlining 0.000 ms, Optimization 1.252 ms, Emission 13.770 ms, Total 19.197 ms
2. 0.054 0.054 ↑ 1.0 1 1

Index Scan using platform_profiles_pkey on platform_profiles pp (cost=0.15..8.17 rows=1 width=16) (actual time=0.051..0.054 rows=1 loops=1)

  • Index Cond: ((platform_id = 1) AND (platform_user_id = '475803795'::text))
3. 0.054 484.382 ↑ 1.0 1 1

Aggregate (cost=134,117.70..134,117.71 rows=1 width=32) (actual time=484.381..484.382 rows=1 loops=1)

4. 484.328 484.328 ↓ 1.2 7 1

Seq Scan on ""values"" (cost=0.00..134,117.68 rows=6 width=13) (actual time=15.332..484.328 rows=7 loops=1)

  • Filter: ((scope_id = 200) AND (scope_entity_id = pp.id))
  • Rows Removed by Filter: 5,999,994
Planning time : 0.164 ms
Execution time : 488.772 ms