explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ykk1

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 6.646 ↓ 1.3 8 1

Unique (cost=1,241.64..1,241.69 rows=6 width=8) (actual time=6.640..6.646 rows=8 loops=1)

2. 0.012 6.639 ↓ 1.7 10 1

Sort (cost=1,241.64..1,241.66 rows=6 width=8) (actual time=6.639..6.639 rows=10 loops=1)

  • Sort Key: four1.tango, two_uniform.zulu
  • Sort Method: quicksort Memory: 25kB
3. 0.012 6.627 ↓ 1.7 10 1

Nested Loop (cost=0.86..1,241.57 rows=6 width=8) (actual time=2.442..6.627 rows=10 loops=1)

  • Join Filter: (four1.two_charlie = four2.two_charlie)
4. 0.003 6.599 ↓ 2.7 8 1

Nested Loop (cost=0.57..1,240.48 rows=3 width=20) (actual time=2.436..6.599 rows=8 loops=1)

5. 0.012 6.580 ↓ 2.7 8 1

Nested Loop (cost=0.29..1,239.01 rows=3 width=16) (actual time=2.429..6.580 rows=8 loops=1)

6. 6.544 6.544 ↓ 1.1 8 1

Seq Scan on whiskey_romeo two_uniform (cost=0.00..1,184.82 rows=7 width=8) (actual time=2.416..6.544 rows=8 loops=1)

  • Filter: ((delta = 'victor'::text) AND (zulu = ANY ('charlie'::integer[])))
  • Rows Removed by Filter: 30,305
7. 0.024 0.024 ↑ 1.0 1 8

Index Only Scan using whiskey_kilo on five india (cost=0.29..7.73 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=8)

  • Index Cond: (two_charlie = two_uniform.two_charlie)
  • Heap Fetches: 8
8. 0.016 0.016 ↑ 1.0 1 8

Index Only Scan using golf on whiskey_five echo (cost=0.29..0.49 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=8)

  • Index Cond: (two_charlie = four1.two_charlie)
  • Heap Fetches: 0
9. 0.016 0.016 ↑ 1.0 1 8

Index Only Scan using whiskey_kilo on five juliet (cost=0.29..0.35 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=8)

  • Index Cond: (two_charlie = echo.two_charlie)
  • Heap Fetches: 10
Planning time : 1.232 ms
Execution time : 6.696 ms