explain.depesz.com

PostgreSQL's explain analyze made readable

Result: m62o

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 0.136 ↑ 1.0 20 1

Limit (cost=2.42..90.67 rows=20 width=25) (actual time=0.044..0.136 rows=20 loops=1)

2. 0.019 0.130 ↑ 1,437.2 20 1

Nested Loop (cost=2.42..126,832.31 rows=28,743 width=25) (actual time=0.044..0.130 rows=20 loops=1)

3. 0.031 0.031 ↑ 2,874.2 20 1

Index Scan using decade_rank_index on app_namepopularity (cost=0.42..7,200.12 rows=57,485 width=8) (actual time=0.012..0.031 rows=20 loops=1)

  • Index Cond: (decade = 2010)
4. 0.061 0.080 ↑ 1.0 1 20

Index Scan using app_name_pkey on app_name (cost=2.00..2.08 rows=1 width=21) (actual time=0.004..0.004 rows=1 loops=20)

  • Index Cond: (id = app_namepopularity.name_id)
  • Filter: (NOT (hashed SubPlan 1))
5.          

SubPlan (for Index Scan)

6. 0.019 0.019 ↓ 0.0 0 1

Seq Scan on app_userstonames u1 (cost=0.00..1.70 rows=1 width=4) (actual time=0.019..0.019 rows=0 loops=1)

  • Filter: (user_uuid = 'a03b8d74-161b-4b41-97ca-4ddd303b1021'::uuid)
  • Rows Removed by Filter: 94
Planning time : 0.414 ms
Execution time : 0.202 ms