explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ujtw

Settings
# exclusive inclusive rows x rows loops node
1. 2,836.379 5,689.414 ↓ 1.6 3,474,787 1

Hash Left Join (cost=391,434.44..721,743.22 rows=2,124,416 width=34) (actual time=1,681.848..5,689.414 rows=3,474,787 loops=1)

  • Hash Cond: (z1.gitter_id_100m = z2.gitter_id_100m)
  • JIT:
  • Functions: 11
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 0.841 ms, Inlining 3.293 ms, Optimization 33.520 ms, Emission 18.613 ms, Total 56.267 ms
2. 1,172.424 1,172.424 ↓ 1.6 3,474,787 1

Seq Scan on z1 (cost=0.00..324,732.16 rows=2,124,416 width=32) (actual time=0.011..1,172.424 rows=3,474,787 loops=1)

3. 0.000 1,680.611 ↓ 5.1 3,265,141 1

Hash (cost=383,389.24..383,389.24 rows=643,616 width=17) (actual time=1,680.611..1,680.611 rows=3,265,141 loops=1)

  • Buckets: 2097152 (originally 1048576) Batches: 2 (originally 1) Memory Usage: 94522kB
4. 2,978.243 2,978.243 ↓ 5.1 3,265,141 1

Unique (cost=0.56..376,953.08 rows=643,616 width=17) (actual time=0.031..2,978.243 rows=3,265,141 loops=1)

  • -> Index Only Scan using idx_z2 on z2 (cost=0.56..329790.93 rows=18864858 width=17) (actual ti>
  • Heap Fetches: 0
Planning time : 0.261 ms
Execution time : 5,796.784 ms