explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GbbH

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.461 ↓ 5.5 11 1

Limit (cost=27.61..27.62 rows=2 width=64) (actual time=0.458..0.461 rows=11 loops=1)

2. 0.018 0.458 ↓ 5.5 11 1

Sort (cost=27.61..27.62 rows=2 width=64) (actual time=0.456..0.458 rows=11 loops=1)

  • Sort Key: ("sum"("w"."weight")) DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.011 0.440 ↓ 5.5 11 1

Nested Loop Left Join (cost=15.83..27.60 rows=2 width=64) (actual time=0.195..0.440 rows=11 loops=1)

4. 0.010 0.363 ↓ 5.5 11 1

Nested Loop Left Join (cost=15.14..25.95 rows=2 width=68) (actual time=0.182..0.363 rows=11 loops=1)

5. 0.006 0.239 ↓ 3.0 6 1

Nested Loop (cost=14.44..23.78 rows=2 width=52) (actual time=0.168..0.239 rows=6 loops=1)

6. 0.016 0.151 ↓ 2.0 2 1

GroupAggregate (cost=14.44..14.47 rows=1 width=48) (actual time=0.147..0.151 rows=2 loops=1)

  • Group Key: "m"."asset
7. 0.010 0.135 ↓ 2.0 2 1

Sort (cost=14.44..14.45 rows=1 width=28) (actual time=0.135..0.135 rows=2 loops=1)

  • Sort Key: "m"."asset
  • Sort Method: quicksort Memory: 25kB
8. 0.009 0.125 ↓ 2.0 2 1

Nested Loop (cost=11.15..14.43 rows=1 width=28) (actual time=0.116..0.125 rows=2 loops=1)

9. 0.010 0.104 ↓ 2.0 2 1

Bitmap Heap Scan on "asset_search_matches2" "m" (cost=11.00..12.26 rows=1 width=20) (actual time=0.101..0.104 rows=2 loops=1)

  • Recheck Cond: ("to_tsvector"('"english_nostop"'::"regconfig", "value") @@ '''red'' & ''oct'':*'::"tsquery")
  • Heap Blocks: exact=2
10. 0.094 0.094 ↓ 2.0 2 1

Bitmap Index Scan on "asset_search_matches2_to_tsvector_idx" (cost=0.00..11.00 rows=1 width=0) (actual time=0.093..0.094 rows=2 loops=1)

  • Index Cond: ("to_tsvector"('"english_nostop"'::"regconfig", "value") @@ '''red'' & ''oct'':*'::"tsquery")
11. 0.012 0.012 ↑ 1.0 1 2

Index Scan using "searchable_field_weights_pkey" on "searchable_field_weights" "w" (cost=0.15..2.17 rows=1 width=16) (actual time=0.006..0.006 rows=1 loops=2)

  • Index Cond: ("searchable_field" = "m"."searchable_field")
12. 0.006 0.082 ↑ 2.0 3 2

Append (cost=0.00..9.24 rows=6 width=36) (actual time=0.018..0.041 rows=3 loops=2)

13. 0.004 0.004 ↓ 0.0 0 2

Seq Scan on "entitlements" "e" (cost=0.00..0.00 rows=1 width=36) (actual time=0.002..0.002 rows=0 loops=2)

  • Filter: ("m"."asset" = "asset")
14. 0.020 0.020 ↓ 0.0 0 2

Index Scan using "tvod_asset_idx" on "tvod" "e_1" (cost=0.29..3.32 rows=2 width=36) (actual time=0.009..0.010 rows=0 loops=2)

  • Index Cond: ("asset" = "m"."asset")
15. 0.032 0.032 ↑ 1.0 2 2

Index Scan using "svod_asset_idx" on "svod" "e_2" (cost=0.42..3.45 rows=2 width=36) (actual time=0.010..0.016 rows=2 loops=2)

  • Index Cond: ("asset" = "m"."asset")
16. 0.020 0.020 ↓ 0.0 0 2

Index Scan using "linear_asset_idx1" on "linear" "e_3" (cost=0.42..2.44 rows=1 width=36) (actual time=0.010..0.010 rows=0 loops=2)

  • Index Cond: ("asset" = "m"."asset")
17. 0.008 0.114 ↓ 2.0 2 6

Nested Loop Semi Join (cost=0.70..1.07 rows=1 width=32) (actual time=0.015..0.019 rows=2 loops=6)

18. 0.066 0.066 ↑ 1.0 2 6

Index Only Scan using "svod_channels_pkey" on "svod_channels" "s" (cost=0.42..0.47 rows=2 width=32) (actual time=0.010..0.011 rows=2 loops=6)

  • Index Cond: ("svod" = "e"."id")
  • Heap Fetches: 10
19. 0.040 0.040 ↑ 5.0 1 10

Index Only Scan using "allowed_channels_id_idx" on "allowed_channels" "allowed_channels_1" (cost=0.28..0.36 rows=5 width=16) (actual time=0.004..0.004 rows=1 loops=10)

  • Index Cond: ("id" = "s"."channel")
  • Heap Fetches: 10
20. 0.000 0.066 ↓ 0.0 0 11

Nested Loop Semi Join (cost=0.70..0.81 rows=1 width=32) (actual time=0.006..0.006 rows=0 loops=11)

21. 0.066 0.066 ↓ 0.0 0 11

Index Scan using "linear_pkey" on "linear" "l" (cost=0.42..0.46 rows=1 width=32) (actual time=0.006..0.006 rows=0 loops=11)

  • Index Cond: ("id" = "e"."id")
22. 0.000 0.000 ↓ 0.0 0

Index Only Scan using "allowed_channels_id_idx" on "allowed_channels" (cost=0.28..0.36 rows=5 width=16) (never executed)

  • Index Cond: ("id" = "l"."channel")
  • Heap Fetches: 0