explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ayGj

Settings
# exclusive inclusive rows x rows loops node
1. 0.301 57.281 ↑ 1.0 1 1

Hash Join (cost=6.04..19.89 rows=1 width=112) (actual time=57.243..57.281 rows=1 loops=1)

  • Hash Cond: (pg_timezone_names.name = (tz_1.time_zone)::text)
2. 56.913 56.913 ↓ 1.2 1,212 1

Function Scan on pg_timezone_names (cost=0.00..10.00 rows=1,000 width=48) (actual time=56.713..56.913 rows=1,212 loops=1)

3. 0.003 0.067 ↑ 1.0 1 1

Hash (cost=6.03..6.03 rows=1 width=65) (actual time=0.067..0.067 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
4. 0.017 0.064 ↑ 1.0 1 1

Hash Join (cost=4.45..6.03 rows=1 width=65) (actual time=0.051..0.064 rows=1 loops=1)

  • Hash Cond: ((tz_1.time_zone)::text = (tz.time_zone)::text)
5. 0.010 0.010 ↑ 1.0 41 1

Seq Scan on time_zone tz_1 (cost=0.00..1.41 rows=41 width=16) (actual time=0.003..0.010 rows=41 loops=1)

6. 0.005 0.037 ↑ 1.0 1 1

Hash (cost=4.44..4.44 rows=1 width=49) (actual time=0.037..0.037 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.006 0.032 ↑ 1.0 1 1

Nested Loop (cost=0.28..4.44 rows=1 width=49) (actual time=0.031..0.032 rows=1 loops=1)

  • Join Filter: (u.time_zone_id = tz.id)
  • Rows Removed by Join Filter: 6
8. 0.024 0.024 ↑ 1.0 1 1

Index Scan using pk_app_user on app_user u (cost=0.28..2.52 rows=1 width=4) (actual time=0.024..0.024 rows=1 loops=1)

  • Index Cond: (id = 1236)
9. 0.002 0.002 ↑ 5.9 7 1

Seq Scan on time_zone tz (cost=0.00..1.41 rows=41 width=49) (actual time=0.001..0.002 rows=7 loops=1)