explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jVQft

Settings
# exclusive inclusive rows x rows loops node
1. 144.684 6,351.084 ↑ 1.0 150 1

Limit (cost=159,018.08..159,040.82 rows=150 width=164) (actual time=6,206.356..6,351.084 rows=150 loops=1)

2. 605.912 6,206.400 ↑ 1,568.3 150 1

WindowAgg (cost=159,018.08..194,681.54 rows=235,241 width=164) (actual time=6,206.355..6,206.400 rows=150 loops=1)

3. 4,234.155 5,600.488 ↓ 1.0 235,348 1

Group (cost=159,018.08..189,388.61 rows=235,241 width=749) (actual time=530.562..5,600.488 rows=235,348 loops=1)

  • Group Key: i.id, attr.data_norm, attr.r_ref, attr.frequency, attr.num_ports, attr.frequency_hz, attr.data
4. 0.000 1,366.333 ↓ 1.2 235,348 1

Gather Merge (cost=159,018.08..183,605.61 rows=196,034 width=685) (actual time=530.540..1,366.333 rows=235,348 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 1,307.640 2,804.598 ↑ 1.2 78,449 3

Group (cost=158,018.06..159,978.40 rows=98,017 width=685) (actual time=464.655..934.866 rows=78,449 loops=3)

  • Group Key: i.id, attr.data_norm, attr.r_ref, attr.frequency, attr.num_ports, attr.frequency_hz, attr.data
6. 366.372 1,496.958 ↑ 1.2 78,449 3

Sort (cost=158,018.06..158,263.10 rows=98,017 width=685) (actual time=464.653..498.986 rows=78,449 loops=3)

  • Sort Key: i.id DESC, attr.data_norm, attr.r_ref, attr.frequency, attr.num_ports, attr.frequency_hz, attr.data
  • Sort Method: external merge Disk: 83488kB
7. 355.542 1,130.586 ↑ 1.2 78,449 3

Hash Left Join (cost=49,086.31..90,252.08 rows=98,017 width=685) (actual time=235.463..376.862 rows=78,449 loops=3)

  • Hash Cond: (i.id = attr.bo_instance_id)
8. 70.914 70.914 ↑ 1.2 78,449 3

Parallel Seq Scan on bo_instance i (cost=0.00..18,672.06 rows=98,017 width=57) (actual time=0.019..23.638 rows=78,449 loops=3)

  • Filter: ((NOT is_deleted) AND (bo_class_id = 7))
  • Rows Removed by Filter: 4337
9. 407.946 704.130 ↑ 1.0 235,348 3

Hash (cost=27,051.25..27,051.25 rows=235,525 width=636) (actual time=234.710..234.710 rows=235,348 loops=3)

  • Buckets: 8192 Batches: 64 Memory Usage: 2514kB
10. 296.184 296.184 ↑ 1.0 235,348 3

Seq Scan on attrib_touchstone attr (cost=0.00..27,051.25 rows=235,525 width=636) (actual time=0.018..98.728 rows=235,348 loops=3)

Planning time : 0.759 ms
Execution time : 6,457.134 ms