explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Obq7

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.013 2,807.019 ↑ 33.3 6 1

Sort (cost=368,597.670..368,598.170 rows=200 width=19) (actual time=2,807.018..2,807.019 rows=6 loops=1)

  • Sort Key: (five(DISTINCT (foxtrot2019kilo_oscar11kilo_oscar28.six_mike -> 'yankee'::text))) DESC
  • Sort Method: quicksort Memory: 25kB
2. 1,043.894 2,807.006 ↑ 33.3 6 1

GroupAggregate (cost=368,489.900..368,590.020 rows=200 width=19) (actual time=1,791.066..2,807.006 rows=6 loops=1)

  • Group Key: foxtrot2019kilo_oscar11kilo_oscar28.two_charlie
3. 700.045 1,763.112 ↓ 32.4 317,440 1

Sort (cost=368,489.900..368,514.430 rows=9,812 width=901) (actual time=1,616.084..1,763.112 rows=317,440 loops=1)

  • Sort Key: foxtrot2019kilo_oscar11kilo_oscar28.two_charlie
  • Sort Method: external merge Disk: 324728kB
4. 25.211 1,063.067 ↓ 32.4 317,440 1

Append (cost=0.300..367,839.350 rows=9,812 width=901) (actual time=0.023..1,063.067 rows=317,440 loops=1)

  • Subplans Removed: 57
5. 252.620 252.620 ↓ 32.7 67,169 1

Index Scan using xray on charlie (cost=0.430..79,157.340 rows=2,053 width=911) (actual time=0.022..252.620 rows=67,169 loops=1)

  • Index Cond: ("india_three" >= (zulu_golf() - 'delta'::interval))
  • Filter: (((six_mike ->> 'zulu_sierra'::text) = ANY ('six_six'::text[])) AND (two_charlie = ANY ('kilo_three'::text[])))
  • Rows Removed by Filter: 454162
6. 785.228 785.228 ↓ 32.5 250,271 1

Seq Scan on six_delta (cost=0.000..288,534.860 rows=7,701 width=899) (actual time=0.027..785.228 rows=250,271 loops=1)

  • Filter: (((six_mike ->> 'zulu_sierra'::text) = ANY ('six_six'::text[])) AND ("india_three" >= (zulu_golf() - 'delta'::interval)) AND (two_charlie = ANY ('kilo_three'::text[])))
  • Rows Removed by Filter: 1658278
7. 0.002 0.008 ↓ 0.0 0 1

Bitmap Heap Scan on two_tango (cost=4.800..9.090 rows=1 width=64) (actual time=0.008..0.008 rows=0 loops=1)

  • Recheck Cond: ((two_charlie = ANY ('kilo_three'::text[])) AND ("india_three" >= (zulu_golf() - 'delta'::interval)))
  • Filter: ((six_mike ->> 'zulu_sierra'::text) = ANY ('six_six'::text[]))
8. 0.000 0.006 ↓ 0.0 0 1

BitmapAnd (cost=4.800..4.800 rows=5 width=0) (actual time=0.006..0.006 rows=0 loops=1)

9. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on zulu_juliet (cost=0.000..2.080 rows=15 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (two_charlie = ANY ('kilo_three'::text[]))
10. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on india_two (cost=0.000..2.470 rows=163 width=0) (never executed)

  • Index Cond: ("india_three" >= (zulu_golf() - 'delta'::interval))
Planning time : 3.633 ms
Execution time : 3,823.520 ms