explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1Pbb

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 16,982.193 ↑ 1.0 1 1

Finalize Aggregate (cost=149,822.48..149,822.49 rows=1 width=8) (actual time=16,982.193..16,982.193 rows=1 loops=1)

2. 31.609 16,982.186 ↓ 1.5 3 1

Gather (cost=149,822.26..149,822.47 rows=2 width=8) (actual time=16,980.949..16,982.186 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 30.256 16,950.577 ↑ 1.0 1 3

Partial Aggregate (cost=148,822.26..148,822.27 rows=1 width=8) (actual time=16,950.577..16,950.577 rows=1 loops=3)

4. 97.927 16,920.321 ↓ 1.0 28,995 3

Hash Join (cost=102,508.15..148,751.48 rows=28,314 width=8) (actual time=11,359.776..16,920.321 rows=28,995 loops=3)

  • Hash Cond: (i.id = attr.bo_instance_id)
5. 5,465.324 5,465.324 ↑ 1.2 62,533 3

Parallel Seq Scan on bo_instance i (cost=0.00..44,725.26 rows=77,048 width=8) (actual time=0.010..5,465.324 rows=62,533 loops=3)

  • Filter: ((NOT is_deleted) AND (bo_class_id = 103))
  • Rows Removed by Filter: 17291
6. 60.537 11,357.070 ↑ 1.0 87,272 3

Hash (cost=101,064.12..101,064.12 rows=88,002 width=8) (actual time=11,357.070..11,357.070 rows=87,272 loops=3)

  • Buckets: 131072 Batches: 2 Memory Usage: 2728kB
7. 11,296.533 11,296.533 ↑ 1.0 87,272 3

Seq Scan on attrib_touchstone attr (cost=0.00..101,064.12 rows=88,002 width=8) (actual time=6.405..11,296.533 rows=87,272 loops=3)

  • Filter: (frequency > 1.914740571)
  • Rows Removed by Filter: 100866