explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fXNU2

Settings
# exclusive inclusive rows x rows loops node
1. 54.947 414.897 ↓ 1.6 23,995 1

HashAggregate (cost=21,535.06..21,682.55 rows=14,749 width=16) (actual time=411.292..414.897 rows=23,995 loops=1)

  • Group Key: bfsi_staging_urlmodel.domain_id
2. 120.748 359.950 ↓ 1.0 196,474 1

Hash Left Join (cost=5,658.58..21,044.31 rows=196,301 width=16) (actual time=110.966..359.950 rows=196,474 loops=1)

  • Hash Cond: ((bfsi_staging_keywordserpdcmodel.url_id)::text = (bfsi_staging_urlmodel.url_id)::text)
3. 42.111 138.443 ↓ 1.0 196,474 1

Hash Join (cost=169.15..7,967.56 rows=196,301 width=91) (actual time=9.413..138.443 rows=196,474 loops=1)

  • Hash Cond: (bfsi_staging_keywordmodel.keyword = bfsi_staging_productkeywordmapping.keyword_id)
4. 57.917 92.758 ↓ 1.0 196,474 1

Hash Right Join (cost=80.59..7,362.81 rows=196,301 width=117) (actual time=5.722..92.758 rows=196,474 loops=1)

  • Hash Cond: (bfsi_staging_keywordserpdcmodel.keyword_id = bfsi_staging_keywordmodel.keyword)
5. 29.345 29.345 ↑ 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.059..29.345 rows=196,098 loops=1)

6. 3.144 5.496 ↑ 1.0 2,382 1

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

  • Buckets: 4,096 Batches: 1 Memory Usage: 168kB
7. 2.352 2.352 ↑ 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..2.352 rows=2,382 loops=1)

  • Filter: is_active
8. 1.857 3.574 ↑ 1.0 2,382 1

Hash (cost=58.78..58.78 rows=2,382 width=26) (actual time=3.573..3.574 rows=2,382 loops=1)

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

Seq Scan on bfsi_staging_productkeywordmapping (cost=0.00..58.78 rows=2,382 width=26) (actual time=0.044..1.717 rows=2,382 loops=1)

  • Filter: ((product_id)::text = 'test-work-bench'::text)
10. 62.316 100.759 ↑ 1.0 79,486 1

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

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

Planning time : 9.225 ms
Execution time : 417.798 ms