explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MN3

Settings
# exclusive inclusive rows x rows loops node
1. 14.220 97.608 ↓ 18.9 27,456 1

Hash Join (cost=4,276.27..11,851.11 rows=1,453 width=106) (actual time=50.224..97.608 rows=27,456 loops=1)

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

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

3. 14.410 14.410 ↑ 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.027..14.410 rows=32,045 loops=1)

4. 9.714 50.121 ↑ 1.0 32,045 1

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

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

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

  • Filter: (rs.elapse_time IS NOT NULL)
6. 21.263 35.821 ↑ 1.0 32,045 1

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

7. 14.558 14.558 ↑ 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.558 rows=32,045 loops=1)

Planning time : 0.301 ms
Execution time : 98.917 ms