explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lyUt : Optimization for: plan #gOdt

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.019 7.091 ↑ 1.0 200 1

Limit (cost=3,610.54..3,611.04 rows=200 width=40) (actual time=7.060..7.091 rows=200 loops=1)

2. 1.332 7.072 ↑ 245.5 200 1

Sort (cost=3,610.54..3,733.29 rows=49,100 width=40) (actual time=7.059..7.072 rows=200 loops=1)

  • Sort Key: (unnest(tab2."f_gvc_55a5_unigrams$textual")) NULLS FIRST
  • Sort Method: top-N heapsort Memory: 44kB
3. 3.495 5.740 ↑ 23.3 2,111 1

HashAggregate (cost=874.72..1,488.47 rows=49,100 width=40) (actual time=5.197..5.740 rows=2,111 loops=1)

  • Group Key: unnest(tab2."f_gvc_55a5_unigrams$textual")
4. 1.351 2.245 ↑ 5.6 12,497 1

ProjectSet (cost=89.68..526.22 rows=69,700 width=32) (actual time=0.577..2.245 rows=12,497 loops=1)

5. 0.214 0.894 ↑ 1.0 697 1

Hash Join (cost=89.68..172.49 rows=697 width=186) (actual time=0.574..0.894 rows=697 loops=1)

  • Hash Cond: (tab0._id = tab2._id)
6. 0.114 0.114 ↑ 1.0 697 1

Seq Scan on stream_5dcb2249e64d1e0993d02fe2 tab0 (cost=0.00..80.97 rows=697 width=4) (actual time=0.004..0.114 rows=697 loops=1)

7. 0.146 0.566 ↑ 1.0 697 1

Hash (cost=80.97..80.97 rows=697 width=190) (actual time=0.566..0.566 rows=697 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 126kB
8. 0.420 0.420 ↑ 1.0 697 1

Seq Scan on stream_5dcb2249e64d1e0993d02fe2 tab2 (cost=0.00..80.97 rows=697 width=190) (actual time=0.003..0.420 rows=697 loops=1)