explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XAlJ

Settings
# exclusive inclusive rows x rows loops node
1. 14.313 97.816 ↑ 1.0 32,045 1

Hash Left Join (cost=4,276.27..11,851.11 rows=32,045 width=106) (actual time=50.157..97.816 rows=32,045 loops=1)

  • Hash Cond: ((schds.schedule_id = rs.schedule_id) AND (((row_number() OVER (?) + 1)) = rs.idx))
2. 19.118 33.487 ↑ 1.0 32,045 1

WindowAgg (cost=0.29..3,554.97 rows=32,045 width=127) (actual time=0.086..33.487 rows=32,045 loops=1)

3. 14.369 14.369 ↑ 1.0 32,045 1

Index Scan using schedule_stop_idx1 on schedule_stop schds (cost=0.29..2,914.07 rows=32,045 width=51) (actual time=0.075..14.369 rows=32,045 loops=1)

4. 9.658 50.016 ↑ 1.0 32,045 1

Hash (cost=3,795.31..3,795.31 rows=32,045 width=75) (actual time=50.015..50.016 rows=32,045 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 3953kB
5. 4.205 40.358 ↑ 1.0 32,045 1

Subquery Scan on rs (cost=0.29..3,795.31 rows=32,045 width=75) (actual time=0.010..40.358 rows=32,045 loops=1)

6. 21.479 36.153 ↑ 1.0 32,045 1

WindowAgg (cost=0.29..3,474.86 rows=32,045 width=75) (actual time=0.010..36.153 rows=32,045 loops=1)

7. 14.674 14.674 ↑ 1.0 32,045 1

Index Scan using schedule_stop_idx1 on schedule_stop schds_1 (cost=0.29..2,914.07 rows=32,045 width=67) (actual time=0.006..14.674 rows=32,045 loops=1)

Planning time : 0.408 ms
Execution time : 99.335 ms