explain.depesz.com

PostgreSQL's explain analyze made readable

Result: luk2 : Optimization for: plan #aP9g

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 185.286 471.792 ↓ 96.0 255,401 1

Sort (cost=15,153.360..15,160.010 rows=2,661 width=12) (actual time=408.467..471.792 rows=255,401 loops=1)

  • Sort Key: papa.charlie
  • Sort Method: external merge Disk: 6504kB
2. 101.371 286.506 ↓ 96.0 255,401 1

Nested Loop (cost=1,073.140..15,001.980 rows=2,661 width=12) (actual time=5.246..286.506 rows=255,401 loops=1)

3. 0.031 0.031 ↓ 8.0 8 1

Index Scan using three on alpha uniform (cost=0.140..8.160 rows=1 width=4) (actual time=0.014..0.031 rows=8 loops=1)

  • Index Cond: (seven = 3)
  • Filter: (victor <> 2)
4. 160.560 185.104 ↓ 6.3 31,925 8

Bitmap Heap Scan on papa (cost=1,073.000..14,943.130 rows=5,069 width=16) (actual time=3.980..23.138 rows=31,925 loops=8)

  • Recheck Cond: (five = kilo_hotel0.quebec)
  • Filter: ((victor <> 2) AND (victor <> november ('golf'::integer[])) AND ((victor = 4) OR (victor = 3) OR ((victor = 1) AND (charlie < 'echo'::timestamp with time zone))))
  • Rows Removed by Filter: 35562
  • Heap Blocks: exact=20577
5. 24.544 24.544 ↓ 2.4 67,487 8

Bitmap Index Scan on kilo_victor (cost=0.000..1,071.730 rows=27,641 width=0) (actual time=3.068..3.068 rows=67,487 loops=8)

  • Index Cond: (five = kilo_hotel0.quebec)