explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JiIj

Settings

Optimization(s) for this plan:

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

Limit (cost=3,273,648.130..9,924,067.120 rows=1,000 width=42) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=3,273,648.130..10,057,075.500 rows=1,020 width=42) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Merge Join (cost=3,273,647.430..10,055,599.790 rows=1,020 width=81) (actual rows= loops=)

  • Merge Cond: ((juliet.victor = papa_foxtrot.victor) AND (juliet.romeo = papa_foxtrot.romeo))
4. 0.000 0.000 ↓ 0.0

Index Scan using mike on papa_victor juliet (cost=0.700..15,932,356.860 rows=25,704,683 width=164) (actual rows= loops=)

  • Index Cond: (golf = 'delta'::text)
5. 0.000 0.000 ↓ 0.0

Materialize (cost=3,273,646.560..3,339,214.560 rows=13,113,599 width=162) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Sort (cost=3,273,646.560..3,306,430.560 rows=13,113,599 width=162) (actual rows= loops=)

  • Sort Key: papa_foxtrot.victor, papa_foxtrot.romeo
7. 0.000 0.000 ↓ 0.0

Seq Scan on uniform papa_foxtrot (cost=0.000..1,093,252.650 rows=13,113,599 width=162) (actual rows= loops=)

  • Filter: (golf = 'delta'::text)
8. 0.000 0.000 ↓ 0.0

Index Scan using india on november lima (cost=0.700..1.440 rows=1 width=43) (actual rows= loops=)

  • Index Cond: (hotel = juliet.hotel)