explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dfDP

Settings
# exclusive inclusive rows x rows loops node
1. 35,359.022 52,442.158 ↑ 12.8 1,985,129 1

GroupAggregate (cost=1,079,258,727.33..1,184,244,541.94 rows=25,480,000 width=180) (actual time=16,653.151..52,442.158 rows=1,985,129 loops=1)

  • Group Key: social_offset_fs.id_user, ((social_offset_fs.gid_entity)::text), (CASE WHEN (sr.gid IS NOT NULL) THEN sr.series_tags ELSE NULL::ltree[] END)
2. 7,893.483 17,083.136 ↑ 1,379.1 2,161,833 1

Sort (cost=1,079,258,727.33..1,086,712,214.09 rows=2,981,394,703 width=338) (actual time=16,652.643..17,083.136 rows=2,161,833 loops=1)

  • Sort Key: social_offset_fs.id_user, ((social_offset_fs.gid_entity)::text), (CASE WHEN (sr.gid IS NOT NULL) THEN sr.series_tags ELSE NULL::ltree[] END)
  • Sort Method: quicksort Memory: 720552kB
3. 833.986 9,189.653 ↑ 1,379.1 2,161,833 1

Merge Right Join (cost=302,299.97..60,974,129.87 rows=2,981,394,703 width=338) (actual time=6,075.358..9,189.653 rows=2,161,833 loops=1)

  • Merge Cond: ((mr.gid_movie)::ltree = (social_offset_fs.gid_entity)::ltree)
4. 2.850 2.850 ↑ 1.0 8,660 1

Index Scan using movie_releases_fs_gid_movie_idx on movie_releases_fs mr (cost=0.29..289.69 rows=8,660 width=64) (actual time=0.023..2.850 rows=8,660 loops=1)

5. 741.448 8,352.817 ↑ 31.8 2,161,833 1

Materialize (cost=302,299.68..1,518,060.52 rows=68,854,381 width=274) (actual time=6,075.329..8,352.817 rows=2,161,833 loops=1)

6. 1,159.001 7,611.369 ↑ 31.8 2,161,833 1

Merge Left Join (cost=302,299.68..1,345,924.56 rows=68,854,381 width=274) (actual time=6,075.326..7,611.369 rows=2,161,833 loops=1)

  • Merge Cond: ((social_offset_fs.gid_entity)::ltree = (sr.gid)::ltree)
7. 5,580.466 6,441.050 ↑ 1.0 2,161,833 1

Sort (cost=301,735.49..307,140.07 rows=2,161,833 width=178) (actual time=6,074.169..6,441.050 rows=2,161,833 loops=1)

  • Sort Key: social_offset_fs.gid_entity
  • Sort Method: quicksort Memory: 672541kB
8. 860.584 860.584 ↑ 1.0 2,161,833 1

Seq Scan on social_offset_fs (cost=0.00..74,269.33 rows=2,161,833 width=178) (actual time=0.013..860.584 rows=2,161,833 loops=1)

9. 10.799 11.318 ↓ 29.1 185,276 1

Sort (cost=564.19..580.12 rows=6,370 width=96) (actual time=1.152..11.318 rows=185,276 loops=1)

  • Sort Key: sr.gid
  • Sort Method: quicksort Memory: 1098kB
10. 0.519 0.519 ↑ 2.0 3,229 1

Seq Scan on series_releases_fs sr (cost=0.00..161.70 rows=6,370 width=96) (actual time=0.012..0.519 rows=3,229 loops=1)

Planning time : 1.041 ms
Execution time : 52,581.491 ms