explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2m3A

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.018 15.661 ↑ 1.0 200 1

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

2. 0.283 15.643 ↑ 245.5 200 1

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

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

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

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

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

5. 0.271 2.349 ↑ 1.0 697 1

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

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

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

7. 0.513 1.888 ↑ 1.0 697 1

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

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

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

Planning time : 0.644 ms
Execution time : 15.820 ms