explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2vMr

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

Sort (cost=5,658,675.750..5,658,676.960 rows=484 width=134) (actual rows= loops=)

  • Sort Key: (five_hotel(CASE WHEN ((hotel_romeo.five_echo)::date = (CURRENT_DATE - 1)) THEN 1 ELSE 0 END)) DESC, hotel_romeo.kilo, hotel_romeo.zulu
2. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=5,658,477.510..5,658,654.170 rows=484 width=134) (actual rows= loops=)

  • Group Key: hotel_romeo.kilo, hotel_romeo.zulu, (juliet(juliet(hotel_romeo.seven, 'hotel_quebec'::text, 'three_four'::text), 'four'::text, 'delta'::text))
  • Filter: (five_two(*) > 1)
3. 0.000 0.000 ↓ 0.0

Sort (cost=5,658,477.510..5,658,489.610 rows=4,840 width=127) (actual rows= loops=)

  • Sort Key: hotel_romeo.kilo, hotel_romeo.zulu, (juliet(juliet(hotel_romeo.seven, 'hotel_quebec'::text, 'three_four'::text), 'four'::text, 'delta'::text))
4. 0.000 0.000 ↓ 0.0

Result (cost=0.000..5,658,181.280 rows=4,840 width=127) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Append (cost=0.000..5,658,108.680 rows=4,840 width=3,465) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Foreign Scan on hotel_romeo (cost=0.000..5,617,710.470 rows=3,425 width=4,841) (actual rows= loops=)

  • Filter: ((seven five_romeo NOT NULL) AND (golf <> 'three_charlie'::text) AND (golf = ANY ('oscar'::text[])) AND ((five_echo)::date >= (CURRENT_DATE - 7)))
  • CStore File: /var/lib/postgresql/10/main/cstore_fdw/16384/16803
  • CStore File Size: 9798388037
7. 0.000 0.000 ↓ 0.0

Subquery Scan on echo_uniform (cost=0.000..40,398.210 rows=1,415 width=136) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Foreign Scan on echo_bravo (cost=0.000..40,384.060 rows=1,415 width=616) (actual rows= loops=)

  • Filter: ((seven five_romeo NOT NULL) AND (five_echo >= 'victor'::text) AND (golf <> 'three_charlie'::text) AND (golf = ANY ('oscar'::text[])) AND ((five_echo)::date >= (CURRENT_DATE - 7)))
  • CStore File: /var/lib/postgresql/10/main/cstore_fdw/16384/152888
  • CStore File Size: 56643042