explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NYt7

Settings
# exclusive inclusive rows x rows loops node
1. 0.055 30.421 ↑ 1.0 200 1

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

2. 5.200 30.366 ↑ 245.5 200 1

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

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

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

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

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

5. 0.882 4.123 ↑ 1.0 697 1

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

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

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

7. 0.576 2.784 ↑ 1.0 697 1

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

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

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

Planning time : 0.613 ms
Execution time : 30.838 ms