explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hsht : CT7

Settings
# exclusive inclusive rows x rows loops node
1. 11.126 28,280.176 ↓ 754.0 754 1

GroupAggregate (cost=272.220..272.340 rows=1 width=299) (actual time=28,268.781..28,280.176 rows=754 loops=1)

  • Group Key: ((foxtrot.charlie_six ->> 'four'::text)), (charlie_lima((foxtrot.charlie_six ->> 'zulu_echo'::text), 4)), ((yankee.charlie_six #>> 'mike_lima'::text[])), ((yankee.charlie_six ->> 'two_four_hotel'::text)), ((yankee.charlie_six #>> 'bravo_two'::text[])), ((yankee.charlie_six #>> 'charlie_victor'::text[])), ((yankee.charlie_six #>> 'two_four_quebec'::text[])), ((yankee.charlie_six #>> 'seven_delta'::text[])), (((yankee.charlie_six #>> 'tango'::text[]))::boolean), (((yankee.charlie_six #>> 'bravo_romeo'::text[]))::boolean), (((yankee.charlie_six #>> 'lima'::text[]))::boolean)
2. 35.162 28,269.050 ↓ 2,807.0 2,807 1

Sort (cost=272.220..272.230 rows=1 width=768) (actual time=28,268.712..28,269.050 rows=2,807 loops=1)

  • Sort Key: ((foxtrot.charlie_six ->> 'four'::text)), (charlie_lima((foxtrot.charlie_six ->> 'zulu_echo'::text), 4)), ((yankee.charlie_six #>> 'mike_lima'::text[])), ((yankee.charlie_six ->> 'two_four_hotel'::text)), ((yankee.charlie_six #>> 'bravo_two'::text[])), ((yankee.charlie_six #>> 'charlie_victor'::text[])), ((yankee.charlie_six #>> 'two_four_quebec'::text[])), ((yankee.charlie_six #>> 'seven_delta'::text[])), (((yankee.charlie_six #>> 'tango'::text[]))::boolean), (((yankee.charlie_six #>> 'bravo_romeo'::text[]))::boolean), (((yankee.charlie_six #>> 'lima'::text[]))::boolean)
  • Sort Method: quicksort Memory: 2,947kB
3. 76.720 28,233.888 ↓ 2,807.0 2,807 1

Nested Loop (cost=187.900..272.210 rows=1 width=768) (actual time=148.777..28,233.888 rows=2,807 loops=1)

4. 105.916 28,137.519 ↓ 2,807.0 2,807 1

Nested Loop (cost=187.610..271.370 rows=1 width=2,138) (actual time=148.729..28,137.519 rows=2,807 loops=1)

5. 117.851 125.166 ↓ 191.0 191 1

Bitmap Heap Scan on seven_romeo foxtrot (cost=13.470..17.530 rows=1 width=1,629) (actual time=7.426..125.166 rows=191 loops=1)

  • Recheck Cond: ((juliet((charlie_six ->> 'zulu_echo'::text), 6, 5) >= 'echo_juliet'::text) AND (juliet((charlie_six ->> 'zulu_echo'::text), 6, 5) <= 'six'::text) AND (charlie_lima((charlie_six ->> 'zulu_echo'::text), 4) >= 'november_juliet'::text) AND (charlie_lima((charlie_six ->> 'zulu_echo'::text), 4) <= 'november_juliet'::text))
  • Filter: (((charlie_six #>> 'hotel_five'::text[]) = 'oscar_yankee'::text) AND (((charlie_six #>> 'zulu_mike'::text[]))::uuid = 'mike_papa'::uuid))
  • Rows Removed by Filter: 216
  • Heap Blocks: exact=403
6. 0.427 7.315 ↓ 0.0 0 1

BitmapAnd (cost=13.470..13.470 rows=1 width=0) (actual time=7.315..7.315 rows=0 loops=1)

7. 5.407 5.407 ↓ 14.0 3,245 1

Bitmap Index Scan on hotel_foxtrot (cost=0.000..6.610 rows=232 width=0) (actual time=5.407..5.407 rows=3,245 loops=1)

  • Index Cond: ((juliet((charlie_six ->> 'zulu_echo'::text), 6, 5) >= 'echo_juliet'::text) AND (juliet((charlie_six ->> 'zulu_echo'::text), 6, 5) <= 'six'::text))
8. 1.481 1.481 ↓ 22.5 5,219 1

Bitmap Index Scan on oscar_india (cost=0.000..6.610 rows=232 width=0) (actual time=1.481..1.481 rows=5,219 loops=1)

  • Index Cond: ((charlie_lima((charlie_six ->> 'zulu_echo'::text), 4) >= 'november_juliet'::text) AND (charlie_lima((charlie_six ->> 'zulu_echo'::text), 4) <= 'november_juliet'::text))
9. 415.807 27,906.437 ↑ 1.3 15 191

Bitmap Heap Scan on charlie_five three (cost=174.140..253.650 rows=20 width=509) (actual time=144.836..146.107 rows=15 loops=191)

  • Recheck Cond: (((charlie_six ->> 'echo_zulu'::text) = 'kilo'::text) AND (((charlie_six ->> 'zulu_two'::text))::uuid = ((foxtrot.charlie_six ->> 'delta'::text))::uuid))
  • Heap Blocks: exact=2,807
10. 904.003 27,490.630 ↓ 0.0 0 191

BitmapAnd (cost=174.140..174.140 rows=20 width=0) (actual time=143.930..143.930 rows=0 loops=191)

11. 26,462.095 26,462.095 ↓ 197.3 789,417 191

Bitmap Index Scan on november_november (cost=0.000..78.440 rows=4,002 width=0) (actual time=138.545..138.545 rows=789,417 loops=191)

  • Index Cond: ((charlie_six ->> 'echo_zulu'::text) = 'kilo'::text)
12. 124.532 124.532 ↑ 266.8 15 191

Bitmap Index Scan on bravo_delta (cost=0.000..94.450 rows=4,002 width=0) (actual time=0.652..0.652 rows=15 loops=191)

  • Index Cond: (((charlie_six ->> 'zulu_two'::text))::uuid = ((foxtrot.charlie_six ->> 'delta'::text))::uuid)
13. 19.649 19.649 ↑ 1.0 1 2,807

Index Scan using alpha on five yankee (cost=0.290..0.800 rows=1 width=1,531) (actual time=0.007..0.007 rows=1 loops=2,807)

  • Index Cond: (((charlie_six ->> 'delta'::text))::uuid = ((three.charlie_six ->> 'sierra'::text))::uuid)
Planning time : 0.824 ms
Execution time : 28,281.577 ms