explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fSU : fff

Settings
# exclusive inclusive rows x rows loops node
1. 601.352 3,780.823 ↑ 28.6 7 1

GroupAggregate (cost=247,057.20..260,400.51 rows=200 width=72) (actual time=3,163.703..3,780.823 rows=7 loops=1)

  • Group Key: test_dates.column_1640_dow
2. 712.635 3,179.471 ↑ 1.0 1,067,095 1

Sort (cost=247,057.20..249,724.96 rows=1,067,105 width=21) (actual time=3,016.141..3,179.471 rows=1,067,095 loops=1)

  • Sort Key: test_dates.column_1640_dow
  • Sort Method: external merge Disk: 35520kB
3. 1,196.453 2,466.836 ↑ 1.0 1,067,095 1

Hash Right Join (cost=65,306.86..118,326.37 rows=1,067,105 width=21) (actual time=1,028.047..2,466.836 rows=1,067,095 loops=1)

  • Hash Cond: (test_dates.column_1640_id = test_all.column_1640_id)
4. 245.948 245.948 ↑ 1.0 1,067,095 1

Seq Scan on test_dates (cost=0.00..21,671.95 rows=1,067,095 width=16) (actual time=0.050..245.948 rows=1,067,095 loops=1)

5. 379.794 1,024.435 ↑ 1.0 1,067,095 1

Hash (cost=45,715.05..45,715.05 rows=1,067,105 width=21) (actual time=1,024.435..1,024.435 rows=1,067,095 loops=1)

  • Buckets: 65536 Batches: 32 Memory Usage: 2341kB
6. 644.641 644.641 ↑ 1.0 1,067,095 1

Seq Scan on test_all (cost=0.00..45,715.05 rows=1,067,105 width=21) (actual time=0.030..644.641 rows=1,067,095 loops=1)

Planning time : 0.239 ms