explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JbEt

Settings
# exclusive inclusive rows x rows loops node
1. 3,565.664 11,595.562 ↑ 1.0 1 1

Aggregate (cost=4,354.43..4,354.44 rows=1 width=32) (actual time=11,595.562..11,595.562 rows=1 loops=1)

2. 3,502.848 8,029.898 ↓ 254.7 21,351,705 1

Nested Loop (cost=5.88..3,515.97 rows=83,846 width=16) (actual time=0.521..8,029.898 rows=21,351,705 loops=1)

  • Join Filter: (keyword.id = volume.keyword_id)
3. 106.160 256.310 ↓ 254.2 427,074 1

Nested Loop (cost=5.46..144.46 rows=1,680 width=20) (actual time=0.482..256.310 rows=427,074 loops=1)

  • Join Filter: (keyword.id = "position".keyword_id)
4. 3.253 52.572 ↓ 254.1 16,263 1

Nested Loop (cost=5.17..44.43 rows=64 width=8) (actual time=0.450..52.572 rows=16,263 loops=1)

5. 3.762 16.793 ↓ 254.1 16,263 1

Nested Loop (cost=4.88..24.19 rows=64 width=4) (actual time=0.406..16.793 rows=16,263 loops=1)

6. 1.669 4.183 ↓ 252.8 1,264 1

Nested Loop (cost=4.60..20.52 rows=5 width=8) (actual time=0.313..4.183 rows=1,264 loops=1)

7. 0.416 1.250 ↓ 252.8 1,264 1

Nested Loop (cost=4.32..19.02 rows=5 width=4) (actual time=0.283..1.250 rows=1,264 loops=1)

8. 0.039 0.039 ↓ 3.0 3 1

Seq Scan on search_intentions intention (cost=0.00..1.04 rows=1 width=4) (actual time=0.034..0.039 rows=3 loops=1)

  • Filter: (ecosystem_id = 2)
9. 0.579 0.795 ↓ 84.2 421 3

Bitmap Heap Scan on search_keywords_categories_closure keywords_category_closure (cost=4.32..17.93 rows=5 width=8) (actual time=0.088..0.265 rows=421 loops=3)

  • Recheck Cond: (id_ancestor = intention.search_keywords_category_id)
  • Heap Blocks: exact=55
10. 0.216 0.216 ↓ 84.2 421 3

Bitmap Index Scan on "IDX_c43d01ddd858a7cd8b332f9855" (cost=0.00..4.32 rows=5 width=0) (actual time=0.072..0.072 rows=421 loops=3)

  • Index Cond: (id_ancestor = intention.search_keywords_category_id)
11. 1.264 1.264 ↑ 1.0 1 1,264

Index Only Scan using "PK_411f4ac312c1d65ba34119b05fe" on search_keywords_categories keywords_category (cost=0.28..0.30 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1,264)

  • Index Cond: (id = keywords_category_closure.id_descendant)
  • Heap Fetches: 0
12. 8.848 8.848 ↑ 1.0 13 1,264

Index Scan using "IDX_eab7a49032c2452c84534cc7c4" on search_keywords_categories_have_search_keywords keywords_category_keyword (cost=0.29..0.60 rows=13 width=8) (actual time=0.002..0.007 rows=13 loops=1,264)

  • Index Cond: (search_keywords_categories_id = keywords_category_closure.id_descendant)
13. 32.526 32.526 ↑ 1.0 1 16,263

Index Only Scan using "PK_a3ae40ee06ff0d9aa311fbee3d3" on search_keywords keyword (cost=0.28..0.32 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=16,263)

  • Index Cond: (id = keywords_category_keyword.search_keywords_id)
  • Heap Fetches: 16263
14. 97.578 97.578 ↑ 1.0 26 16,263

Index Scan using "IDX_7449d594c91a50871878d02da3" on search_keyword_positions "position" (cost=0.29..1.23 rows=27 width=12) (actual time=0.002..0.006 rows=26 loops=16,263)

  • Index Cond: (keyword_id = keywords_category_keyword.search_keywords_id)
15. 4,270.740 4,270.740 ↑ 1.0 50 427,074

Index Scan using "IDX_3637e3613695b7a272d7429816" on search_volumes volume (cost=0.42..1.38 rows=50 width=12) (actual time=0.002..0.010 rows=50 loops=427,074)

  • Index Cond: (keyword_id = "position".keyword_id)