explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VNEO

Settings
# exclusive inclusive rows x rows loops node
1. 0.047 61.596 ↓ 5.0 5 1

GroupAggregate (cost=88,357.800..88,357.840 rows=1 width=55) (actual time=61.569..61.596 rows=5 loops=1)

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

Sort (cost=88,357.800..88,357.810 rows=1 width=26) (actual time=61.548..61.549 rows=25 loops=1)

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

Gather (cost=1,001.130..88,357.790 rows=1 width=26) (actual time=10.990..64.662 rows=25 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
4. 2.056 15.003 ↓ 13.0 13 2

Nested Loop (cost=1.130..87,357.690 rows=1 width=26) (actual time=4.706..15.003 rows=13 loops=2)

5. 0.354 12.897 ↑ 30.1 42 2

Nested Loop (cost=0.560..78,290.380 rows=1,263 width=43) (actual time=4.686..12.897 rows=42 loops=2)

6. 12.308 12.308 ↑ 258.7 3 2

Parallel Seq Scan on charlie hotel (cost=0.000..3,769.950 rows=776 width=23) (actual time=4.155..12.308 rows=3 loops=2)

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

Index Scan using papa on oscar six (cost=0.560..96.020 rows=1 width=25) (actual time=0.223..0.235 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.050 0.050 ↓ 0.0 0 83

Index Scan using zulu on juliet_seven whiskey (cost=0.570..7.170 rows=1 width=23) (actual time=0.039..0.050 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 : 3.132 ms
Execution time : 64.963 ms