explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Y0s8

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.072 7,234.407 ↑ 1.0 1,000 1

Limit (cost=350,735.03..350,773.57 rows=1,000 width=1,208) (actual time=7,230.751..7,234.407 rows=1,000 loops=1)

2. 3.905 7,234.335 ↑ 959.7 1,000 1

Hash Left Join (cost=350,735.03..387,721.88 rows=959,672 width=1,208) (actual time=7,230.750..7,234.335 rows=1,000 loops=1)

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

Seq Scan on trackers (cost=0.00..36,483.02 rows=959,672 width=1,160) (actual time=0.008..2.349 rows=2,067 loops=1)

4. 312.254 7,228.081 ↓ 2.6 831,025 1

Hash (cost=349,595.72..349,595.72 rows=325,519 width=48) (actual time=7,228.081..7,228.081 rows=831,025 loops=1)

  • Buckets: 1,048,576 (originally 524288) Batches: 2 (originally 1) Memory Usage: 57,345kB
5. 4,011.383 6,915.827 ↓ 2.6 831,025 1

HashAggregate (cost=347,642.60..348,619.16 rows=325,519 width=48) (actual time=6,652.141..6,915.827 rows=831,025 loops=1)

  • Group Key: tracking_details.tracker_id
6. 2,904.444 2,904.444 ↑ 1.0 11,283,583 1

Seq Scan on tracking_details (cost=0.00..330,504.00 rows=11,425,733 width=40) (actual time=0.026..2,904.444 rows=11,283,583 loops=1)

  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 804,403
Planning time : 0.245 ms
Execution time : 7,254.343 ms