explain.depesz.com

PostgreSQL's explain analyze made readable

Result: A2uw

Settings
# exclusive inclusive rows x rows loops node
1. 2.329 2.518 ↓ 45.0 45 1

Merge Join (cost=144.89..213.36 rows=1 width=136) (actual time=2.301..2.518 rows=45 loops=1)

  • Merge Cond: (gpa.orderid = gpa_1.orderid)
  • Join Filter: ((gpa.gid = gpa_1.gid) AND ((row_number() OVER (?)) = ((row_number() OVER (?)) - 1)))
  • Rows Removed by Join Filter: 1206
2. 0.017 0.097 ↑ 11.2 49 1

WindowAgg (cost=72.44..83.44 rows=550 width=128) (actual time=0.086..0.097 rows=49 loops=1)

3. 0.033 0.080 ↑ 11.2 49 1

Sort (cost=72.44..73.82 rows=550 width=120) (actual time=0.079..0.080 rows=49 loops=1)

  • Sort Key: gpa.orderid, gpa."time
  • Sort Method: quicksort Memory: 38kB
4. 0.006 0.047 ↑ 11.2 49 1

Subquery Scan on gpa (cost=40.53..47.41 rows=550 width=120) (actual time=0.040..0.047 rows=49 loops=1)

5. 0.023 0.041 ↑ 11.2 49 1

Sort (cost=40.53..41.91 rows=550 width=120) (actual time=0.039..0.041 rows=49 loops=1)

  • Sort Key: tgps_lite.rownum
  • Sort Method: quicksort Memory: 38kB
6. 0.018 0.018 ↑ 11.2 49 1

Seq Scan on tgps_lite (cost=0.00..15.50 rows=550 width=120) (actual time=0.007..0.018 rows=49 loops=1)

7. 0.035 0.092 ↓ 2.2 1,235 1

Materialize (cost=72.44..90.32 rows=550 width=80) (actual time=0.049..0.092 rows=1,235 loops=1)

8. 0.012 0.057 ↑ 11.2 49 1

WindowAgg (cost=72.44..83.44 rows=550 width=128) (actual time=0.046..0.057 rows=49 loops=1)

9. 0.021 0.045 ↑ 11.2 49 1

Sort (cost=72.44..73.82 rows=550 width=72) (actual time=0.044..0.045 rows=49 loops=1)

  • Sort Key: gpa_1.orderid, gpa_1."time
  • Sort Method: quicksort Memory: 31kB
10. 0.003 0.024 ↑ 11.2 49 1

Subquery Scan on gpa_1 (cost=40.53..47.41 rows=550 width=72) (actual time=0.020..0.024 rows=49 loops=1)

11. 0.012 0.021 ↑ 11.2 49 1

Sort (cost=40.53..41.91 rows=550 width=120) (actual time=0.020..0.021 rows=49 loops=1)

  • Sort Key: tgps_lite_1.rownum
  • Sort Method: quicksort Memory: 31kB
12. 0.009 0.009 ↑ 11.2 49 1

Seq Scan on tgps_lite tgps_lite_1 (cost=0.00..15.50 rows=550 width=120) (actual time=0.005..0.009 rows=49 loops=1)

Planning time : 0.405 ms
Execution time : 2.641 ms