explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ATNt

Settings
# exclusive inclusive rows x rows loops node
1. 0.073 6,737.481 ↑ 1.0 1,000 1

Limit (cost=345,864.27..345,902.81 rows=1,000 width=1,200) (actual time=6,735.931..6,737.481 rows=1,000 loops=1)

2. 3.744 6,737.408 ↑ 959.7 1,000 1

Hash Left Join (cost=345,864.27..382,852.22 rows=959,700 width=1,200) (actual time=6,735.930..6,737.408 rows=1,000 loops=1)

  • Hash Cond: ((trackers.id)::text = (tracking_details.tracker_id)::text)
3. 0.300 0.300 ↑ 464.3 2,067 1

Seq Scan on trackers (cost=0.00..36,484.10 rows=959,700 width=1,160) (actual time=0.010..0.300 rows=2,067 loops=1)

4. 302.972 6,733.364 ↓ 2.7 872,636 1

Hash (cost=344,724.95..344,724.95 rows=325,519 width=40) (actual time=6,733.364..6,733.364 rows=872,636 loops=1)

  • Buckets: 1048576 (originally 524288) Batches: 2 (originally 1) Memory Usage: 57345kB
5. 4,525.281 6,430.392 ↓ 2.7 872,636 1

HashAggregate (cost=342,771.84..343,748.40 rows=325,519 width=40) (actual time=6,156.408..6,430.392 rows=872,636 loops=1)

  • Group Key: tracking_details.tracker_id
6. 1,905.111 1,905.111 ↑ 1.0 12,088,183 1

Seq Scan on tracking_details (cost=0.00..330,509.63 rows=12,262,210 width=40) (actual time=0.022..1,905.111 rows=12,088,183 loops=1)

Planning time : 0.234 ms
Execution time : 6,755.368 ms