explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BcGk

Settings
# exclusive inclusive rows x rows loops node
1. 15.945 192.521 ↓ 9.4 15,395 1

Unique (cost=37,131.41..37,225.48 rows=1,636 width=1,183) (actual time=149.744..192.521 rows=15,395 loops=1)

2. 155.475 176.576 ↓ 9.4 15,395 1

Sort (cost=37,131.41..37,135.50 rows=1,636 width=1,183) (actual time=149.741..176.576 rows=15,395 loops=1)

  • Sort Key: saconnecti0_.outdated_time, saconnecti0_.id, saconnecti1_.id, saconnecti0_.connection_id, saconnecti0_.connectivity, saconnecti0_.connectivity_changed, saconnecti0_.outdated_cause, saconne
  • Sort Method: external merge Disk: 26552kB
3. 18.508 21.101 ↓ 9.4 15,395 1

Nested Loop Left Join (cost=0.97..37,044.08 rows=1,636 width=1,183) (actual time=0.039..21.101 rows=15,395 loops=1)

  • -> Index Scan using sa_connection_interface_pair_sa_connection_id_idx on sa_connection_interface_pair saconnecti1_ (cost=0.43..361.06 rows=115 width=796) (actual time=0.009..0.133 rows=156 l
4. 2.593 2.593 ↑ 1.0 99 1

Index Scan using sa_connection_pkey on sa_connection saconnecti0_ (cost=0.54..822.73 rows=100 width=387) (actual time=0.019..2.593 rows=99 loops=1)

  • Index Cond: (id = ANY ('{125444,114183,116488,116491,115981,115980,148755,134163,144656,145942,129813,115991,124954,135710,139811,111651,146464,117794,144936,125996,144940,139821,150834,
  • Index Cond: (saconnecti0_.id = sa_connection_id)