explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kLxu

Settings
# exclusive inclusive rows x rows loops node
1. 34.233 2,191.476 ↑ 6.0 9,763 1

Unique (cost=102,496.780..102,790.200 rows=58,685 width=32) (actual time=2,099.479..2,191.476 rows=9,763 loops=1)

  • Buffers: shared hit=4716 read=591, temp read=3825 written=4446
2. 620.486 2,157.243 ↓ 2.0 119,903 1

Sort (cost=102,496.780..102,643.490 rows=58,685 width=32) (actual time=2,099.479..2,157.243 rows=119,903 loops=1)

  • Sort Key: (seven(juliet.quebec_three, juliet.five, juliet.quebec_sierra, uniform.hotel))
  • Sort Method: external merge Disk: 5528kB
  • Buffers: shared hit=4716 read=591, temp read=3825 written=4446
3. 62.724 1,536.757 ↓ 2.0 119,903 1

Gather (cost=88,871.660..97,848.720 rows=58,685 width=32) (actual time=1,452.129..1,536.757 rows=119,903 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
  • Buffers: shared hit=4716 read=591, temp read=3134 written=3752
4. 29.230 1,474.033 ↓ 1.7 59,952 2 / 2

Merge Join (cost=87,871.660..90,980.220 rows=34,521 width=32) (actual time=1,422.259..1,474.033 rows=59,952 loops=2)

  • Buffers: shared hit=4716 read=591, temp read=3134 written=3752
5. 466.266 497.160 ↑ 2.9 102,436 2 / 2

Sort (cost=37,388.470..38,123.760 rows=294,118 width=12) (actual time=478.946..497.160 rows=102,436 loops=2)

  • Sort Key: juliet.five, juliet.quebec_sierra, juliet.quebec_three
  • Sort Method: external merge Disk: 5944kB
  • Buffers: shared hit=2116 read=591, temp read=910 written=1358
6. 30.894 30.894 ↑ 1.2 250,000 2 / 2

Seq Scan on juliet juliet (cost=0.000..5,644.180 rows=294,118 width=12) (actual time=1.996..30.894 rows=250,000 loops=2)

  • Buffers: shared hit=2112 read=591
7. 15.514 947.643 ↓ 4.2 64,342 2 / 2

Sort (cost=50,483.170..50,521.770 rows=15,441 width=28) (actual time=943.294..947.643 rows=64,342 loops=2)

  • Sort Key: uniform.five, uniform.quebec_sierra, romeo.quebec_three
  • Sort Method: quicksort Memory: 3136kB
  • Buffers: shared hit=2600, temp read=2224 written=2394
8. 25.387 932.129 ↓ 2.0 30,307 2 / 2

Merge Join (cost=47,030.060..49,408.900 rows=15,441 width=28) (actual time=870.356..932.129 rows=30,307 loops=2)

  • Buffers: shared hit=2600, temp read=2224 written=2394
9. 457.984 537.215 ↓ 1.0 156,238 2 / 2

Sort (cost=22,918.720..23,308.660 rows=155,973 width=24) (actual time=513.689..537.215 rows=156,238 loops=2)

  • Sort Key: kilo.five, romeo.quebec_sierra, romeo.hotel
  • Sort Method: external merge Disk: 5208kB
  • Buffers: shared hit=436, temp read=1302 written=1308
10. 39.764 79.231 ↓ 1.0 156,238 2 / 2

Merge Join (cost=3,475.540..6,266.320 rows=155,973 width=24) (actual time=25.496..79.231 rows=156,238 loops=2)

  • Buffers: shared hit=436
11. 9.790 14.193 ↑ 2.5 7,942 2 / 2

Sort (cost=1,737.770..1,787.770 rows=20,000 width=12) (actual time=12.814..14.193 rows=7,942 loops=2)

  • Sort Key: romeo.quebec_three, romeo.hotel
  • Sort Method: quicksort Memory: 1706kB
  • Buffers: shared hit=218
12. 4.403 4.403 ↑ 1.0 20,000 2 / 2

Seq Scan on romeo romeo (cost=0.000..309.000 rows=20,000 width=12) (actual time=1.239..4.403 rows=20,000 loops=2)

  • Buffers: shared hit=218
13. 20.774 25.274 ↓ 7.8 156,262 2 / 2

Sort (cost=1,737.770..1,787.770 rows=20,000 width=12) (actual time=12.672..25.274 rows=156,262 loops=2)

  • Sort Key: kilo.quebec_three, kilo.hotel
  • Sort Method: quicksort Memory: 1706kB
  • Buffers: shared hit=218
14. 4.500 4.500 ↑ 1.0 20,000 2 / 2

Seq Scan on kilo kilo (cost=0.000..309.000 rows=20,000 width=12) (actual time=1.599..4.500 rows=20,000 loops=2)

  • Buffers: shared hit=218
15. 6.123 369.527 ↑ 3.0 66,381 2 / 2

Materialize (cost=24,111.140..25,111.140 rows=200,000 width=12) (actual time=356.633..369.527 rows=66,381 loops=2)

  • Buffers: shared hit=2164, temp read=922 written=1086
16. 346.330 363.404 ↑ 5.0 40,021 2 / 2

Sort (cost=24,111.140..24,611.140 rows=200,000 width=12) (actual time=356.628..363.404 rows=40,021 loops=2)

  • Sort Key: uniform.five, uniform.quebec_sierra, uniform.hotel
  • Sort Method: external merge Disk: 4320kB
  • Buffers: shared hit=2164, temp read=922 written=1086
17. 17.074 17.074 ↑ 1.0 200,000 2 / 2

Seq Scan on uniform uniform (cost=0.000..3,082.000 rows=200,000 width=12) (actual time=1.353..17.074 rows=200,000 loops=2)

  • Buffers: shared hit=2164