explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DsYG

Settings
# exclusive inclusive rows x rows loops node
1. 2,109.877 84,263.419 ↑ 3.1 61,867 1

HashAggregate (cost=1,005,255.37..1,007,196.63 rows=194,126 width=53) (actual time=84,244.692..84,263.419 rows=61,867 loops=1)

  • Group Key: m.id
2. 2,778.668 82,153.542 ↑ 2.1 6,731,306 1

Merge Join (cost=0.98..934,534.90 rows=14,144,095 width=53) (actual time=107.901..82,153.542 rows=6,731,306 loops=1)

  • Merge Cond: ((m.gid)::ltree = (sa.gid_entity)::ltree)
3. 7,404.493 7,404.493 ↑ 1.0 194,126 1

Index Scan using movie_movie_gid_idx on movie m (cost=0.42..71,416.51 rows=194,126 width=53) (actual time=0.010..7,404.493 rows=194,126 loops=1)

4. 71,970.381 71,970.381 ↑ 2.1 6,845,264 1

Index Only Scan using social_action_ac_idx on social_action_ac sa (cost=0.56..685,831.89 rows=14,144,095 width=32) (actual time=0.087..71,970.381 rows=6,845,264 loops=1)

  • Heap Fetches: 6845264
Planning time : 1.067 ms
Execution time : 84,267.303 ms