explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 991D

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 1,868.613 ↓ 43.0 43 1

Limit (cost=80.340..80.350 rows=1 width=93) (actual time=1,868.526..1,868.613 rows=43 loops=1)

2. 0.063 1,868.607 ↓ 43.0 43 1

Unique (cost=80.340..80.350 rows=1 width=93) (actual time=1,868.524..1,868.607 rows=43 loops=1)

3. 0.404 1,868.544 ↓ 74.0 222 1

Sort (cost=80.340..80.350 rows=3 width=93) (actual time=1,868.523..1,868.544 rows=222 loops=1)

  • Sort Key: "oscar".quebec_seven
  • Sort Method: quicksort Memory: 56kB
4. 0.247 1,868.140 ↓ 74.0 222 1

Nested Loop (cost=0.860..80.310 rows=3 width=93) (actual time=1,179.781..1,868.140 rows=222 loops=1)

5. 1,311.430 1,311.430 ↓ 43.0 43 1

Index Scan using xray on oscar (cost=0.430..71.580 rows=1 width=93) (actual time=1,161.689..1,311.430 rows=43 loops=1)

  • Index Cond: ((victor)::text = 'kilo'::text)
  • Filter: ((zulu)::text = 'quebec_two'::text)
  • Rows Removed by Filter: 885
6. 556.463 556.463 ↑ 2.2 5 43

Index Only Scan using alpha on romeo (cost=0.430..8.620 rows=11 width=8) (actual time=12.716..12.941 rows=5 loops=43)

  • Index Cond: (charlie = "oscar".quebec_seven)
  • Heap Fetches: 3
Planning time : 2.107 ms
Execution time : 1,868.709 ms