explain.depesz.com

PostgreSQL's explain analyze made readable

Result: j7Tz

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 29,544.828 ↓ 0.0 0 1

ProjectSet (cost=450,135.93..729,430.10 rows=44,826,700 width=80) (actual time=29,544.828..29,544.828 rows=0 loops=1)

2. 4,065.673 29,544.827 ↓ 0.0 0 1

GroupAggregate (cost=450,135.93..500,813.93 rows=448,267 width=104) (actual time=29,544.827..29,544.827 rows=0 loops=1)

  • Group Key: t0.model_year_id, f1.synonym
  • Filter: (count(f1.*) > 1)
  • Rows Removed by Filter: 3689483
3. 22,539.562 25,479.154 ↓ 2.0 3,689,483 1

Sort (cost=450,135.93..454,659.93 rows=1,809,600 width=111) (actual time=23,605.741..25,479.154 rows=3,689,483 loops=1)

  • Sort Key: t0.model_year_id DESC, f1.synonym
  • Sort Method: external merge Disk: 351304kB
4. 700.408 2,939.592 ↓ 2.0 3,689,483 1

Nested Loop (cost=0.00..51,751.99 rows=1,809,600 width=111) (actual time=0.048..2,939.592 rows=3,689,483 loops=1)

5. 307.916 307.916 ↓ 2.1 37,868 1

Seq Scan on trims t0 (cost=0.00..6,195.31 rows=18,096 width=701) (actual time=0.026..307.916 rows=37,868 loops=1)

  • Filter: (array_length(synonyms, 1) > 0)
  • Rows Removed by Filter: 10405
6. 1,136.040 1,931.268 ↑ 1.0 97 37,868

Subquery Scan on f1 (cost=0.00..1.52 rows=100 width=88) (actual time=0.008..0.051 rows=97 loops=37,868)

7. 795.228 795.228 ↑ 1.0 97 37,868

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.008..0.021 rows=97 loops=37,868)

8. 0.000 0.000 ↑ 1.0 1 37,868

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=37,868)

Planning time : 0.118 ms
Execution time : 29,612.075 ms