explain.depesz.com

PostgreSQL's explain analyze made readable

Result: If3g

Settings
# exclusive inclusive rows x rows loops node
1. 48.741 336.870 ↓ 1.6 23,994 1

HashAggregate (cost=18,006.35..18,153.84 rows=14,749 width=16) (actual time=333.753..336.870 rows=23,994 loops=1)

  • Group Key: bfsi_staging_urlmodel.domain_id
2. 110.597 288.129 ↓ 2.0 196,098 1

Hash Join (cost=5,767.01..17,760.98 rows=98,150 width=16) (actual time=55.110..288.129 rows=196,098 loops=1)

  • Hash Cond: ((bfsi_staging_keywordserpdcmodel.url_id)::text = (bfsi_staging_urlmodel.url_id)::text)
3. 39.451 126.489 ↓ 2.0 196,098 1

Hash Join (cost=277.57..7,817.89 rows=98,150 width=91) (actual time=3.688..126.489 rows=196,098 loops=1)

  • Hash Cond: (bfsi_staging_productkeywordmapping.keyword_id = bfsi_staging_keywordmodel.keyword)
4. 53.924 85.512 ↓ 2.0 196,098 1

Hash Join (cost=196.98..7,479.19 rows=98,150 width=143) (actual time=2.118..85.512 rows=196,098 loops=1)

  • Hash Cond: (bfsi_staging_keywordserpdcmodel.keyword_id = bfsi_staging_productkeywordmapping.keyword_id)
5. 29.514 29.514 ↑ 1.0 196,098 1

Seq Scan on bfsi_staging_keywordserpdcmodel (cost=0.00..6,766.01 rows=196,301 width=117) (actual time=0.017..29.514 rows=196,098 loops=1)

6. 1.025 2.074 ↓ 2.0 2,382 1

Hash (cost=182.09..182.09 rows=1,191 width=26) (actual time=2.074..2.074 rows=2,382 loops=1)

  • Buckets: 4,096 (originally 2048) Batches: 1 (originally 1) Memory Usage: 168kB
7. 0.987 1.049 ↓ 2.0 2,382 1

Seq Scan on bfsi_staging_productkeywordmapping (cost=117.36..182.09 rows=1,191 width=26) (actual time=0.094..1.049 rows=2,382 loops=1)

  • Filter: ((NOT (hashed SubPlan 1)) AND ((product_id)::text = 'test-work-bench'::text))
8.          

SubPlan (for Seq Scan)

9. 0.001 0.062 ↓ 0.0 0 1

Nested Loop (cost=5.00..117.34 rows=10 width=26) (actual time=0.062..0.062 rows=0 loops=1)

10. 0.061 0.061 ↓ 0.0 0 1

Index Scan using url_model_related_domains on bfsi_staging_urlmodel u3 (cost=0.42..20.49 rows=4 width=91) (actual time=0.061..0.061 rows=0 loops=1)

  • Index Cond: ((domain_id)::text = ''::text)
11. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on bfsi_staging_keywordserpdcmodel u2 (cost=4.58..24.16 rows=5 width=117) (never executed)

  • Recheck Cond: ((url_id)::text = (u3.url_id)::text)
12. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on bfsi_staging_keywordserpdcmodel_url_id_bbdf981e_like (cost=0.00..4.58 rows=5 width=0) (never executed)

  • Index Cond: ((url_id)::text = (u3.url_id)::text)
13. 0.846 1.526 ↑ 1.0 2,382 1

Hash (cost=50.82..50.82 rows=2,382 width=26) (actual time=1.526..1.526 rows=2,382 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 168kB
14. 0.680 0.680 ↑ 1.0 2,382 1

Seq Scan on bfsi_staging_keywordmodel (cost=0.00..50.82 rows=2,382 width=26) (actual time=0.016..0.680 rows=2,382 loops=1)

  • Filter: is_active
15. 30.567 51.043 ↑ 1.0 79,486 1

Hash (cost=3,175.86..3,175.86 rows=79,486 width=107) (actual time=51.043..51.043 rows=79,486 loops=1)

  • Buckets: 32,768 Batches: 4 Memory Usage: 2,978kB
16. 20.476 20.476 ↑ 1.0 79,486 1

Seq Scan on bfsi_staging_urlmodel (cost=0.00..3,175.86 rows=79,486 width=107) (actual time=0.021..20.476 rows=79,486 loops=1)

  • Filter: (domain_id IS NOT NULL)
Planning time : 9.771 ms
Execution time : 338.625 ms