explain.depesz.com

PostgreSQL's explain analyze made readable

Result: B2v6

Settings
# exclusive inclusive rows x rows loops node
1. 66.751 3,295.279 ↑ 1.0 1 1

Limit (cost=936,728.42..936,728.42 rows=1 width=20) (actual time=3,228.530..3,295.279 rows=1 loops=1)

2. 0.078 3,228.528 ↑ 66.0 1 1

Sort (cost=936,728.42..936,728.58 rows=66 width=20) (actual time=3,228.528..3,228.528 rows=1 loops=1)

  • Sort Key: (avg(frontend_measurevalue.percentile)) DESC
  • Sort Method: top-N heapsort Memory: 25kB
3. 0.180 3,228.450 ↑ 1.7 38 1

GroupAggregate (cost=1,000.14..936,728.09 rows=66 width=20) (actual time=3,220.823..3,228.450 rows=38 loops=1)

  • Group Key: frontend_measurevalue.measure_id
4. 5.073 3,228.270 ↓ 1.0 265 1

Nested Loop (cost=1,000.14..936,725.95 rows=262 width=20) (actual time=1,322.674..3,228.270 rows=265 loops=1)

  • Join Filter: ((frontend_measurevalue.measure_id)::text = (frontend_measure.id)::text)
  • Rows Removed by Join Filter: 18062
5. 0.310 0.310 ↑ 1.0 41 1

Index Scan using frontend_measure_pkey on frontend_measure (cost=0.14..36.31 rows=41 width=12) (actual time=0.019..0.310 rows=41 loops=1)

  • Filter: (tags @> '{core}'::character varying(30)[])
  • Rows Removed by Filter: 26
6. 0.000 3,222.887 ↓ 1.0 447 41

Materialize (cost=1,000.00..936,427.49 rows=428 width=20) (actual time=1.383..78.607 rows=447 loops=41)

7. 80.881 3,287.018 ↓ 1.0 447 1

Gather (cost=1,000.00..936,425.35 rows=428 width=20) (actual time=56.687..3,287.018 rows=447 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
8. 3,206.137 3,206.137 ↑ 1.2 89 5

Parallel Seq Scan on frontend_measurevalue (cost=0.00..935,382.55 rows=107 width=20) (actual time=113.129..3,206.137 rows=89 loops=5)

  • Filter: ((percentile IS NOT NULL) AND (month >= '2018-04-01'::date) AND ((measure_id)::text <> 'lpzomnibus'::text) AND ((practice_id)::text = 'F85052'::text))
  • Rows Removed by Filter: 6726071