explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Jn0m

Settings
# exclusive inclusive rows x rows loops node
1. 0.251 0.440 ↓ 1.4 15 1

Sort (cost=14.37..14.40 rows=11 width=76) (actual time=0.437..0.440 rows=15 loops=1)

  • Sort Key: ct.created_date DESC
  • Sort Method: quicksort Memory: 26kB
  • Planning time: 9.099 ms
  • Execution time: 0.633 ms
2.          

CTE ct

3. 0.022 0.155 ↓ 1.4 15 1

Recursive Union (cost=0.00..13.96 rows=11 width=56) (actual time=0.024..0.155 rows=15 loops=1)

4. 0.031 0.031 ↓ 12.0 12 1

Seq Scan on comment (cost=0.00..1.01 rows=1 width=56) (actual time=0.020..0.031 rows=12 loops=1)

  • Filter: ((parent_id IS NULL) AND (deleted_date IS NULL) AND (website_page_id = 1))
  • Rows Removed by Filter: 3
5. 0.067 0.102 ↑ 1.0 1 3

Hash Join (cost=1.02..1.27 rows=1 width=56) (actual time=0.030..0.034 rows=1 loops=3)

  • Hash Cond: (ct_1.id = comment_1.parent_id)
6. 0.006 0.006 ↑ 2.0 5 3

WorkTable Scan on ct ct_1 (cost=0.00..0.20 rows=10 width=12) (actual time=0.001..0.002 rows=5 loops=3)

7. 0.013 0.029 ↓ 3.0 3 1

Hash (cost=1.01..1.01 rows=1 width=52) (actual time=0.029..0.029 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
8. 0.016 0.016 ↓ 15.0 15 1

Seq Scan on comment comment_1 (cost=0.00..1.01 rows=1 width=52) (actual time=0.009..0.016 rows=15 loops=1)

9. 0.189 0.189 ↓ 1.4 15 1

CTE Scan on ct (cost=0.00..0.22 rows=11 width=76) (actual time=0.028..0.189 rows=15 loops=1)