explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6ENO : pgbackrest - important part with inline

Settings
# exclusive inclusive rows x rows loops node
1. 0.114 2,921.811 ↑ 500,000.0 2 1

GroupAggregate (cost=2,733,045.08..2,995,545.08 rows=1,000,000 width=160) (actual time=2,921.787..2,921.811 rows=2 loops=1)

  • Group Key: per_stanza.config_file, per_stanza.stanza, ((per_stanza.backup_data ->> 'type'::text))
  • Functions: 17
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 3.923 ms, Inlining 168.768 ms, Optimization 403.135 ms, Emission 305.868 ms, Total 881.695 ms
2.          

CTE all_backups

3. 0.146 2,921.382 ↑ 50,000.0 2 1

ProjectSet (cost=0.25..517.75 rows=100,000 width=64) (actual time=2,921.367..2,921.382 rows=2 loops=1)

4. 2,921.236 2,921.236 ↑ 500.0 2 1

Function Scan on pgbackrest_info (cost=0.25..10.25 rows=1,000 width=64) (actual time=2,921.235..2,921.236 rows=2 loops=1)

5. 0.106 2,921.697 ↑ 714,285.7 14 1

Sort (cost=2,732,527.33..2,757,527.33 rows=10,000,000 width=128) (actual time=2,921.694..2,921.697 rows=14 loops=1)

  • Sort Key: per_stanza.config_file, per_stanza.stanza, ((per_stanza.backup_data ->> 'type'::text))
  • Sort Method: quicksort Memory: 39kB
6. 0.036 2,921.591 ↑ 714,285.7 14 1

Subquery Scan on per_stanza (cost=0.00..178,250.00 rows=10,000,000 width=128) (actual time=2,921.544..2,921.591 rows=14 loops=1)

7. 0.141 2,921.555 ↑ 714,285.7 14 1

ProjectSet (cost=0.00..53,250.00 rows=10,000,000 width=96) (actual time=2,921.515..2,921.555 rows=14 loops=1)

8. 2,921.414 2,921.414 ↑ 50,000.0 2 1

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

Planning time : 0.439 ms
Execution time : 2,938.288 ms