explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iIRW : Optimization for: Optimization for: 1; plan #QuEd; plan #KgN7

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.032 0.370 ↑ 898,787.0 2 1

GroupAggregate (cost=3,222,846.84..3,434,122.59 rows=1,797,574 width=104) (actual time=0.366..0.370 rows=2 loops=1)

  • Group Key: uniform.november
2. 0.064 0.338 ↑ 1,438,545.6 10 1

Sort (cost=3,222,846.84..3,258,810.48 rows=14,385,456 width=36) (actual time=0.337..0.338 rows=10 loops=1)

  • Sort Key: uniform.november
  • Sort Method: quicksort Memory: 25kB
3. 0.002 0.274 ↑ 1,438,545.6 10 1

Nested Loop (cost=171,844.13..1,119,197.74 rows=14,385,456 width=36) (actual time=0.189..0.274 rows=10 loops=1)

4. 0.068 0.218 ↑ 22,157.5 2 1

HashAggregate (cost=171,843.43..172,286.58 rows=44,315 width=8) (actual time=0.155..0.218 rows=2 loops=1)

  • Group Key: juliet1.november
5. 0.021 0.150 ↑ 22,434.5 2 1

Bitmap Heap Scan on uniform xray_zulu (cost=1,944.01..171,731.25 rows=44,869 width=8) (actual time=0.144..0.150 rows=2 loops=1)

  • Recheck Cond: ((whiskey ~~ 'four'::text) OR (whiskey ~~ 'sierra_seven'::text) OR (whiskey ~~ 'delta'::text) OR (whiskey ~~ 'echo'::text) OR (whiskey ~~ 'xray_five'::text) OR (whiskey ~~ 'bravo'::text))
  • Filter: ((whiskey ~~ 'four'::text) OR (whiskey ~~ 'sierra_seven'::text) OR (whiskey ~~ 'delta'::text) OR (whiskey ~~ 'echo'::text) OR (whiskey ~~ 'xray_five'::text) OR (whiskey ~~ 'bravo'::text))
  • Heap Blocks: exact=2
6. 0.000 0.129 ↓ 0.0 0 1

BitmapOr (cost=1,944.01..1,944.01 rows=44,871 width=0) (actual time=0.129..0.129 rows=0 loops=1)

7. 0.036 0.036 ↑ 7,478.0 1 1

Bitmap Index Scan on xray_alpha (cost=0.00..312.78 rows=7,478 width=0) (actual time=0.035..0.036 rows=1 loops=1)

  • Index Cond: (whiskey = 'four'::text)
8. 0.017 0.017 ↓ 0.0 0 1

Bitmap Index Scan on xray_alpha (cost=0.00..312.78 rows=7,478 width=0) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: (whiskey = 'sierra_seven'::text)
9. 0.016 0.016 ↓ 0.0 0 1

Bitmap Index Scan on xray_alpha (cost=0.00..312.78 rows=7,478 width=0) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (whiskey = 'delta'::text)
10. 0.021 0.021 ↓ 0.0 0 1

Bitmap Index Scan on xray_alpha (cost=0.00..312.78 rows=7,478 width=0) (actual time=0.021..0.021 rows=0 loops=1)

  • Index Cond: (whiskey = 'echo'::text)
11. 0.019 0.019 ↑ 7,478.0 1 1

Bitmap Index Scan on xray_alpha (cost=0.00..312.78 rows=7,478 width=0) (actual time=0.019..0.019 rows=1 loops=1)

  • Index Cond: (whiskey = 'xray_five'::text)
12. 0.020 0.020 ↓ 0.0 0 1

Bitmap Index Scan on xray_alpha (cost=0.00..312.78 rows=7,478 width=0) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: (whiskey = 'bravo'::text)
13. 0.054 0.054 ↑ 64.2 5 2

Index Only Scan using sierra_yankee on uniform (cost=0.70..18.16 rows=321 width=36) (actual time=0.027..0.027 rows=5 loops=2)

  • Index Cond: (november = juliet1.november)
  • Heap Fetches: 0