explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jlzm

Settings
# exclusive inclusive rows x rows loops node
1. 0.214 4,688.352 ↑ 5.8 84 1

Sort (cost=5,658,675.750..5,658,676.960 rows=484 width=134) (actual time=4,688.348..4,688.352 rows=84 loops=1)

  • 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
  • Sort Method: quicksort Memory: 613kB
2. 1.386 4,688.138 ↑ 5.8 84 1

GroupAggregate (cost=5,658,477.510..5,658,654.170 rows=484 width=134) (actual time=4,685.871..4,688.138 rows=84 loops=1)

  • 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)
  • Rows Removed by Filter: 58
3. 52.059 4,686.752 ↑ 3.1 1,578 1

Sort (cost=5,658,477.510..5,658,489.610 rows=4,840 width=127) (actual time=4,685.833..4,686.752 rows=1,578 loops=1)

  • Sort Key: hotel_romeo.kilo, hotel_romeo.zulu, (juliet(juliet(hotel_romeo.seven, 'hotel_quebec'::text, 'three_four'::text), 'four'::text, 'delta'::text))
  • Sort Method: external merge Disk: 2648kB
4. 28.376 4,634.693 ↑ 3.1 1,578 1

Result (cost=0.000..5,658,181.280 rows=4,840 width=127) (actual time=4,389.774..4,634.693 rows=1,578 loops=1)

5. 0.131 4,606.317 ↑ 3.1 1,578 1

Append (cost=0.000..5,658,108.680 rows=4,840 width=3,465) (actual time=4,389.538..4,606.317 rows=1,578 loops=1)

6. 4,421.058 4,421.058 ↑ 2.6 1,310 1

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

  • Filter: ((seven five_romeo NOT NULL) AND (golf <> 'three_charlie'::text) AND (golf = ANY ('oscar'::text[])) AND ((five_echo)::date >= (CURRENT_DATE - 7)))
  • Rows Removed by Filter: 19127478
  • CStore File: /var/lib/postgresql/10/main/cstore_fdw/16384/16803
  • CStore File Size: 9798388037
7. 0.032 185.128 ↑ 5.3 268 1

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

8. 185.096 185.096 ↑ 5.3 268 1

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

  • 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)))
  • Rows Removed by Filter: 1285737
  • CStore File: /var/lib/postgresql/10/main/cstore_fdw/16384/152888
  • CStore File Size: 56643042
Planning time : 2.416 ms
Execution time : 4,691.153 ms