explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0Pz : my plan

Settings
# exclusive inclusive rows x rows loops node
1. 14.325 85.539 ↑ 1.0 9,798 1

WindowAgg (cost=4,174.69..7,391.73 rows=9,823 width=76) (actual time=7.828..85.539 rows=9,798 loops=1)

2. 53.356 71.214 ↑ 1.0 9,798 1

WindowAgg (cost=4,174.69..7,023.36 rows=9,823 width=60) (actual time=7.824..71.214 rows=9,798 loops=1)

3. 7.208 17.858 ↑ 1.0 9,798 1

WindowAgg (cost=4,174.69..4,346.60 rows=9,823 width=52) (actual time=7.797..17.858 rows=9,798 loops=1)

4. 6.472 10.650 ↑ 1.0 9,798 1

Sort (cost=4,174.69..4,199.25 rows=9,823 width=44) (actual time=7.791..10.650 rows=9,798 loops=1)

  • Sort Key: trip_locations."timestamp
  • Sort Method: quicksort Memory: 1150kB
5. 3.341 4.178 ↑ 1.0 9,798 1

Bitmap Heap Scan on trip_locations (cost=360.55..3,523.33 rows=9,823 width=44) (actual time=0.877..4.178 rows=9,798 loops=1)

  • Recheck Cond: (("tripId")::text = 'bc1648e9145b17650dcc'::text)
  • Heap Blocks: exact=340
6. 0.837 0.837 ↑ 1.0 9,798 1

Bitmap Index Scan on "tripLocationsTripIdIndex" (cost=0.00..358.09 rows=9,823 width=0) (actual time=0.836..0.837 rows=9,798 loops=1)

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