explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZcXo

Settings
# exclusive inclusive rows x rows loops node
1. 192.693 308.599 ↑ 1.0 155,000 1

Hash Join (cost=140.93..8,534.68 rows=157,800 width=23) (actual time=6.008..308.599 rows=155,000 loops=1)

  • Hash Cond: (measurement_np.city_id = c.city_id)
2. 109.956 109.956 ↑ 1.0 155,000 1

Index Scan using measurement_np_logdate_idx on measurement_np (cost=0.43..6,224.43 rows=157,800 width=16) (actual time=0.038..109.956 rows=155,000 loops=1)

  • Index Cond: ((logdate >= '2019-01-01'::date) AND (logdate < '2019-02-01'::date))
3. 3.031 5.950 ↑ 1.0 5,000 1

Hash (cost=78.00..78.00 rows=5,000 width=11) (actual time=5.949..5.950 rows=5,000 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 279kB
4. 2.919 2.919 ↑ 1.0 5,000 1

Seq Scan on city c (cost=0.00..78.00 rows=5,000 width=11) (actual time=0.023..2.919 rows=5,000 loops=1)

Planning time : 0.183 ms
Execution time : 384.884 ms