explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iV9I

Settings
# exclusive inclusive rows x rows loops node
1. 84.327 194.210 ↓ 10,420.0 10,420 1

GroupAggregate (cost=80.71..80.78 rows=1 width=542) (actual time=108.724..194.210 rows=10,420 loops=1)

  • Group Key: lnor.ordinal, rcl.id, rclf."values
2. 7.921 109.883 ↓ 10,420.0 10,420 1

Sort (cost=80.71..80.71 rows=1 width=542) (actual time=108.692..109.883 rows=10,420 loops=1)

  • Sort Key: lnor.ordinal, rcl.id, rclf."values
  • Sort Method: quicksort Memory: 21380kB
3. 0.776 101.962 ↓ 10,420.0 10,420 1

Nested Loop Left Join (cost=1.96..80.70 rows=1 width=542) (actual time=0.110..101.962 rows=10,420 loops=1)

4. 4.702 49.086 ↓ 10,420.0 10,420 1

Nested Loop Left Join (cost=1.54..72.25 rows=1 width=579) (actual time=0.079..49.086 rows=10,420 loops=1)

5. 2.387 33.964 ↓ 10,420.0 10,420 1

Nested Loop (cost=1.13..63.80 rows=1 width=301) (actual time=0.068..33.964 rows=10,420 loops=1)

6. 6.464 21.157 ↓ 1,736.7 10,420 1

Nested Loop (cost=0.84..61.81 rows=6 width=301) (actual time=0.058..21.157 rows=10,420 loops=1)

7. 4.273 4.273 ↓ 5,210.0 10,420 1

Index Scan using idx_lane_ca on lane rcl (cost=0.42..44.43 rows=2 width=49) (actual time=0.042..4.273 rows=10,420 loops=1)

  • Index Cond: (agreement_id = 33552)
  • Filter: ((cost_id IS NULL) AND (table_id = 1) AND (41954 = ANY (versions)))
8. 10.420 10.420 ↑ 9.0 1 10,420

Index Scan using idx_lane_cost_lane_id on lane_cost rclc (cost=0.42..8.60 rows=9 width=260) (actual time=0.001..0.001 rows=1 loops=10,420)

  • Index Cond: (lane_id = rcl.id)
  • Filter: ("values" IS NOT NULL)
9. 10.420 10.420 ↑ 1.0 1 10,420

Index Scan using cost_pkey on cost c (cost=0.28..0.32 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=10,420)

  • Index Cond: (id = rclc.cost_id)
  • Filter: (41954 = ANY (versions))
10. 10.420 10.420 ↑ 1.0 1 10,420

Index Scan using idx_lane_field_lane_id on lane_field rclf (cost=0.42..8.44 rows=1 width=286) (actual time=0.001..0.001 rows=1 loops=10,420)

  • Index Cond: (lane_id = rcl.id)
11. 52.100 52.100 ↑ 1.0 1 10,420

Index Scan using lane_ordinal_lane_hash_version_id_index_tmp on lane_ordinal lnor (cost=0.42..8.44 rows=1 width=45) (actual time=0.005..0.005 rows=1 loops=10,420)

  • Index Cond: ((lane_hash = rcl.hash) AND (version_id = 41954))
Planning time : 2.555 ms
Execution time : 194.777 ms