explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cIb3

Settings
# exclusive inclusive rows x rows loops node
1. 180.772 442.868 ↓ 1.0 155,000 1

Hash Join (cost=140.50..6,208.51 rows=154,876 width=23) (actual time=5.989..442.868 rows=155,000 loops=1)

  • Hash Cond: (measurement_p_y2019m01.city_id = city.city_id)
2. 149.012 256.143 ↑ 1.0 155,000 1

Append (cost=0.00..3,938.00 rows=155,000 width=16) (actual time=0.018..256.143 rows=155,000 loops=1)

3. 107.131 107.131 ↑ 1.0 155,000 1

Seq Scan on measurement_p_y2019m01 (cost=0.00..3,163.00 rows=155,000 width=16) (actual time=0.016..107.131 rows=155,000 loops=1)

  • Filter: ((logdate >= '2019-01-01'::date) AND (logdate < '2019-02-01'::date))
4. 3.011 5.953 ↑ 1.0 5,000 1

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

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

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