explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hzRQG : select tracks

Settings
# exclusive inclusive rows x rows loops node
1. 708.216 19,371.089 ↑ 1.7 46 1

HashAggregate (cost=21,906.67..21,907.45 rows=78 width=314) (actual time=19,371.075..19,371.089 rows=46 loops=1)

  • Group Key: d.id
2. 1,119.128 18,662.873 ↓ 69.0 1,563,640 1

Hash Left Join (cost=15.19..21,566.51 rows=22,677 width=292) (actual time=2.903..18,662.873 rows=1,563,640 loops=1)

  • Hash Cond: (t.offer_id = d.id)
3. 17,542.630 17,542.630 ↓ 69.0 1,563,640 1

Index Scan using tracks_date_index on tracks t (cost=0.43..21,490.97 rows=22,677 width=18) (actual time=1.730..17,542.630 rows=1,563,640 loops=1)

  • Index Cond: ((date >= '2019-12-31 21:00:00+03'::timestamp with time zone) AND (date <= '2020-02-01 20:59:59+03'::timestamp with time zone))
4. 0.080 1.115 ↓ 1.1 89 1

Hash (cost=13.78..13.78 rows=78 width=290) (actual time=1.112..1.115 rows=89 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 15kB
5. 1.035 1.035 ↓ 1.1 89 1

Seq Scan on destinations d (cost=0.00..13.78 rows=78 width=290) (actual time=0.350..1.035 rows=89 loops=1)