explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kApO

Settings
# exclusive inclusive rows x rows loops node
1. 26.501 332.327 ↑ 1.0 1 1

Aggregate (cost=18,190.11..18,190.12 rows=1 width=8) (actual time=332.327..332.327 rows=1 loops=1)

2. 109.969 305.826 ↓ 1.4 329,255 1

Hash Full Join (cost=13,779.26..17,591.68 rows=239,375 width=0) (actual time=152.707..305.826 rows=329,255 loops=1)

  • Hash Cond: (t2._source_key = t3._term_key)
3. 32.092 52.023 ↓ 1.2 89,881 1

Hash Full Join (cost=2,542.32..4,619.97 rows=76,483 width=4) (actual time=7.889..52.023 rows=89,881 loops=1)

  • Hash Cond: (t1._experiment_key = t2._experiment_key)
4. 12.084 12.084 ↑ 1.0 76,483 1

Seq Scan on gxd_htsample t1 (cost=0.00..1,876.83 rows=76,483 width=4) (actual time=0.017..12.084 rows=76,483 loops=1)

5. 3.585 7.847 ↑ 1.0 16,503 1

Hash (cost=2,336.03..2,336.03 rows=16,503 width=8) (actual time=7.847..7.847 rows=16,503 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 901kB
6. 4.262 4.262 ↑ 1.0 16,503 1

Seq Scan on gxd_htexperiment t2 (cost=0.00..2,336.03 rows=16,503 width=8) (actual time=0.011..4.262 rows=16,503 loops=1)

7. 86.321 143.834 ↑ 1.0 239,375 1

Hash (cost=7,308.75..7,308.75 rows=239,375 width=4) (actual time=143.834..143.834 rows=239,375 loops=1)

  • Buckets: 131072 Batches: 4 Memory Usage: 3121kB
8. 57.513 57.513 ↑ 1.0 239,375 1

Seq Scan on voc_term t3 (cost=0.00..7,308.75 rows=239,375 width=4) (actual time=0.058..57.513 rows=239,375 loops=1)

Planning time : 0.395 ms