explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7wI0

Settings
# exclusive inclusive rows x rows loops node
1. 1.537 29,665.055 ↑ 10.2 4 1

Hash Left Join (cost=132,917.15..133,068.59 rows=41 width=108) (actual time=29,664.260..29,665.055 rows=4 loops=1)

  • Hash Cond: (((tiktok.json ->> 'id'::text))::bigint = te.id)
2. 0.166 0.166 ↑ 10.2 4 1

Index Scan using tiktok_author on tiktok (cost=0.42..148.97 rows=41 width=113) (actual time=0.082..0.166 rows=4 loops=1)

  • Index Cond: (((json -> 'author'::text) ->> 'uniqueId'::text) = 'lilweehag'::text)
3. 13.174 29,663.352 ↓ 173.7 34,747 1

Hash (cost=132,914.22..132,914.22 rows=200 width=11) (actual time=29,663.352..29,663.352 rows=34,747 loops=1)

  • Buckets: 65,536 (originally 1024) Batches: 1 (originally 1) Memory Usage: 2,141kB
4. 6.919 29,650.178 ↓ 173.7 34,747 1

Subquery Scan on te (cost=132,859.55..132,914.22 rows=200 width=11) (actual time=29,596.276..29,650.178 rows=34,747 loops=1)

5. 0.758 29,643.259 ↓ 173.7 34,747 1

Finalize GroupAggregate (cost=132,859.55..132,912.22 rows=200 width=11) (actual time=29,596.274..29,643.259 rows=34,747 loops=1)

  • Group Key: (((tiktok_1.json ->> 'id'::text))::bigint)
6. 138.779 29,642.501 ↓ 94.5 37,818 1

Gather Merge (cost=132,859.55..132,906.22 rows=400 width=11) (actual time=29,596.255..29,642.501 rows=37,818 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
7. 15.053 29,503.722 ↓ 63.0 12,606 3 / 3

Sort (cost=131,859.53..131,860.03 rows=200 width=11) (actual time=29,499.480..29,503.722 rows=12,606 loops=3)

  • Sort Key: (((tiktok_1.json ->> 'id'::text))::bigint)
  • Sort Method: quicksort Memory: 960kB
  • Worker 0: Sort Method: quicksort Memory: 971kB
  • Worker 1: Sort Method: quicksort Memory: 996kB
8. 1,914.681 29,488.669 ↓ 63.0 12,606 3 / 3

Partial HashAggregate (cost=131,849.89..131,851.89 rows=200 width=11) (actual time=29,481.007..29,488.669 rows=12,606 loops=3)

  • Group Key: ((tiktok_1.json ->> 'id'::text))::bigint
9. 27,421.698 27,573.988 ↑ 24.9 774,844 3 / 3

ProjectSet (cost=0.00..112,175.79 rows=19,288,300 width=40) (actual time=4.370..27,573.988 rows=774,844 loops=3)

10. 152.290 152.290 ↑ 1.2 154,307 3 / 3

Parallel Seq Scan on tiktok tiktok_1 (cost=0.00..12,358.83 rows=192,883 width=104) (actual time=1.069..152.290 rows=154,307 loops=3)