explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 82i3

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 4,446.700 ↑ 1.0 30 1

Limit (cost=16,672.63..16,676.13 rows=30 width=19) (actual time=4,446.668..4,446.700 rows=30 loops=1)

2. 2,903.704 4,446.688 ↑ 10.9 30 1

Gather Merge (cost=16,672.63..16,710.66 rows=326 width=19) (actual time=4,446.659..4,446.688 rows=30 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 712.565 1,542.984 ↑ 14.8 11 3 / 3

Sort (cost=15,672.60..15,673.01 rows=163 width=19) (actual time=1,542.963..1,542.984 rows=11 loops=3)

  • Sort Key: "Content".title
  • Sort Method: quicksort Memory: 25kB
4. 119.814 830.419 ↓ 1,225.1 199,691 3 / 3

Nested Loop (cost=34.06..15,666.62 rows=163 width=19) (actual time=79.554..830.419 rows=199,691 loops=3)

5. 16.717 311.223 ↓ 1,225.1 199,691 3 / 3

Nested Loop (cost=33.63..15,593.97 rows=163 width=4) (actual time=79.543..311.223 rows=199,691 loops=3)

6. 0.011 79.487 ↑ 1.0 3 3 / 3

Nested Loop (cost=33.07..15,576.16 rows=3 width=4) (actual time=31.299..79.487 rows=3 loops=3)

7. 41.362 79.292 ↑ 1.0 3 3 / 3

Hash Join (cost=32.64..15,574.71 rows=3 width=4) (actual time=31.143..79.292 rows=3 loops=3)

  • Hash Cond: ("FeedRole"."feedId" = "UserFeed"."feedId")
8. 37.842 37.842 ↑ 1.2 373,996 3 / 3

Parallel Seq Scan on "FeedRole" (cost=0.00..9,639.95 rows=467,495 width=8) (actual time=0.023..37.842 rows=373,996 loops=3)

9. 0.008 0.088 ↓ 1.1 8 3 / 3

Hash (cost=32.55..32.55 rows=7 width=4) (actual time=0.088..0.088 rows=8 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
10. 0.080 0.080 ↓ 1.1 8 3 / 3

Index Only Scan using "UserFeed_pkey" on "UserFeed" (cost=0.43..32.55 rows=7 width=4) (actual time=0.050..0.080 rows=8 loops=3)

  • Index Cond: ("userId" = 600)
  • Heap Fetches: 8
11. 0.184 0.184 ↑ 1.0 1 8 / 3

Index Only Scan using "Permission_pkey" on "Permission" (cost=0.43..0.47 rows=1 width=8) (actual time=0.068..0.069 rows=1 loops=8)

  • Index Cond: ("roleId" = "FeedRole"."roleId")
  • Heap Fetches: 3
12. 215.019 215.019 ↓ 546.6 74,884 8 / 3

Index Scan using "TagContent_tagId_idx" on "TagContent" (cost=0.56..4.56 rows=137 width=8) (actual time=0.021..80.632 rows=74,884 loops=8)

  • Index Cond: ("tagId" = "Permission"."tagId")
13. 399.382 399.382 ↑ 1.0 1 599,073 / 3

Index Scan using "Content_pkey" on "Content" (cost=0.43..0.45 rows=1 width=19) (actual time=0.002..0.002 rows=1 loops=599,073)

  • Index Cond: ("contentId" = "TagContent"."contentId")