explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VSRg

Settings
# exclusive inclusive rows x rows loops node
1. 4,981.394 18,884.526 ↓ 7.9 6,968,214 1

Hash Join (cost=763,025.14..2,009,560.28 rows=879,963 width=80) (actual time=7,882.676..18,884.526 rows=6,968,214 loops=1)

  • Hash Cond: ((dschds.dispatch_schedule_id = dschds_1.dispatch_schedule_id) AND (((row_number() OVER (?) + 1)) = ((row_number() OVER (?) + 1))))
  • Functions: 20
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 2.237 ms, Inlining 3.445 ms, Optimization 102.563 ms, Emission 92.725 ms, Total 200.970 ms
2. 3,702.640 6,221.331 ↑ 1.0 6,968,214 1

WindowAgg (cost=0.43..534,379.36 rows=6,968,214 width=40) (actual time=199.373..6,221.331 rows=6,968,214 loops=1)

3. 2,518.691 2,518.691 ↑ 1.0 6,968,214 1

Index Scan using dispatch_schedule_stop_idx1 on dispatch_schedule_stop dschds (cost=0.43..395,015.08 rows=6,968,214 width=32) (actual time=199.345..2,518.691 rows=6,968,214 loops=1)

4. 1,940.705 7,681.801 ↑ 1.0 6,968,214 1

Hash (cost=604,061.50..604,061.50 rows=6,968,214 width=40) (actual time=7,681.801..7,681.801 rows=6,968,214 loops=1)

  • Buckets: 65536 Batches: 256 Memory Usage: 2431kB
5. 3,575.340 5,741.096 ↑ 1.0 6,968,214 1

WindowAgg (cost=0.43..534,379.36 rows=6,968,214 width=40) (actual time=0.058..5,741.096 rows=6,968,214 loops=1)

6. 2,165.756 2,165.756 ↑ 1.0 6,968,214 1

Index Scan using dispatch_schedule_stop_idx2 on dispatch_schedule_stop dschds_1 (cost=0.43..395,015.08 rows=6,968,214 width=32) (actual time=0.051..2,165.756 rows=6,968,214 loops=1)

Execution time : 19,168.106 ms