explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Rgn4

Settings
# exclusive inclusive rows x rows loops node
1. 1,946.146 10,529.405 ↓ 50.3 5,026,200 1

Gather (cost=1,000.56..423,623.06 rows=99,957 width=404) (actual time=4.282..10,529.405 rows=5,026,200 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 8,448.690 8,583.259 ↓ 40.2 1,675,400 3

Nested Loop (cost=0.56..408,108.49 rows=41,649 width=404) (actual time=1.254..8,583.259 rows=1,675,400 loops=3)

3. 134.552 134.552 ↓ 155.1 197,486 3

Parallel Seq Scan on flights_all_test fa (cost=0.00..61,770.30 rows=1,273 width=244) (actual time=1.185..134.552 rows=197,486 loops=3)

  • Filter: (d3pf AND (seats >= 1) 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.69 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.855 ms