explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7C2U : 78384 rows

Settings
# exclusive inclusive rows x rows loops node
1. 118.784 738.653 ↓ 5.9 78,384 1

WindowAgg (cost=5,773.59..10,149.32 rows=13,361 width=76) (actual time=96.131..738.653 rows=78,384 loops=1)

2. 436.858 619.869 ↓ 5.9 78,384 1

WindowAgg (cost=5,773.59..9,648.28 rows=13,361 width=60) (actual time=96.122..619.869 rows=78,384 loops=1)

3. 59.451 183.011 ↓ 5.9 78,384 1

WindowAgg (cost=5,773.59..6,007.41 rows=13,361 width=52) (actual time=96.074..183.011 rows=78,384 loops=1)

4. 87.573 123.560 ↓ 5.9 78,384 1

Sort (cost=5,773.59..5,806.99 rows=13,361 width=44) (actual time=96.060..123.560 rows=78,384 loops=1)

  • Sort Key: trip_locations."timestamp
  • Sort Method: external merge Disk: 3904kB
5. 29.162 35.987 ↓ 5.9 78,384 1

Bitmap Heap Scan on trip_locations (cost=555.97..4,857.98 rows=13,361 width=44) (actual time=7.324..35.987 rows=78,384 loops=1)

  • Recheck Cond: (("tripId")::text = 'bc1648e9145b17650dcc'::text)
  • Heap Blocks: exact=3589
6. 6.825 6.825 ↓ 5.9 78,384 1

Bitmap Index Scan on "tripLocationsTripIdIndex" (cost=0.00..552.62 rows=13,361 width=0) (actual time=6.825..6.825 rows=78,384 loops=1)

  • Index Cond: (("tripId")::text = 'bc1648e9145b17650dcc'::text)
Planning time : 0.327 ms
Execution time : 756.268 ms