explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eSwc

Settings
# exclusive inclusive rows x rows loops node
1. 3,816.336 21,355.797 ↓ 1.0 185,605 1

Gather (cost=103,677.27..186,592.42 rows=182,906 width=1,704) (actual time=7,971.599..21,355.797 rows=185,605 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 7,386.294 17,539.461 ↑ 1.2 61,868 3

Hash Left Join (cost=102,677.27..167,301.82 rows=76,211 width=1,704) (actual time=7,967.970..17,539.461 rows=61,868 loops=3)

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

Parallel Seq Scan on bo_instance i (cost=0.00..44,713.06 rows=76,211 width=688) (actual time=0.023..2,187.379 rows=61,868 loops=3)

  • Filter: ((NOT is_deleted) AND (bo_class_id = 103))
  • Rows Removed by Filter: 17288
4. 719.791 7,965.788 ↓ 3.8 186,143 3

Hash (cost=95,844.90..95,844.90 rows=48,990 width=1,016) (actual time=7,965.788..7,965.788 rows=186,143 loops=3)

  • Buckets: 4096 (originally 4096) Batches: 64 (originally 16) Memory Usage: 4065kB
5. 7,245.997 7,245.997 ↓ 3.8 186,143 3

Seq Scan on attrib_touchstone attr (cost=0.00..95,844.90 rows=48,990 width=1,016) (actual time=616.076..7,245.997 rows=186,143 loops=3)

Planning time : 12.949 ms
Execution time : 21,492.890 ms