explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Jegk

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Finalize Aggregate (cost=176,672.890..176,672.900 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Gather (cost=176,672.670..176,672.880 rows=2 width=8) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Partial Aggregate (cost=175,672.670..175,672.680 rows=1 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=16.810..175,655.430 rows=6,898 width=8) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Parallel Bitmap Heap Scan on echo (cost=16.240..72,178.660 rows=6,898 width=41) (actual rows= loops=)

  • Recheck Cond: ((five >= 'two'::timestamp without time zone) AND (five <= 'xray'::timestamp without time zone))
6. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on lima (cost=0.000..12.100 rows=18,638 width=0) (actual rows= loops=)

  • Index Cond: ((five >= 'two'::timestamp without time zone) AND (five <= 'xray'::timestamp without time zone))
7. 0.000 0.000 ↓ 0.0

Index Scan using bravo on foxtrot_xray_oscar (cost=0.570..205.010 rows=27 width=33) (actual rows= loops=)

  • Index Cond: ((foxtrot_xray_alpha)::text = (echo.foxtrot_xray_alpha)::text)
  • Filter: ((five >= 'two'::timestamp without time zone) AND (five <= 'xray'::timestamp without time zone))