explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TPdw

Settings
# exclusive inclusive rows x rows loops node
1. 48.795 340.126 ↓ 1.6 23,994 1

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

  • Group Key: bfsi_staging_urlmodel.domain_id
2. 111.456 291.331 ↓ 2.0 196,098 1

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

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

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

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

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

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

6. 1.257 2.566 ↓ 2.0 2,382 1

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

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

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

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

10. 0.083 0.083 ↓ 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.083..0.083 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.705 2.971 ↑ 1.0 2,382 1

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

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

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

  • Filter: is_active
15. 30.679 51.068 ↑ 1.0 79,486 1

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

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

  • Filter: (domain_id IS NOT NULL)
Planning time : 11.960 ms
Execution time : 343.432 ms