explain.depesz.com

PostgreSQL's explain analyze made readable

Result: H9cH : Optimization for: plan #2m3A

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.057 30.065 ↑ 1.0 200 1

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

2. 4.634 30.008 ↑ 245.5 200 1

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

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

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

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

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

5. 0.905 4.182 ↑ 1.0 697 1

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

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

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

7. 0.539 2.788 ↑ 1.0 697 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 126kB
8. 2.249 2.249 ↑ 1.0 697 1

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

Planning time : 0.608 ms
Execution time : 30.478 ms