explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WUn7

Settings
# exclusive inclusive rows x rows loops node
1. 1,805.090 105,390.084 ↑ 1.8 352,143 1

Nested Loop (cost=0.00..14,228,432.57 rows=642,650 width=4,397) (actual time=0.198..105,390.084 rows=352,143 loops=1)

2. 25,042.833 25,042.833 ↑ 1.8 352,207 1

Index Scan using __sm_temp_ds_insert_3004_id_seq_idx on __sm_temp_ds_insert_3004 s (cost=0.00..145,842.10 rows=642,650 width=2,293) (actual time=0.124..25,042.833 rows=352,207 loops=1)

  • Index Cond: ((__sm_temp_ds_insert_3004_id_seq >= 7748555) AND (__sm_temp_ds_insert_3004_id_seq <= 8100761))
3. 78,542.161 78,542.161 ↑ 1.0 1 352,207

Index Scan using ds_internal_3004___sm_audience_id_idx on ds_internal_3004 d (cost=0.00..21.90 rows=1 width=2,104) (actual time=0.198..0.223 rows=1 loops=352,207)

  • Index Cond: (__sm_audience_id = s.__sm_audience_id)