explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Dj52

Settings
# exclusive inclusive rows x rows loops node
1. 19.283 29,085.399 ↑ 92.9 7,527 1

HashAggregate (cost=692,752.56..699,748.62 rows=699,606 width=48) (actual time=29,080.682..29,085.399 rows=7,527 loops=1)

  • Output: (string_agg(DISTINCT (external_object_id)::text, ','::text)), external_id, platform_id
  • Group Key: string_agg(DISTINCT (object_link.external_object_id)::text, ','::text)
2. 11,478.149 29,066.116 ↑ 19.2 36,379 1

GroupAggregate (cost=600,085.54..691,003.54 rows=699,606 width=48) (actual time=16,913.518..29,066.116 rows=36,379 loops=1)

  • Output: string_agg(DISTINCT (external_object_id)::text, ','::text), external_id, platform_id
  • Group Key: object_link.external_id, object_link.platform_id
  • Filter: (count(DISTINCT object_link.external_object_id) > 1)
  • Rows Removed by Filter: 4560943
3. 16,977.029 17,587.967 ↑ 1.0 4,665,652 1

Sort (cost=600,085.54..611,824.53 rows=4,695,596 width=20) (actual time=16,913.464..17,587.967 rows=4,665,652 loops=1)

  • Output: external_id, platform_id, external_object_id
  • Sort Key: object_link.external_id, object_link.platform_id
  • Sort Method: quicksort Memory: 531752kB
4. 610.938 610.938 ↑ 1.0 4,665,652 1

Seq Scan on public.object_link (cost=0.00..79,745.96 rows=4,695,596 width=20) (actual time=0.039..610.938 rows=4,665,652 loops=1)

  • Output: external_id, platform_id, external_object_id
Planning time : 1.198 ms
Execution time : 29,129.272 ms