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. 0.000 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. 2,137.695 4,628.952 ↑ 14.8 11 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. 359.442 2,491.257 ↓ 1,225.1 199,691 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. 50.152 933.669 ↓ 1,225.1 199,691 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.033 238.461 ↑ 1.0 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. 124.086 237.876 ↑ 1.0 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. 113.526 113.526 ↑ 1.2 373,996 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.024 0.264 ↓ 1.1 8 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.240 0.240 ↓ 1.1 8 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.552 0.552 ↑ 1.0 1 8

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. 645.056 645.056 ↓ 546.6 74,884 8

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. 1,198.146 1,198.146 ↑ 1.0 1 599,073

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")
Planning time : 1.331 ms