explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BL3e

Settings
# exclusive inclusive rows x rows loops node
1. 9,831.678 9,860.402 ↑ 1.0 532,416 1

Nested Loop (cost=0.00..1,071,795.07 rows=532,416 width=50) (actual time=2.202..9,860.402 rows=532,416 loops=1)

2. 6.068 6.068 ↑ 1.0 11,328 1

Seq Scan on person_preflop_start_stats_average_per_person ip (cost=0.00..306.28 rows=11,328 width=94) (actual time=0.012..6.068 rows=11,328 loops=1)

3. 22.634 22.656 ↑ 1.0 47 11,328

Materialize (cost=0.00..1.71 rows=47 width=36) (actual time=0.000..0.002 rows=47 loops=11,328)

4. 0.022 0.022 ↑ 1.0 47 1

Seq Scan on person_preflop_start_stats_average ia (cost=0.00..1.47 rows=47 width=36) (actual time=0.012..0.022 rows=47 loops=1)