explain.depesz.com

PostgreSQL's explain analyze made readable

Result: R0zx

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.205 ↑ 1.2 34 1

Sort (cost=182.78..182.88 rows=40 width=49) (actual time=0.204..0.205 rows=34 loops=1)

  • Sort Key: m.mid
  • Sort Method: quicksort Memory: 27kB
2.          

CTE concat_words

3. 0.040 0.129 ↑ 1.5 33 1

HashAggregate (cost=65.81..66.43 rows=50 width=40) (actual time=0.124..0.129 rows=33 loops=1)

  • Group Key: words_scores.mid
4. 0.089 0.089 ↑ 1.1 46 1

Index Scan using words_scores_gid_idx on words_scores (cost=0.43..65.43 rows=50 width=19) (actual time=0.018..0.089 rows=46 loops=1)

  • Index Cond: (gid = 48856)
5.          

Initplan (forSort)

6. 0.009 0.009 ↑ 1.0 1 1

Index Scan using words_social_pkey on words_social (cost=0.29..8.30 rows=1 width=4) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: ((sid = '17880121030128875114'::text) AND (social = 8))
7. 0.025 0.194 ↑ 1.2 34 1

Hash Left Join (cost=2.05..106.98 rows=40 width=49) (actual time=0.163..0.194 rows=34 loops=1)

  • Hash Cond: (m.mid = cw.mid)
8. 0.027 0.027 ↑ 1.2 34 1

Index Scan using words_moves_gid_played_idx on words_moves m (cost=0.43..104.59 rows=40 width=22) (actual time=0.008..0.027 rows=34 loops=1)

  • Index Cond: (gid = 48856)
9. 0.006 0.142 ↑ 1.5 33 1

Hash (cost=1.00..1.00 rows=50 width=40) (actual time=0.142..0.142 rows=33 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
10. 0.136 0.136 ↑ 1.5 33 1

CTE Scan on concat_words cw (cost=0.00..1.00 rows=50 width=40) (actual time=0.126..0.136 rows=33 loops=1)