explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IfJi

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 22.418 ↑ 1.0 1 1

Limit (cost=1,000.000..14,818.240 rows=1 width=792) (actual time=20.945..22.418 rows=1 loops=1)

2. 3.677 22.414 ↑ 1.0 1 1

Gather (cost=1,000.000..14,818.240 rows=1 width=792) (actual time=20.943..22.414 rows=1 loops=1)

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

Parallel Seq Scan on yankee charlie (cost=0.000..13,818.140 rows=1 width=792) (actual time=18.197..18.737 rows=0 loops=3)

  • Filter: ((whiskey >= 'papa'::timestamp with time zone) AND (whiskey <= 'victor'::timestamp with time zone) AND (three = 'juliet'::uuid))
  • Rows Removed by Filter: 97,355
Planning time : 0.387 ms
Execution time : 22.470 ms