explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Sj7H

Settings
# exclusive inclusive rows x rows loops node
1. 4.658 45,050.094 ↑ 6.6 79 1

Gather (cost=1,049.87..15,018.28 rows=523 width=147) (actual time=4,419.644..45,050.094 rows=79 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
2. 34,676.499 45,045.436 ↑ 7.7 40 2

Nested Loop (cost=49.87..13,965.98 rows=308 width=147) (actual time=5,455.067..45,045.436 rows=40 loops=2)

3. 161.229 10,181.502 ↑ 7.0 186 2

Hash Join (cost=49.45..11,182.21 rows=1,307 width=27) (actual time=361.956..10,181.502 rows=186 loops=2)

  • Hash Cond: (daily_alarm.time_zone_id = time_zone.id)
  • Join Filter: (('07:15:00'::time without time zone)::time with time zone = timezone('utc'::text, (timezone((time_zone.name)::text, (daily_alarm.th)::time with time zone) - pg_timezone_names.utc_offset)))
  • Rows Removed by Join Filter: 100054
4. 10,001.763 10,001.763 ↑ 1.2 100,240 2

Parallel Seq Scan on daily_alarm (cost=0.00..4,006.97 rows=118,393 width=16) (actual time=306.806..10,001.763 rows=100,240 loops=2)

  • Filter: (th IS NOT NULL)
  • Rows Removed by Filter: 0
5. 0.159 18.510 ↑ 2.2 453 2

Hash (cost=36.95..36.95 rows=1,000 width=35) (actual time=18.510..18.510 rows=453 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 40kB
6. 0.358 18.351 ↑ 2.2 453 2

Hash Join (cost=13.20..36.95 rows=1,000 width=35) (actual time=17.918..18.351 rows=453 loops=2)

  • Hash Cond: (pg_timezone_names.name = (time_zone.name)::text)
7. 17.680 17.680 ↑ 1.7 592 2

Function Scan on pg_timezone_names (cost=0.00..10.00 rows=1,000 width=48) (actual time=17.560..17.680 rows=592 loops=2)

8. 0.168 0.313 ↑ 1.0 453 2

Hash (cost=7.53..7.53 rows=453 width=19) (actual time=0.313..0.313 rows=453 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 32kB
9. 0.145 0.145 ↑ 1.0 453 2

Seq Scan on time_zone (cost=0.00..7.53 rows=453 width=19) (actual time=0.017..0.145 rows=453 loops=2)

10. 187.435 187.435 ↓ 0.0 0 372

Index Scan using device_pkey on device (cost=0.43..2.13 rows=1 width=124) (actual time=187.435..187.435 rows=0 loops=372)

  • Index Cond: (id = daily_alarm.device_id)
  • Filter: ((push_token IS NOT NULL) AND (status = 0))
  • Rows Removed by Filter: 1
Planning time : 1,437.907 ms
Execution time : 45,050.255 ms