explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1TPx

Settings
# exclusive inclusive rows x rows loops node
1. 1.016 41.791 ↑ 2.4 1,199 1

HashAggregate (cost=3,753.31..3,781.93 rows=2,862 width=15) (actual time=41.655..41.791 rows=1,199 loops=1)

  • Group Key: bfsi_staging_urlmodel.domain_id
2. 5.963 40.775 ↑ 1.0 4,671 1

Hash Join (cost=2,444.61..3,741.36 rows=4,780 width=15) (actual time=29.494..40.775 rows=4,671 loops=1)

  • Hash Cond: (bfsi_staging_keywordmodel.keyword = bfsi_staging_productkeywordmapping.keyword_id)
3. 5.371 5.371 ↑ 1.0 50,045 1

Seq Scan on bfsi_staging_keywordmodel (cost=0.00..1,063.60 rows=50,060 width=26) (actual time=0.005..5.371 rows=50,045 loops=1)

  • Filter: is_active
4. 1.051 29.441 ↓ 1.0 4,671 1

Hash (cost=2,386.36..2,386.36 rows=4,660 width=68) (actual time=29.441..29.441 rows=4,671 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 493kB
5. 1.498 28.390 ↓ 1.0 4,671 1

Hash Join (cost=2,027.46..2,386.36 rows=4,660 width=68) (actual time=23.960..28.390 rows=4,671 loops=1)

  • Hash Cond: ((bfsi_staging_keywordserpdcmodel.url_id)::text = (bfsi_staging_urlmodel.url_id)::text)
6. 2.089 24.264 ↓ 1.0 4,671 1

Hash Join (cost=1,726.51..2,073.17 rows=4,660 width=144) (actual time=21.292..24.264 rows=4,671 loops=1)

  • Hash Cond: (bfsi_staging_keywordserpdcmodel.keyword_id = bfsi_staging_productkeywordmapping.keyword_id)
7. 1.008 1.008 ↓ 1.0 9,327 1

Seq Scan on bfsi_staging_keywordserpdcmodel (cost=0.00..322.19 rows=9,319 width=118) (actual time=0.003..1.008 rows=9,327 loops=1)

8. 10.637 21.167 ↓ 1.9 49,086 1

Hash (cost=1,405.54..1,405.54 rows=25,678 width=26) (actual time=21.167..21.167 rows=49,086 loops=1)

  • Buckets: 65,536 (originally 32768) Batches: 1 (originally 1) Memory Usage: 3,328kB
9. 10.517 10.530 ↓ 1.9 49,086 1

Seq Scan on bfsi_staging_productkeywordmapping (cost=20.21..1,405.54 rows=25,678 width=26) (actual time=0.029..10.530 rows=49,086 loops=1)

  • Filter: ((NOT (hashed SubPlan 1)) AND ((product_id)::text = 'tag-rule-test'::text))
  • Rows Removed by Filter: 2,004
10.          

SubPlan (for Seq Scan)

11. 0.001 0.013 ↓ 0.0 0 1

Nested Loop (cost=4.71..20.21 rows=2 width=27) (actual time=0.012..0.013 rows=0 loops=1)

12. 0.012 0.012 ↓ 0.0 0 1

Index Scan using bfsi_staging_urlmodel_domain_id_c93ef4d9_like on bfsi_staging_urlmodel u3 (cost=0.28..8.30 rows=1 width=91) (actual time=0.012..0.012 rows=0 loops=1)

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

Bitmap Heap Scan on bfsi_staging_keywordserpdcmodel u2 (cost=4.43..11.89 rows=2 width=118) (never executed)

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

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

  • Index Cond: ((url_id)::text = (u3.url_id)::text)
15. 1.550 2.628 ↓ 1.0 5,849 1

Hash (cost=228.20..228.20 rows=5,820 width=106) (actual time=2.628..2.628 rows=5,849 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 857kB
16. 1.078 1.078 ↓ 1.0 5,849 1

Seq Scan on bfsi_staging_urlmodel (cost=0.00..228.20 rows=5,820 width=106) (actual time=0.003..1.078 rows=5,849 loops=1)

  • Filter: (domain_id IS NOT NULL)
Planning time : 2.473 ms
Execution time : 42.275 ms