explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Gh5J

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 499.094 574.687 ↓ 2.0 1,974 1

Hash Join (cost=89.07..697.02 rows=984 width=32) (actual time=44.755..574.687 rows=1,974 loops=1)

  • Hash Cond: ((geo_tz.aggregatti)::double precision = tz_demographic_2016.zone)
2. 30.936 30.936 ↑ 1.0 2,951 1

Seq Scan on geo_tz (cost=0.00..573.51 rows=2,951 width=4,705) (actual time=0.010..30.936 rows=2,951 loops=1)

3. 21.831 44.657 ↓ 2.0 1,940 1

Hash (cost=76.75..76.75 rows=986 width=16) (actual time=44.650..44.657 rows=1,940 loops=1)

  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 107kB
4. 22.826 22.826 ↓ 2.0 1,940 1

Seq Scan on tz_demographic_2016 (cost=0.00..76.75 rows=986 width=16) (actual time=0.010..22.826 rows=1,940 loops=1)

  • Filter: (round((pop / '1000'::double precision)) > '0'::double precision)
  • Rows Removed by Filter: 1017
Planning time : 0.117 ms
Execution time : 594.678 ms