explain.depesz.com

PostgreSQL's explain analyze made readable

Result: evbx

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

Group (cost=130,777.800..132,009.210 rows=8,892 width=18) (actual rows= loops=)

  • Group Key: (papa('kilo'::text, ((CURRENT_DATE - 30))::timestamp with time zone)), romeo1.sierra_three
2. 0.000 0.000 ↓ 0.0

Gather Merge (cost=130,777.800..131,875.830 rows=8,892 width=18) (actual rows= loops=)

  • Workers Planned: 4
3. 0.000 0.000 ↓ 0.0

Group (cost=129,777.740..129,816.640 rows=2,223 width=18) (actual rows= loops=)

  • Group Key: (papa('kilo'::text, ((CURRENT_DATE - 30))::timestamp with time zone)), romeo1.sierra_three
4. 0.000 0.000 ↓ 0.0

Sort (cost=129,777.740..129,783.300 rows=2,223 width=18) (actual rows= loops=)

  • Sort Key: romeo1.sierra_three
5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.430..129,654.160 rows=2,223 width=18) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on seven_golf foxtrot (cost=0.000..102,734.090 rows=14,423 width=19) (actual rows= loops=)

  • Filter: (november = 'whiskey'::numeric)
7. 0.000 0.000 ↓ 0.0

Index Scan using quebec_delta on zulu four_uniform (cost=0.430..1.850 rows=1 width=18) (actual rows= loops=)

  • Index Cond: ((sierra_three)::text = (romeo2.sierra_three)::text)
  • Filter: (((sierra_hotel)::text ~~ 'seven_uniform'::text) AND ((sierra_hotel)::text <> 'alpha'::text) AND ((quebec_romeo)::text = ANY ('four_six'::text[])) AND (india < romeo2.victor))