explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eNbg

Settings
# exclusive inclusive rows x rows loops node
1. 0.025 54,175.743 ↑ 2.8 36 1

Limit (cost=1,000.62..311,337.44 rows=100 width=52) (actual time=43,541.438..54,175.743 rows=36 loops=1)

2. 0.000 54,175.718 ↑ 30.3 36 1

GroupAggregate (cost=1,000.62..3,386,775.27 rows=1,091 width=52) (actual time=43,541.436..54,175.718 rows=36 loops=1)

  • Group Key: jenkins_job_name
3. 14,577.114 54,520.959 ↓ 6.8 129,932 1

Gather Merge (cost=1,000.62..3,386,669.35 rows=19,002 width=48) (actual time=43,510.148..54,520.959 rows=129,932 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
4. 39,943.845 39,943.845 ↓ 6.8 32,483 4 / 5

Parallel Index Scan using jenkins_job_name on test_results_testresult (cost=0.56..3,383,405.97 rows=4,750 width=48) (actual time=43,490.781..49,929.806 rows=32,483 loops=4)

  • Filter: (ci_official_id AND (created_timestamp >= '2020-08-08 02:00:00+02'::timestamp with time zone) AND (created_timestamp <= '2020-08-15 10:37:37.794316+02'::timestamp with time zone) AND (upper((jenkins_job_name)::text) ~~ '%TAF%'::text))
  • Rows Removed by Filter: 4,877,348
Planning time : 0.815 ms
Execution time : 54,561.677 ms