explain.depesz.com

PostgreSQL's explain analyze made readable

Result: W1kc

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 8.673 44.275 ↑ 1.0 1 1

Gather (cost=1,000.00..16,040.62 rows=1 width=108) (actual time=0.365..44.275 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.001 35.602 ↓ 0.0 0 3 / 3

Parallel Append (cost=0.00..15,040.52 rows=1 width=108) (actual time=22.012..35.602 rows=0 loops=3)

3. 35.601 35.601 ↓ 0.0 0 3 / 3

Parallel Seq Scan on kyc_details_201910 kycdetails0_ (cost=0.00..15,040.52 rows=1 width=108) (actual time=22.011..35.601 rows=0 loops=3)

  • Filter: ((kyc_activity_id = '2afc22e0-7591-4f4e-9d99-6f576a6fd796'::uuid) AND (idempotency_id = '8f409071-71f8-42ce-8fe4-72f38282f2c8'::uuid) AND ((source)::text = 'ADDRESS'::text))
  • Rows Removed by Filter: 192,972
Planning time : 0.192 ms
Execution time : 44.309 ms