explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OA7B

Settings
# exclusive inclusive rows x rows loops node
1. 0.139 54.104 ↓ 5.0 5 1

GroupAggregate (cost=88,357.800..88,357.840 rows=1 width=61) (actual time=54.037..54.104 rows=5 loops=1)

  • Group Key: hotel.yankee, hotel.kilo_foxtrot_echo, hotel.delta, hotel.romeo, hotel.sierra, hotel.three
2. 0.000 53.965 ↓ 25.0 25 1

Sort (cost=88,357.800..88,357.810 rows=1 width=32) (actual time=53.962..53.965 rows=25 loops=1)

  • Sort Key: hotel.yankee, hotel.kilo_foxtrot_echo, hotel.delta, hotel.romeo, hotel.sierra, hotel.three
  • Sort Method: quicksort Memory: 26kB
3. 33.172 56.894 ↓ 25.0 25 1

Gather (cost=1,001.130..88,357.790 rows=1 width=32) (actual time=13.956..56.894 rows=25 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
4. 1.957 23.722 ↓ 13.0 13 2

Nested Loop (cost=1.130..87,357.690 rows=1 width=32) (actual time=6.228..23.722 rows=13 loops=2)

5. 0.098 21.718 ↑ 30.1 42 2

Nested Loop (cost=0.560..78,290.380 rows=1,263 width=49) (actual time=6.171..21.718 rows=42 loops=2)

6. 21.566 21.566 ↑ 258.7 3 2

Parallel Seq Scan on charlie hotel (cost=0.000..3,769.950 rows=776 width=29) (actual time=6.096..21.566 rows=3 loops=2)

  • Filter: (kilo_foxtrot_echo >= 'mike_six'::date)
  • Rows Removed by Filter: 100498
7. 0.054 0.054 ↓ 17.0 17 5

Index Scan using papa on oscar six (cost=0.560..96.020 rows=1 width=25) (actual time=0.043..0.054 rows=17 loops=5)

  • Index Cond: ((echo_four = hotel.yankee) AND (xray = hotel.kilo_foxtrot_echo) AND (echo_hotel = hotel.romeo) AND (tango > 'november'::numeric))
  • Filter: (hotel.sierra = india)
  • Rows Removed by Filter: 9
8. 0.047 0.047 ↓ 0.0 0 83

Index Scan using zulu on juliet_seven whiskey (cost=0.570..7.170 rows=1 width=23) (actual time=0.047..0.047 rows=0 loops=83)

  • Index Cond: ((echo_four = kilo_foxtrot_victor0.echo_four) AND (xray = kilo_foxtrot_victor0.xray) AND (echo_hotel = kilo_foxtrot_victor0.echo_hotel) AND (tango = kilo_foxtrot_victor0.tango) AND (mike_lima > 'november'::numeric))
  • Filter: (juliet_two <> 'november'::numeric)
  • Rows Removed by Filter: 27
Planning time : 2.067 ms
Execution time : 57.268 ms