explain.depesz.com

PostgreSQL's explain analyze made readable

Result: k8TV

Settings
# exclusive inclusive rows x rows loops node
1. 0.248 439.965 ↓ 1.0 218 1

Sort (cost=53,610.86..53,611.39 rows=211 width=250) (actual time=439.932..439.965 rows=218 loops=1)

  • Sort Key: u."timestamp" DESC
  • Sort Method: quicksort Memory: 82kB
2. 127.552 439.717 ↓ 1.0 218 1

Hash Join (cost=43,347.18..53,602.72 rows=211 width=250) (actual time=313.270..439.717 rows=218 loops=1)

  • Hash Cond: (u.near_zip = z.id)
3. 0.117 0.155 ↓ 1.0 218 1

Bitmap Heap Scan on user_gps u (cost=4.11..30.75 rows=211 width=173) (actual time=0.052..0.155 rows=218 loops=1)

  • Recheck Cond: (user_id = 26159)
  • Heap Blocks: exact=16
4. 0.038 0.038 ↓ 1.0 221 1

Bitmap Index Scan on user_gps_user_id_timestamp_idx (cost=0.00..4.06 rows=211 width=0) (actual time=0.038..0.038 rows=221 loops=1)

  • Index Cond: (user_id = 26159)
5. 222.720 312.010 ↑ 1.0 950,803 1

Hash (cost=21,244.03..21,244.03 rows=950,803 width=64) (actual time=312.010..312.010 rows=950,803 loops=1)

  • Buckets: 262144 Batches: 8 Memory Usage: 13623kB
6. 89.290 89.290 ↑ 1.0 950,803 1

Seq Scan on zip_loc z (cost=0.00..21,244.03 rows=950,803 width=64) (actual time=0.016..89.290 rows=950,803 loops=1)

Planning time : 1.440 ms
Execution time : 440.140 ms