explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dGcI

Settings
# exclusive inclusive rows x rows loops node
1. 13.310 945.942 ↑ 1.0 1 1

Aggregate (cost=171,375.04..171,375.05 rows=1 width=8) (actual time=945.942..945.942 rows=1 loops=1)

2. 142.631 932.632 ↑ 1.1 218,815 1

Hash Right Join (cost=41,071.53..170,799.65 rows=230,156 width=8) (actual time=124.839..932.632 rows=218,815 loops=1)

  • Hash Cond: (attr.bo_instance_id = i.id)
  • Filter: ((SubPlan 1) AND (SubPlan 2))
  • Rows Removed by Filter: 13782
3. 204.887 204.887 ↑ 4.2 232,597 1

Seq Scan on attrib_touchstone attr (cost=0.00..103,429.85 rows=974,185 width=72) (actual time=0.008..204.887 rows=232,597 loops=1)

4. 27.572 124.720 ↓ 1.0 232,597 1

Hash (cost=37,263.16..37,263.16 rows=232,109 width=8) (actual time=124.720..124.720 rows=232,597 loops=1)

  • Buckets: 131072 Batches: 4 Memory Usage: 3304kB
5. 97.148 97.148 ↓ 1.0 232,597 1

Seq Scan on bo_instance i (cost=0.00..37,263.16 rows=232,109 width=8) (actual time=0.149..97.148 rows=232,597 loops=1)

  • Filter: ((NOT is_deleted) AND (bo_class_id = 7))
  • Rows Removed by Filter: 13003
6.          

SubPlan (forHash Right Join)

7. 232.597 232.597 ↑ 100.0 1 232,597

Function Scan on unnest elem (cost=0.00..1.25 rows=100 width=0) (actual time=0.001..0.001 rows=1 loops=232,597)

  • Filter: ((elem)::text ~~* 'S%'::text)
  • Rows Removed by Filter: 0
8. 227.797 227.797 ↑ 100.0 1 227,797

Function Scan on unnest elem_1 (cost=0.00..1.25 rows=100 width=0) (actual time=0.001..0.001 rows=1 loops=227,797)

  • Filter: ((elem)::text ~~* 'R%'::text)
  • Rows Removed by Filter: 0
Planning time : 0.353 ms
Execution time : 945.982 ms