explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7w2N

Settings
# exclusive inclusive rows x rows loops node
1. 0.446 23.689 ↓ 461.0 461 1

Unique (cost=37.35..37.36 rows=1 width=15) (actual time=23.064..23.689 rows=461 loops=1)

2. 4.509 23.243 ↓ 996.0 996 1

Sort (cost=37.35..37.36 rows=1 width=15) (actual time=23.060..23.243 rows=996 loops=1)

  • Sort Key: bfsi_staging_urlmodel.domain_id
  • Sort Method: quicksort Memory: 83kB
3. 1.152 18.734 ↓ 996.0 996 1

Nested Loop (cost=17.44..37.34 rows=1 width=15) (actual time=2.940..18.734 rows=996 loops=1)

4. 0.918 7.622 ↓ 996.0 996 1

Nested Loop (cost=17.17..36.90 rows=1 width=91) (actual time=1.799..7.622 rows=996 loops=1)

  • Join Filter: (bfsi_staging_productkeywordmapping.keyword_id = bfsi_staging_keywordserpdcmodel.keyword_id)
5. 0.076 1.024 ↓ 16.0 16 1

Nested Loop (cost=16.89..32.97 rows=1 width=64) (actual time=0.788..1.024 rows=16 loops=1)

6. 0.265 0.788 ↓ 16.0 16 1

Index Only Scan using unique_product_keyword_mapping on bfsi_staging_productkeywordmapping (cost=16.74..24.76 rows=1 width=32) (actual time=0.711..0.788 rows=16 loops=1)

  • Index Cond: (product_id = 'test-work-bench'::text)
  • Filter: (NOT (hashed SubPlan 1))
  • Heap Fetches: 16
7.          

SubPlan (for Index Only Scan)

8. 0.002 0.523 ↓ 0.0 0 1

Nested Loop (cost=0.55..16.60 rows=1 width=27) (actual time=0.523..0.523 rows=0 loops=1)

9. 0.521 0.521 ↓ 0.0 0 1

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

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

Index Scan using bfsi_staging_keywordserpdcmodel_url_id_bbdf981e_like on bfsi_staging_keywordserpdcmodel u2 (cost=0.28..8.29 rows=1 width=118) (never executed)

  • Index Cond: ((url_id)::text = (u3.url_id)::text)
11. 0.160 0.160 ↑ 1.0 1 16

Index Scan using bfsi_staging_keywordmodel_keyword_ffa5e6bd_like on bfsi_staging_keywordmodel (cost=0.15..8.17 rows=1 width=32) (actual time=0.010..0.010 rows=1 loops=16)

  • Index Cond: (keyword = bfsi_staging_productkeywordmapping.keyword_id)
  • Filter: is_active
12. 5.680 5.680 ↑ 1.8 62 16

Index Scan using bfsi_staging_keywordserpdcmodel_keyword_id_bd780aa2_like on bfsi_staging_keywordserpdcmodel (cost=0.28..2.55 rows=111 width=118) (actual time=0.214..0.355 rows=62 loops=16)

  • Index Cond: (keyword_id = bfsi_staging_keywordmodel.keyword)
13. 9.960 9.960 ↑ 1.0 1 996

Index Scan using bfsi_staging_urlmodel_url_id_990eece2_like on bfsi_staging_urlmodel (cost=0.28..0.44 rows=1 width=106) (actual time=0.010..0.010 rows=1 loops=996)

  • Index Cond: ((url_id)::text = (bfsi_staging_keywordserpdcmodel.url_id)::text)
  • Filter: (domain_id IS NOT NULL)
Planning time : 19.885 ms
Execution time : 24.254 ms