explain.depesz.com

PostgreSQL's explain analyze made readable

Result: v4Fa

Settings
# exclusive inclusive rows x rows loops node
1. 15.617 1,748.833 ↑ 1.0 30 1

Limit (cost=85,807.23..85,808.73 rows=30 width=28) (actual time=1,733.146..1,748.833 rows=30 loops=1)

2. 0.065 1,733.216 ↑ 65.6 30 1

Finalize GroupAggregate (cost=85,807.23..85,885.99 rows=1,969 width=28) (actual time=1,733.144..1,733.216 rows=30 loops=1)

  • Group Key: imports.date
3. 0.000 1,733.151 ↑ 48.8 121 1

Sort (cost=85,807.23..85,822.00 rows=5,907 width=28) (actual time=1,733.132..1,733.151 rows=121 loops=1)

  • Sort Key: imports.date DESC
  • Sort Method: quicksort Memory: 719kB
4. 51.632 1,745.777 ↓ 1.1 6,743 1

Gather (cost=84,826.82..85,437.21 rows=5,907 width=28) (actual time=1,693.514..1,745.777 rows=6,743 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
5. 115.126 1,694.145 ↑ 1.2 1,686 4

Partial HashAggregate (cost=83,826.82..83,846.51 rows=1,969 width=28) (actual time=1,693.596..1,694.145 rows=1,686 loops=4)

  • Group Key: imports.date
6. 525.174 1,579.019 ↑ 1.3 393,265 4

Hash Left Join (cost=51,491.01..80,021.18 rows=507,419 width=20) (actual time=959.886..1,579.019 rows=393,265 loops=4)

  • Hash Cond: (import_timer.import_id = imports.id)
7. 96.264 96.264 ↑ 1.3 393,265 4

Parallel Seq Scan on import_timer (cost=0.00..15,097.19 rows=507,419 width=20) (actual time=0.021..96.264 rows=393,265 loops=4)

8. 561.360 957.581 ↓ 1.0 1,581,979 4

Hash (cost=25,648.56..25,648.56 rows=1,575,156 width=8) (actual time=957.581..957.581 rows=1,581,979 loops=4)

  • Buckets: 262144 Batches: 16 Memory Usage: 5911kB
9. 396.221 396.221 ↓ 1.0 1,581,979 4

Seq Scan on imports (cost=0.00..25,648.56 rows=1,575,156 width=8) (actual time=0.028..396.221 rows=1,581,979 loops=4)