explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oKaM

Settings
# exclusive inclusive rows x rows loops node
1. 10.995 130.685 ↑ 13.0 6 1

Gather (cost=1,000.85..31,931.83 rows=78 width=3,489) (actual time=3.950..130.685 rows=6 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.012 119.690 ↑ 16.0 2 3 / 3

Nested Loop (cost=0.85..30,924.03 rows=32 width=3,489) (actual time=79.201..119.690 rows=2 loops=3)

3. 119.609 119.609 ↑ 20.0 1 3 / 3

Parallel Index Scan using customer_active_idx on customer c (cost=0.42..30,674.80 rows=20 width=963) (actual time=69.018..119.609 rows=1 loops=3)

  • Index Cond: (active = true)
  • Filter: ((name)::text ~~ '%test%'::text)
  • Rows Removed by Filter: 162,698
4. 0.069 0.069 ↑ 1.0 2 3 / 3

Index Scan using solution_customer_idx on solution s (cost=0.43..12.44 rows=2 width=2,526) (actual time=0.060..0.069 rows=2 loops=3)

  • Index Cond: (customer = c.id)
Planning time : 2.716 ms
Execution time : 130.863 ms