explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YdC4

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.008 2,525.783 ↑ 1.0 1 1

Nested Loop (cost=1,800,719.15..1,800,721.18 rows=1 width=1,241) (actual time=2,525.783..2,525.783 rows=1 loops=1)

2. 0.000 2,525.738 ↑ 1.0 1 1

HashAggregate (cost=1,800,718.59..1,800,718.60 rows=1 width=8) (actual time=2,525.738..2,525.738 rows=1 loops=1)

  • Group Key: parent.id
3. 587.792 3,108.727 ↓ 4.0 4 1

Gather (cost=1,002.73..1,800,718.58 rows=1 width=8) (actual time=2,525.680..3,108.727 rows=4 loops=1)

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

Hash Join (cost=2.73..1,799,718.48 rows=1 width=8) (actual time=2,363.362..2,520.935 rows=0 loops=8)

  • Hash Cond: (children.parent_id = parent.id)
5. 1,442.936 1,442.936 ↑ 1.1 10,771,995 8 / 8

Parallel Seq Scan on hive_posts children (cost=0.00..1,767,400.55 rows=12,310,555 width=4) (actual time=0.021..1,442.936 rows=10,771,995 loops=8)

6. 0.003 0.146 ↑ 1.0 1 8 / 8

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

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

Index Scan using hive_posts_ux1 on hive_posts parent (cost=0.69..2.71 rows=1 width=4) (actual time=0.142..0.143 rows=1 loops=8)

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

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

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