explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ybIH

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 268.565 ↓ 0.0 0 1

Limit (cost=102,871.480..102,871.480 rows=1 width=24) (actual time=268.565..268.565 rows=0 loops=1)

2. 0.042 268.563 ↓ 0.0 0 1

Sort (cost=102,871.480..102,871.480 rows=1 width=24) (actual time=268.563..268.563 rows=0 loops=1)

  • Sort Key: charlie.hotel DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.002 268.521 ↓ 0.0 0 1

Nested Loop (cost=1,000.580..102,871.470 rows=1 width=24) (actual time=268.521..268.521 rows=0 loops=1)

4. 0.000 268.519 ↓ 0.0 0 1

Nested Loop (cost=1,000.290..102,857.810 rows=1 width=32) (actual time=268.519..268.519 rows=0 loops=1)

5. 15.709 281.236 ↓ 0.0 0 1

Gather (cost=1,000.000..102,849.490 rows=1 width=40) (actual time=268.517..281.236 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
6. 265.527 265.527 ↓ 0.0 0 3

Parallel Seq Scan on three_papa charlie (cost=0.000..101,849.390 rows=1 width=40) (actual time=265.527..265.527 rows=0 loops=3)

  • Filter: ((tango >= 'golf_quebec'::timestamp without time zone) AND (tango <= 'mike_echo'::timestamp without time zone) AND (uniform = 'kilo'::bigint) AND (victor = 1) AND (two = 'mike_sierra'::bigint))
  • Rows Removed by Filter: 520000
7. 0.000 0.000 ↓ 0.0 0

Index Scan using three_four on golf_yankee uniform (cost=0.290..8.310 rows=1 width=8) (never executed)

  • Index Cond: (oscar = 'kilo'::bigint)
  • Filter: (victor = 1)
8. 0.000 0.000 ↓ 0.0 0

Index Scan using three_four on golf_yankee romeo_seven (cost=0.290..8.310 rows=1 width=8) (never executed)

  • Index Cond: (oscar = charlie.romeo_seven)
  • Filter: (((three_oscar)::text ~~ 'romeo_six'::text) AND (victor = 1))