explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2XEB

Settings
# exclusive inclusive rows x rows loops node
1. 0.192 15,352.710 ↑ 3.4 82 1

Sort (cost=1,486,280.80..1,486,281.49 rows=279 width=346) (actual time=15,352.689..15,352.710 rows=82 loops=1)

  • Sort Key: mc.measurement_colour_values_id
  • Sort Method: quicksort Memory: 58kB
2. 0.076 15,352.518 ↑ 3.4 82 1

Nested Loop (cost=0.00..1,486,269.46 rows=279 width=346) (actual time=2,836.639..15,352.518 rows=82 loops=1)

3. 0.040 0.040 ↑ 1.0 1 1

Index Scan using measurement_pkey on measurement ms (cost=0.00..8.29 rows=1 width=16) (actual time=0.036..0.040 rows=1 loops=1)

  • Index Cond: (measurement_id = 959476)
4. 15,352.402 15,352.402 ↑ 3.4 82 1

Seq Scan on measurementcolourvalues mc (cost=0.00..1,486,258.39 rows=279 width=338) (actual time=2,836.587..15,352.402 rows=82 loops=1)

  • Filter: (mc.measurement_id = 959476)