explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3QYj

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 18,966.287 ↑ 1.0 80 1

Limit (cost=632,397.34..632,406.92 rows=80 width=83) (actual time=18,877.421..18,966.287 rows=80 loops=1)

2. 0.000 18,966.269 ↑ 111,443.6 80 1

Gather Merge (cost=632,397.34..1,699,889.61 rows=8,915,484 width=83) (actual time=18,877.415..18,966.269 rows=80 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 79,842.815 88,028.735 ↑ 5,065.6 440 5

Sort (cost=627,397.28..632,969.46 rows=2,228,871 width=83) (actual time=17,605.422..17,605.747 rows=440 loops=5)

  • Sort Key: default_code, name_template
  • Sort Method: external merge Disk: 187568kB
4. 8,185.920 8,185.920 ↑ 1.2 1,783,134 5

Parallel Seq Scan on product_product (cost=0.00..329,916.79 rows=2,228,871 width=83) (actual time=0.795..1,637.184 rows=1,783,134 loops=5)

  • Filter: active
  • Rows Removed by Filter: 129
Planning time : 21.462 ms
Execution time : 19,028.039 ms