explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xoYY : no-rbac

Settings
# exclusive inclusive rows x rows loops node
1. 0.017 16,012.293 ↑ 1.2 27 1

Sort (cost=34,976.21..34,976.29 rows=33 width=36) (actual time=16,012.291..16,012.293 rows=27 loops=1)

  • Sort Key: i.bucket
  • Sort Method: quicksort Memory: 27kB
2. 754.726 16,012.276 ↑ 1.2 27 1

HashAggregate (cost=34,974.72..34,975.38 rows=33 width=36) (actual time=16,012.264..16,012.276 rows=27 loops=1)

  • Group Key: i.bucket
3. 8,430.434 15,257.550 ↓ 51.6 1,602,596 1

Nested Loop (cost=1,084.30..34,353.96 rows=31,038 width=53) (actual time=40.118..15,257.550 rows=1,602,596 loops=1)

  • Join Filter: ((t0.began >= i.begin) AND (t0.began <= i.""end""))
  • Rows Removed by Join Filter: 70,514,224
4. 0.000 2,019.328 ↓ 189.3 1,602,596 1

Gather (cost=1,084.30..29,461.34 rows=8,465 width=57) (actual time=40.053..2,019.328 rows=1,602,596 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
5. 105.638 6,700.017 ↓ 160.9 801,298 2 / 2

Nested Loop (cost=84.30..27,614.84 rows=4,979 width=57) (actual time=37.412..6,700.017 rows=801,298 loops=2)

6. 61.304 2,788.213 ↓ 156.5 200,324 2 / 2

Nested Loop (cost=83.74..15,764.10 rows=1,280 width=24) (actual time=37.326..2,788.213 rows=200,324 loops=2)

7. 38.902 1,925.577 ↓ 156.5 200,333 2 / 2

Nested Loop (cost=83.32..15,102.09 rows=1,280 width=24) (actual time=37.300..1,925.577 rows=200,333 loops=2)

8. 77.611 1,085.335 ↓ 158.4 200,335 2 / 2

Nested Loop (cost=82.89..14,461.57 rows=1,265 width=24) (actual time=37.256..1,085.335 rows=200,335 loops=2)

9. 185.987 204.590 ↓ 158.7 200,784 2 / 2

Parallel Bitmap Heap Scan on call t0 (cost=82.47..6,245.58 rows=1,265 width=24) (actual time=36.968..204.590 rows=200,784 loops=2)

  • Recheck Cond: ((began >= ('{""2019-07-31 14:00:00+00"",""2019-08-04 14:00:00+00"",""2019-08-11 14:00:00+00"",""2019-08-18 14:00:00+00"",""2019-08-25 14:00:00+00"",""2019-09-01 14:00:00+00"",""2019-09-08 14:00:00+00"",""2019-09-15 14:00:00+00"",""2019-09-22 14:00:00+00"",""2019-09-29 14:00:00+00"",""2019-10-06 13:00:00+00"",""2019-10-13 13:00:00+00"",""2019-10-20 13:00:00+00"",""2019-10-27 13:00:00+00"",""2019-11-03 13:00:00+00"",""2019-11-10 13:00:00+00"",""2019-11-17 13:00:00+00"",""2019-11-24 13:00:00+00"",""2019-12-01 13:00:00+00"",""2019-12-08 13:00:00+00"",""2019-12-15 13:00:00+00"",""2019-12-22 13:00:00+00"",""2019-12-29 13:00:00+00"",""2020-01-05 13:00:00+00"",""2020-01-12 13:00:00+00"",""2020-01-19 13:00:00+00"",""2020-01-26 13:00:00+00"",""2020-02-02 13:00:00+00"",""2020-02-09 13:00:00+00"",""2020-02-16 13:00:00+00"",""2020-02-23 13:00:00+00"",""2020-03-01 13:00:00+00"",""2020-03-08 13:00:00+00"",""2020-03-15 13:00:00+00"",""2020-03-22 13:00:00+00"",""2020-03-29 13:00:00+00"",""2020-04-05 14:00:00+00"",""2020-04-12 14:00:00+00"",""2020-04-19 14:00:00+00"",""2020-04-26 14:00:00+00"",""2020-05-03 14:00:00+00"",""2020-05-10 14:00:00+00"",""2020-05-17 14:00:00+00"",""2020-05-24 14:00:00+00"",""2020-05-31 14:00:00+00"",""2020-06-11 14:00:00+00""}'::timestamp with time zone[])[1]) AND (began <= ('{""2019-07-31 14:00:00+00"",""2019-08-04 14:00:00+00"",""2019-08-11 14:00:00+00"",""2019-08-18 14:00:00+00"",""2019-08-25 14:00:00+00"",""2019-09-01 14:00:00+00"",""2019-09-08 14:00:00+00"",""2019-09-15 14:00:00+00"",""2019-09-22 14:00:00+00"",""2019-09-29 14:00:00+00"",""2019-10-06 13:00:00+00"",""2019-10-13 13:00:00+00"",""2019-10-20 13:00:00+00"",""2019-10-27 13:00:00+00"",""2019-11-03 13:00:00+00"",""2019-11-10 13:00:00+00"",""2019-11-17 13:00:00+00"",""2019-11-24 13:00:00+00"",""2019-12-01 13:00:00+00"",""2019-12-08 13:00:00+00"",""2019-12-15 13:00:00+00"",""2019-12-22 13:00:00+00"",""2019-12-29 13:00:00+00"",""2020-01-05 13:00:00+00"",""2020-01-12 13:00:00+00"",""2020-01-19 13:00:00+00"",""2020-01-26 13:00:00+00"",""2020-02-02 13:00:00+00"",""2020-02-09 13:00:00+00"",""2020-02-16 13:00:00+00"",""2020-02-23 13:00:00+00"",""2020-03-01 13:00:00+00"",""2020-03-08 13:00:00+00"",""2020-03-15 13:00:00+00"",""2020-03-22 13:00:00+00"",""2020-03-29 13:00:00+00"",""2020-04-05 14:00:00+00"",""2020-04-12 14:00:00+00"",""2020-04-19 14:00:00+00"",""2020-04-26 14:00:00+00"",""2020-05-03 14:00:00+00"",""2020-05-10 14:00:00+00"",""2020-05-17 14:00:00+00"",""2020-05-24 14:00:00+00"",""2020-05-31 14:00:00+00"",""2020-06-11 14:00:00+00""}'::timestamp with time zone[])[46]))
  • Heap Blocks: exact=690
10. 18.603 18.603 ↓ 186.7 401,567 1 / 2

Bitmap Index Scan on call_idx_began (cost=0.00..81.93 rows=2,151 width=0) (actual time=37.206..37.206 rows=401,567 loops=1)

  • Index Cond: ((began >= ('{""2019-07-31 14:00:00+00"",""2019-08-04 14:00:00+00"",""2019-08-11 14:00:00+00"",""2019-08-18 14:00:00+00"",""2019-08-25 14:00:00+00"",""2019-09-01 14:00:00+00"",""2019-09-08 14:00:00+00"",""2019-09-15 14:00:00+00"",""2019-09-22 14:00:00+00"",""2019-09-29 14:00:00+00"",""2019-10-06 13:00:00+00"",""2019-10-13 13:00:00+00"",""2019-10-20 13:00:00+00"",""2019-10-27 13:00:00+00"",""2019-11-03 13:00:00+00"",""2019-11-10 13:00:00+00"",""2019-11-17 13:00:00+00"",""2019-11-24 13:00:00+00"",""2019-12-01 13:00:00+00"",""2019-12-08 13:00:00+00"",""2019-12-15 13:00:00+00"",""2019-12-22 13:00:00+00"",""2019-12-29 13:00:00+00"",""2020-01-05 13:00:00+00"",""2020-01-12 13:00:00+00"",""2020-01-19 13:00:00+00"",""2020-01-26 13:00:00+00"",""2020-02-02 13:00:00+00"",""2020-02-09 13:00:00+00"",""2020-02-16 13:00:00+00"",""2020-02-23 13:00:00+00"",""2020-03-01 13:00:00+00"",""2020-03-08 13:00:00+00"",""2020-03-15 13:00:00+00"",""2020-03-22 13:00:00+00"",""2020-03-29 13:00:00+00"",""2020-04-05 14:00:00+00"",""2020-04-12 14:00:00+00"",""2020-04-19 14:00:00+00"",""2020-04-26 14:00:00+00"",""2020-05-03 14:00:00+00"",""2020-05-10 14:00:00+00"",""2020-05-17 14:00:00+00"",""2020-05-24 14:00:00+00"",""2020-05-31 14:00:00+00"",""2020-06-11 14:00:00+00""}'::timestamp with time zone[])[1]) AND (began <= ('{""2019-07-31 14:00:00+00"",""2019-08-04 14:00:00+00"",""2019-08-11 14:00:00+00"",""2019-08-18 14:00:00+00"",""2019-08-25 14:00:00+00"",""2019-09-01 14:00:00+00"",""2019-09-08 14:00:00+00"",""2019-09-15 14:00:00+00"",""2019-09-22 14:00:00+00"",""2019-09-29 14:00:00+00"",""2019-10-06 13:00:00+00"",""2019-10-13 13:00:00+00"",""2019-10-20 13:00:00+00"",""2019-10-27 13:00:00+00"",""2019-11-03 13:00:00+00"",""2019-11-10 13:00:00+00"",""2019-11-17 13:00:00+00"",""2019-11-24 13:00:00+00"",""2019-12-01 13:00:00+00"",""2019-12-08 13:00:00+00"",""2019-12-15 13:00:00+00"",""2019-12-22 13:00:00+00"",""2019-12-29 13:00:00+00"",""2020-01-05 13:00:00+00"",""2020-01-12 13:00:00+00"",""2020-01-19 13:00:00+00"",""2020-01-26 13:00:00+00"",""2020-02-02 13:00:00+00"",""2020-02-09 13:00:00+00"",""2020-02-16 13:00:00+00"",""2020-02-23 13:00:00+00"",""2020-03-01 13:00:00+00"",""2020-03-08 13:00:00+00"",""2020-03-15 13:00:00+00"",""2020-03-22 13:00:00+00"",""2020-03-29 13:00:00+00"",""2020-04-05 14:00:00+00"",""2020-04-12 14:00:00+00"",""2020-04-19 14:00:00+00"",""2020-04-26 14:00:00+00"",""2020-05-03 14:00:00+00"",""2020-05-10 14:00:00+00"",""2020-05-17 14:00:00+00"",""2020-05-24 14:00:00+00"",""2020-05-31 14:00:00+00"",""2020-06-11 14:00:00+00""}'::timestamp with time zone[])[46]))
11. 803.134 803.134 ↑ 1.0 1 401,567 / 2

Index Scan using transcript_unique_call_id on transcript t1 (cost=0.42..6.49 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=401,567)

  • Index Cond: (call_id = t0.id)
12. 801.340 801.340 ↑ 1.0 1 400,670 / 2

Index Scan using enriched_transcript_unique_transcript_id on enriched_transcript t2 (cost=0.42..0.51 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=400,670)

  • Index Cond: (transcript_id = t1.id)
13. 801.332 801.332 ↑ 1.0 1 400,666 / 2

Index Scan using scorecard_run_unique_enriched_transcript_id on scorecard_run t3 (cost=0.42..0.52 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=400,666)

  • Index Cond: (enriched_transcript_id = t2.id)
14. 3,806.166 3,806.166 ↑ 6.2 4 400,649 / 2

Index Scan using scorecard_result_idx_scorecard_run_id_parent on scorecard_result t4 (cost=0.56..9.01 rows=25 width=65) (actual time=0.012..0.019 rows=4 loops=400,649)

  • Index Cond: (scorecard_run_id = t3.id)
  • Filter: ((parent IS NULL) OR ((question)::text = 'Communication'::text) OR ((question)::text = 'Compliance'::text) OR ((question)::text = 'Conduct'::text))
  • Rows Removed by Filter: 27
15. 4,807.737 4,807.788 ↓ 1.4 45 1,602,596

Materialize (cost=0.00..4.17 rows=33 width=20) (actual time=0.000..0.003 rows=45 loops=1,602,596)

16. 0.005 0.051 ↓ 1.4 45 1

Subquery Scan on i (cost=0.00..4.00 rows=33 width=20) (actual time=0.024..0.051 rows=45 loops=1)

  • Filter: (i.bucket > 0)
  • Rows Removed by Filter: 1
17. 0.026 0.046 ↑ 2.2 46 1

WindowAgg (cost=0.00..2.75 rows=100 width=20) (actual time=0.021..0.046 rows=46 loops=1)

18. 0.020 0.020 ↑ 2.2 46 1

Function Scan on unnest times (cost=0.00..1.00 rows=100 width=16) (actual time=0.016..0.020 rows=46 loops=1)

  • Filter: (t IS NOT NULL)
Planning time : 3.038 ms
Execution time : 16,013.181 ms