explain.depesz.com

PostgreSQL's explain analyze made readable

Result: id2i

Settings
# exclusive inclusive rows x rows loops node
1. 116,374.787 118,466.050 ↓ 0.0 0 1

Update on account_setting_ (cost=1.24..56,603.87 rows=85,701 width=76) (actual time=118,466.050..118,466.050 rows=0 loops=1)

2. 1,478.268 2,091.263 ↑ 1.0 85,280 1

Nested Loop (cost=1.24..56,603.87 rows=85,701 width=76) (actual time=0.088..2,091.263 rows=85,280 loops=1)

3. 0.001 0.054 ↑ 1.0 1 1

Nested Loop (cost=1.24..25.32 rows=1 width=372) (actual time=0.049..0.054 rows=1 loops=1)

4. 0.002 0.038 ↑ 1.0 1 1

Nested Loop (cost=0.83..16.88 rows=1 width=197) (actual time=0.036..0.038 rows=1 loops=1)

5. 0.014 0.014 ↑ 1.0 1 1

Index Scan using account_setting__account_id_key on account_setting_ ast (cost=0.42..8.44 rows=1 width=14) (actual time=0.013..0.014 rows=1 loops=1)

  • Index Cond: (account_id = 70095)
6. 0.022 0.022 ↑ 1.0 1 1

Index Scan using key_value_key_account_id_ttl_idx on key_value k1 (cost=0.41..8.43 rows=1 width=191) (actual time=0.022..0.022 rows=1 loops=1)

  • Index Cond: ((key = 'departuresScheduleCountryFrom'::text) AND (account_id = 70095))
7. 0.015 0.015 ↑ 1.0 1 1

Index Scan using key_value_key_account_id_ttl_idx on key_value k2 (cost=0.41..8.43 rows=1 width=191) (actual time=0.012..0.015 rows=1 loops=1)

  • Index Cond: ((key = 'departuresScheduleCountryTo'::text) AND (account_id = 70095))
8. 612.941 612.941 ↑ 1.0 85,280 1

Seq Scan on account_setting_ (cost=0.00..53,579.01 rows=85,701 width=539) (actual time=0.015..612.941 rows=85,280 loops=1)