explain.depesz.com

PostgreSQL's explain analyze made readable

Result: L6dT

Settings
# exclusive inclusive rows x rows loops node
1. 3,872.313 29,498.170 ↓ 1.0 185,605 1

Gather (cost=124,175.22..224,942.15 rows=182,890 width=1,704) (actual time=14,803.977..29,498.170 rows=185,605 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 5,439.180 25,625.857 ↑ 1.2 61,868 3

Hash Left Join (cost=123,175.22..205,653.15 rows=76,204 width=1,704) (actual time=14,848.156..25,625.857 rows=61,868 loops=3)

  • Hash Cond: (i.id = attr.bo_instance_id)
3. 5,358.095 5,358.095 ↑ 1.2 61,868 3

Parallel Seq Scan on bo_instance i (cost=0.00..44,712.95 rows=76,204 width=688) (actual time=0.012..5,358.095 rows=61,868 loops=3)

  • Filter: ((NOT is_deleted) AND (bo_class_id = 103))
  • Rows Removed by Filter: 17288
4. 522.167 14,828.582 ↑ 1.0 186,143 3

Hash (cost=97,216.43..97,216.43 rows=186,143 width=1,016) (actual time=14,828.582..14,828.582 rows=186,143 loops=3)

  • Buckets: 4096 Batches: 64 Memory Usage: 3134kB
5. 14,306.415 14,306.415 ↑ 1.0 186,143 3

Seq Scan on attrib_touchstone attr (cost=0.00..97,216.43 rows=186,143 width=1,016) (actual time=6,232.326..14,306.415 rows=186,143 loops=3)

Planning time : 0.336 ms
Execution time : 29,624.192 ms