explain.depesz.com

PostgreSQL's explain analyze made readable

Result: n8k4

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

Limit (cost=6,133.19..6,137.82 rows=200 width=40) (actual time=15.629..15.966 rows=200 loops=1)

2. 0.266 15.947 ↑ 245.5 200 1

GroupAggregate (cost=6,133.19..7,269.69 rows=49,100 width=40) (actual time=15.627..15.947 rows=200 loops=1)

  • Group Key: (unnest(tab2."f_gvc_55a5_unigrams$textual"))
3. 11.488 15.681 ↑ 42.7 1,633 1

Sort (cost=6,133.19..6,307.44 rows=69,700 width=32) (actual time=15.584..15.681 rows=1,633 loops=1)

  • Sort Key: (unnest(tab2."f_gvc_55a5_unigrams$textual")) NULLS FIRST
  • Sort Method: quicksort Memory: 971kB
4. 1.936 4.193 ↑ 5.6 12,497 1

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

5. 0.284 2.257 ↑ 1.0 697 1

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

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

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

7. 0.490 1.821 ↑ 1.0 697 1

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

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

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

Planning time : 0.625 ms
Execution time : 16.160 ms