explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 15H7

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

Limit (cost=1,291.460..5,514.960 rows=208 width=379) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,291.460..5,514.960 rows=208 width=379) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,291.030..5,328.720 rows=335 width=387) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on two (cost=1,290.590..2,501.130 rows=335 width=8) (actual rows= loops=)

  • Recheck Cond: (oscar ?| 'echo'::text[])
5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on delta_foxtrot (cost=0.000..1,290.510 rows=335 width=0) (actual rows= loops=)

  • Index Cond: (oscar ?| 'echo'::text[])
6. 0.000 0.000 ↓ 0.0

Index Scan using hotel_lima on charlie (cost=0.430..8.440 rows=1 width=379) (actual rows= loops=)

  • Index Cond: (romeo = two.romeo)
7. 0.000 0.000 ↓ 0.0

Index Scan using november on zulu (cost=0.430..0.560 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (romeo = charlie.romeo)
  • Filter: (mike = 'delta_three'::hotel_romeo)