explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CbRU

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 3,085.845 ↑ 200.0 1 1

GroupAggregate (cost=2,680,245.82..2,680,250.32 rows=200 width=48) (actual time=3,085.845..3,085.845 rows=1 loops=1)

  • Group Key: a.groupby
2. 0.014 3,085.825 ↑ 14.3 14 1

Sort (cost=2,680,245.82..2,680,246.32 rows=200 width=40) (actual time=3,085.823..3,085.825 rows=14 loops=1)

  • Sort Key: a.groupby
  • Sort Method: quicksort Memory: 25kB
3. 0.005 3,085.811 ↑ 14.3 14 1

Subquery Scan on a (cost=2,680,232.17..2,680,238.17 rows=200 width=40) (actual time=3,083.197..3,085.811 rows=14 loops=1)

4. 1.844 3,085.806 ↑ 14.3 14 1

GroupAggregate (cost=2,680,232.17..2,680,236.17 rows=200 width=44) (actual time=3,083.195..3,085.806 rows=14 loops=1)

  • Group Key: t.date, t.groupby
5. 4.075 3,083.962 ↓ 62.3 12,456 1

Sort (cost=2,680,232.17..2,680,232.67 rows=200 width=44) (actual time=3,083.190..3,083.962 rows=12,456 loops=1)

  • Sort Key: t.date, t.groupby
  • Sort Method: quicksort Memory: 968kB
6. 2.241 3,079.887 ↓ 62.3 12,456 1

Subquery Scan on t (cost=0.84..2,680,224.53 rows=200 width=44) (actual time=0.076..3,079.887 rows=12,456 loops=1)

7. 213.536 3,077.646 ↓ 62.3 12,456 1

Unique (cost=0.84..2,680,222.53 rows=200 width=44) (actual time=0.076..3,077.646 rows=12,456 loops=1)

8. 520.772 2,864.110 ↑ 20.6 4,190,170 1

Nested Loop (cost=0.84..2,464,003.46 rows=86,487,627 width=44) (actual time=0.075..2,864.110 rows=4,190,170 loops=1)

9. 97.730 97.730 ↓ 1.9 280,701 1

Index Scan using temp2_index2_indicators_l4l_oel on temp2 t2 (cost=0.42..14,513.54 rows=148,608 width=12) (actual time=0.043..97.730 rows=280,701 loops=1)

10. 2,245.608 2,245.608 ↑ 38.8 15 280,701

Index Scan using temp1_index2_indicator_oel_l4l on temp1 t1 (cost=0.42..10.66 rows=582 width=64) (actual time=0.006..0.008 rows=15 loops=280,701)

  • Index Cond: ((studentid)::text = (t2.studentid)::text)
Planning time : 0.176 ms