explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6tUW

Settings
# exclusive inclusive rows x rows loops node
1. 49.324 344.145 ↓ 1.6 23,994 1

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

  • Group Key: bfsi_staging_urlmodel.domain_id
2. 112.851 294.821 ↓ 2.0 196,098 1

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

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

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

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

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

  • Hash Cond: (bfsi_staging_keywordserpdcmodel.keyword_id = bfsi_staging_productkeywordmapping.keyword_id)
5. 26.654 26.654 ↑ 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.071..26.654 rows=196,098 loops=1)

6. 1.873 4.056 ↓ 2.0 2,382 1

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

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

Seq Scan on bfsi_staging_productkeywordmapping (cost=117.36..182.09 rows=1,191 width=26) (actual time=0.061..2.183 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.029 ↓ 0.0 0 1

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

10. 0.028 0.028 ↓ 0.0 0 1

Index Scan using bfsi_staging_urlmodel_domain_id_c93ef4d9 on bfsi_staging_urlmodel u3 (cost=0.42..20.49 rows=4 width=91) (actual time=0.028..0.028 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. 1.717 3.181 ↑ 1.0 2,382 1

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

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

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

  • Filter: is_active
15. 33.815 52.143 ↑ 1.0 79,486 1

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

  • Buckets: 32,768 Batches: 4 Memory Usage: 2,978kB
16. 18.328 18.328 ↑ 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.018..18.328 rows=79,486 loops=1)

  • Filter: (domain_id IS NOT NULL)
Planning time : 7.098 ms
Execution time : 345.311 ms