explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UDBN

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 121,589.837 121,589.837 ↑ 132.0 77 1

CTE Scan on child_posts (cost=28,293,138.16..28,293,341.38 rows=10,161 width=8) (actual time=0.132..121,589.837 rows=77 loops=1)

2.          

CTE child_posts

3. 0.183 121,589.799 ↑ 132.0 77 1

Recursive Union (cost=0.69..28,293,138.16 rows=10,161 width=8) (actual time=0.130..121,589.799 rows=77 loops=1)

4. 0.129 0.129 ↑ 1.0 1 1

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

  • Index Cond: (((author)::text = 'blocktrades'::text) AND ((permlink)::text = 'should-long-term-hive-proposals-cost-more-to-create'::text))
5. 70,674.813 121,589.487 ↑ 127.0 8 9

Hash Join (cost=0.33..2,829,293.22 rows=1,016 width=8) (actual time=10,464.476..13,509.943 rows=8 loops=9)

  • Hash Cond: (children.parent_id = child_posts_1.id)
6. 50,914.629 50,914.629 ↓ 1.0 86,188,394 9

Seq Scan on hive_posts children (cost=0.00..2,506,153.90 rows=86,167,690 width=8) (actual time=0.003..5,657.181 rows=86,188,394 loops=9)

7. 0.027 0.045 ↑ 1.1 9 9

Hash (cost=0.20..0.20 rows=10 width=4) (actual time=0.005..0.005 rows=9 loops=9)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
8. 0.018 0.018 ↑ 1.1 9 9

WorkTable Scan on child_posts child_posts_1 (cost=0.00..0.20 rows=10 width=4) (actual time=0.001..0.002 rows=9 loops=9)

Planning time : 1.070 ms
Execution time : 121,590.030 ms