explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TKku

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 14.887 ↑ 1.0 200 1

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

2. 1.829 14.867 ↑ 1.0 200 1

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

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

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

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

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

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

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

6. 0.173 0.173 ↑ 1.0 697 1

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

7. 0.397 0.851 ↑ 1.0 697 1

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

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

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

Planning time : 0.734 ms
Execution time : 15.009 ms