explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PFrs : pgbackrest - important part no inline

Settings
# exclusive inclusive rows x rows loops node
1. 0.032 3,046.716 ↑ 1,428,571.4 7 1

Subquery Scan on per_stanza (cost=517.75..178,767.75 rows=10,000,000 width=96) (actual time=3,046.700..3,046.716 rows=7 loops=1)

  • Functions: 12
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 25.572 ms, Inlining 0.000 ms, Optimization 63.351 ms, Emission 151.641 ms, Total 240.564 ms
2.          

CTE all_backups

3. 15.297 3,046.594 ↑ 100,000.0 1 1

ProjectSet (cost=0.25..517.75 rows=100,000 width=64) (actual time=3,046.588..3,046.594 rows=1 loops=1)

4. 3,031.297 3,031.297 ↑ 1,000.0 1 1

Function Scan on pgbackrest_info (cost=0.25..10.25 rows=1,000 width=64) (actual time=3,031.293..3,031.297 rows=1 loops=1)

5. 0.075 3,046.684 ↑ 1,428,571.4 7 1

ProjectSet (cost=0.00..53,250.00 rows=10,000,000 width=96) (actual time=3,046.678..3,046.684 rows=7 loops=1)

6. 3,046.609 3,046.609 ↑ 100,000.0 1 1

CTE Scan on all_backups (cost=0.00..2,000.00 rows=100,000 width=64) (actual time=3,046.606..3,046.609 rows=1 loops=1)

Planning time : 4.133 ms
Execution time : 3,073.027 ms