explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3iMU

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 0.087 ↓ 1.8 11 1

Hash Join (cost=17.67..34.80 rows=6 width=106) (actual time=0.072..0.087 rows=11 loops=1)

  • Hash Cond: (((row_number() OVER (?) + 1)) = rs.idx)
2. 0.017 0.044 ↓ 2.0 12 1

WindowAgg (cost=0.29..17.27 rows=6 width=127) (actual time=0.033..0.044 rows=12 loops=1)

3. 0.027 0.027 ↓ 2.0 12 1

Index Scan using schedule_stop_idx1 on schedule_stop schds (cost=0.29..17.15 rows=6 width=51) (actual time=0.022..0.027 rows=12 loops=1)

  • Index Cond: (schedule_id = 30167)
4. 0.006 0.031 ↓ 2.0 12 1

Hash (cost=17.31..17.31 rows=6 width=75) (actual time=0.031..0.031 rows=12 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
5. 0.004 0.025 ↓ 2.0 12 1

Subquery Scan on rs (cost=0.29..17.31 rows=6 width=75) (actual time=0.009..0.025 rows=12 loops=1)

  • Filter: (rs.schedule_stop_id IS NOT NULL)
6. 0.011 0.021 ↓ 2.0 12 1

WindowAgg (cost=0.29..17.25 rows=6 width=75) (actual time=0.008..0.021 rows=12 loops=1)

7. 0.010 0.010 ↓ 2.0 12 1

Index Scan using schedule_stop_idx1 on schedule_stop schds_1 (cost=0.29..17.15 rows=6 width=67) (actual time=0.004..0.010 rows=12 loops=1)

  • Index Cond: (schedule_id = 30167)
Planning time : 0.365 ms
Execution time : 0.141 ms