explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XlwX

Settings
# exclusive inclusive rows x rows loops node
1. 1,925.572 10,544.115 ↓ 50.2 5,026,200 1

Gather (cost=1,000.56..423,421.28 rows=100,120 width=404) (actual time=4.809..10,544.115 rows=5,026,200 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 8,486.052 8,618.543 ↓ 40.2 1,675,400 3

Nested Loop (cost=0.56..407,883.05 rows=41,717 width=404) (actual time=1.504..8,618.543 rows=1,675,400 loops=3)

3. 132.474 132.474 ↓ 154.9 197,486 3

Parallel Seq Scan on flights_all_test fa (cost=0.00..61,121.26 rows=1,275 width=244) (actual time=1.442..132.474 rows=197,486 loops=3)

  • Filter: (d3pf AND (stay = (bedbanks_nights + 1)))
  • Rows Removed by Filter: 10208
4. 0.017 0.017 ↑ 10.5 8 592,457

Index Scan using ix_prices_test2 on prices_1000_test p (cost=0.56..268.59 rows=84 width=278) (actual time=0.011..0.017 rows=8 loops=592,457)

  • Index Cond: (flight_group_key = fa.flight_group_key)
Planning time : 0.861 ms