explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wIy : Optimization for: plan #YdC4

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.007 2,555.054 ↑ 1.0 1 1

Nested Loop (cost=1,800,730.63..1,800,732.66 rows=1 width=1,244) (actual time=2,555.054..2,555.054 rows=1 loops=1)

2. 0.000 2,555.003 ↑ 1.0 1 1

HashAggregate (cost=1,800,730.07..1,800,730.08 rows=1 width=8) (actual time=2,555.003..2,555.003 rows=1 loops=1)

  • Group Key: parent.id
3. 581.831 3,131.848 ↓ 4.0 4 1

Gather (cost=1,002.73..1,800,730.06 rows=1 width=8) (actual time=2,554.936..3,131.848 rows=4 loops=1)

  • Workers Planned: 7
  • Workers Launched: 7
4. 1,106.714 2,550.017 ↓ 0.0 0 8 / 8

Hash Join (cost=2.73..1,799,729.96 rows=1 width=8) (actual time=2,391.215..2,550.017 rows=0 loops=8)

  • Hash Cond: (children.parent_id = parent.id)
5. 1,443.163 1,443.163 ↑ 1.1 10,772,050 8 / 8

Parallel Seq Scan on hive_posts children (cost=0.00..1,767,411.10 rows=12,310,910 width=4) (actual time=0.022..1,443.163 rows=10,772,050 loops=8)

6. 0.003 0.140 ↑ 1.0 1 8 / 8

Hash (cost=2.71..2.71 rows=1 width=4) (actual time=0.139..0.140 rows=1 loops=8)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.137 0.137 ↑ 1.0 1 8 / 8

Index Scan using hive_posts_author_permlink_btree on hive_posts parent (cost=0.69..2.71 rows=1 width=4) (actual time=0.136..0.137 rows=1 loops=8)

  • Index Cond: (((author)::text = 'jes2850'::text) AND ((permlink)::text = 'happy-kitty-sleepy-kitty-purr-purr-purr'::text))
8. 0.044 0.044 ↑ 1.0 1 1

Index Scan using hive_posts_cache_pkey on hive_posts_cache (cost=0.57..2.58 rows=1 width=1,244) (actual time=0.044..0.044 rows=1 loops=1)

  • Index Cond: (post_id = children.parent_id)
Planning time : 3.695 ms
Execution time : 3,132.003 ms