explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jQRg

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Unique (cost=62825.44..64134.52 rows=174545 width=29)\n -> Sort (cost=62825.44..63261.80 rows=174545 width=29)\n Sort Key: bfsi_staging_domainmodel.domain, (sum(bfsi_staging_keywordsearchvolumedcmodel.search_volume))\n -> Finalize GroupAggregate (cost=22369.57..43449.47 rows=174545 width=29)\n Group Key: bfsi_staging_domainmodel.domain, bfsi_staging_keywordsearchvolumedcmodel.id\n -> Gather Merge (cost=22369.57..40613.11 rows=145454 width=29)\n Workers Planned: 2\n -> Partial GroupAggregate (cost=21369.55..22824.09 rows=72727 width=29)\n Group Key: bfsi_staging_domainmodel.domain, bfsi_staging_keywordsearchvolumedcmodel.id\n -> Sort (cost=21369.55..21551.36 rows=72727 width=25)\n Sort Key: bfsi_staging_domainmodel.domain, bfsi_staging_keywordsearchvolumedcmodel.id\n -> Hash Join (cost=5409.00..15496.77 rows=72727 width=25)\n Hash Cond: ((bfsi_staging_urlmodel.domain_id)::text = (bfsi_staging_domainmodel.domain)::text)\n -> Parallel Hash Join (cost=4580.13..14476.96 rows=72727 width=24)\n Hash Cond: ((bfsi_staging_keywordserpdcmodel.url_id)::text = (bfsi_staging_urlmodel.url_id)::text)\n -> Hash Join (cost=370.12..7025.03 rows=72727 width=99)\n Hash Cond: (bfsi_staging_keywordserpdcmodel.keyword_id = bfsi_staging_keywordmodel.keyword)\n -> Parallel Seq Scan on bfsi_staging_keywordserpdcmodel (cost=0.00..5620.92 rows=81792 width=117)\n -> Hash (cost=343.64..343.64 rows=2118 width=60)\n -> Hash Join (cost=80.59..343.64 rows=2118 width=60)\n Hash Cond: (bfsi_staging_keywordsearchvolumedcmodel.keyword_id = bfsi_staging_keywordmodel.keyword)\n -> Seq Scan on bfsi_staging_keywordsearchvolumedcmodel (cost=0.00..257.48 rows=2118 width=34)\n Filter: ((search_volume IS NOT NULL) AND (reference_date = '2020-07-01'::date))\n -> Hash (cost=50.82..50.82 rows=2382 width=26)\n -> Seq Scan on bfsi_staging_keywordmodel (cost=0.00..50.82 rows=2382 width=26)\n Filter: is_active\n -> Parallel Hash (cost=2848.56..2848.56 rows=46756 width=107)\n -> Parallel Seq Scan on bfsi_staging_urlmodel (cost=0.00..2848.56 rows=46756 width=107)\n -> Hash (cost=528.94..528.94 rows=23994 width=17)\n -> Seq Scan on bfsi_staging_domainmodel (cost=0.00..528.94 rows=23,994 width=17) (actual rows= loops=)