explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NUcn

Settings
# exclusive inclusive rows x rows loops node
1. 78.574 110.843 ↓ 0.0 0 1

Insert on outfit_visit_count (cost=969.17..1,603.61 rows=10,000 width=16) (actual time=110.843..110.843 rows=0 loops=1)

  • Conflict Resolution: UPDATE
  • Conflict Arbiter Indexes: udx_outfit_visit_count_id_outfit
  • Tuples Inserted: 0
  • Conflicting Tuples: 10,000
2. 7.831 32.269 ↑ 1.0 10,000 1

Subquery Scan on *SELECT* (cost=969.17..1,603.61 rows=10,000 width=16) (actual time=16.546..32.269 rows=10,000 loops=1)

3. 2.146 24.438 ↑ 1.0 10,000 1

Limit (cost=969.17..1,453.61 rows=10,000 width=12) (actual time=16.532..24.438 rows=10,000 loops=1)

4. 13.956 22.292 ↑ 3.3 30,000 1

GroupAggregate (cost=0.29..4,843.03 rows=99,966 width=12) (actual time=0.026..22.292 rows=30,000 loops=1)

  • Group Key: outfit_visit_history.id_outfit
5. 8.336 8.336 ↑ 3.3 30,005 1

Index Scan using idx_outfit_visit_history_id_outfit on outfit_visit_history (cost=0.29..3,343.35 rows=100,004 width=8) (actual time=0.019..8.336 rows=30,005 loops=1)

  • Filter: (deleted_at IS NULL)
Planning time : 0.175 ms
Execution time : 110.932 ms