explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gOdt

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.033 40.074 ↑ 1.0 200 1

Limit (cost=1,417.48..1,417.98 rows=200 width=40) (actual time=40.021..40.074 rows=200 loops=1)

2. 2.828 40.041 ↑ 1.0 200 1

Sort (cost=1,417.48..1,417.98 rows=200 width=40) (actual time=40.018..40.041 rows=200 loops=1)

  • Sort Key: (unnest(stream_5dcb2249e64d1e0993d02fe2."f_gvc_55a5_unigrams$textual")) NULLS FIRST
  • Sort Method: top-N heapsort Memory: 44kB
3. 15.513 37.213 ↓ 10.6 2,111 1

HashAggregate (cost=1,407.84..1,409.84 rows=200 width=40) (actual time=36.475..37.213 rows=2,111 loops=1)

  • Group Key: (unnest(stream_5dcb2249e64d1e0993d02fe2."f_gvc_55a5_unigrams$textual"))
4. 12.230 21.700 ↓ 17.9 12,497 1

Hash Join (cost=89.68..1,404.35 rows=697 width=32) (actual time=0.889..21.700 rows=12,497 loops=1)

  • Hash Cond: (stream_5dcb2249e64d1e0993d02fe2._id = tab0._id)
5. 8.131 8.618 ↑ 5.6 12,497 1

ProjectSet (cost=0.00..434.70 rows=69,700 width=36) (actual time=0.023..8.618 rows=12,497 loops=1)

6. 0.487 0.487 ↑ 1.0 697 1

Seq Scan on stream_5dcb2249e64d1e0993d02fe2 (cost=0.00..80.97 rows=697 width=190) (actual time=0.012..0.487 rows=697 loops=1)

7. 0.397 0.852 ↑ 1.0 697 1

Hash (cost=80.97..80.97 rows=697 width=4) (actual time=0.852..0.852 rows=697 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 33kB
8. 0.455 0.455 ↑ 1.0 697 1

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

Planning time : 0.521 ms
Execution time : 40.204 ms