explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0az2

Settings
# exclusive inclusive rows x rows loops node
1. 75.177 91.033 ↓ 0.0 0 1

Insert on outfit_visit_count (cost=0.29..660.15 rows=10,000 width=16) (actual time=91.033..91.033 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.911 15.856 ↑ 1.0 10,000 1

Subquery Scan on *SELECT* (cost=0.29..660.15 rows=10,000 width=16) (actual time=0.022..15.856 rows=10,000 loops=1)

3. 0.997 7.945 ↑ 1.0 10,000 1

Limit (cost=0.29..510.15 rows=10,000 width=12) (actual time=0.015..7.945 rows=10,000 loops=1)

4. 4.185 6.948 ↑ 8.0 10,000 1

GroupAggregate (cost=0.29..4,086.15 rows=80,137 width=12) (actual time=0.014..6.948 rows=10,000 loops=1)

  • Group Key: outfit_visit_history.id_outfit
5. 2.763 2.763 ↑ 8.0 10,001 1

Index Scan using idx_outfit_visit_history_id_outfit on outfit_visit_history (cost=0.29..2,884.01 rows=80,155 width=8) (actual time=0.010..2.763 rows=10,001 loops=1)

  • Index Cond: (id_outfit > 20000)
  • Filter: (deleted_at IS NULL)
Planning time : 0.139 ms
Execution time : 91.081 ms