explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5K7f

Settings
# exclusive inclusive rows x rows loops node
1. 5.185 2,207.094 ↑ 1.0 1 1

Aggregate (cost=2,883.32..2,883.33 rows=1 width=64) (actual time=2,207.094..2,207.094 rows=1 loops=1)

2.          

Initplan (forAggregate)

3. 2.645 4.129 ↑ 1.0 1 1

Aggregate (cost=195.44..195.45 rows=1 width=32) (actual time=4.129..4.129 rows=1 loops=1)

4. 1.484 1.484 ↑ 1.0 10,839 1

Seq Scan on filtered filtered_1 (cost=0.00..168.15 rows=10,915 width=8) (actual time=0.019..1.484 rows=10,839 loops=1)

5. 1.429 2,197.780 ↓ 8.5 1,697 1

Nested Loop (cost=900.65..2,686.87 rows=200 width=81) (actual time=37.322..2,197.780 rows=1,697 loops=1)

6. 7.086 10.615 ↓ 8.5 1,697 1

GroupAggregate (cost=900.22..1,011.87 rows=200 width=48) (actual time=2.701..10.615 rows=1,697 loops=1)

  • Group Key: filtered.hash
7. 2.523 3.529 ↑ 1.0 10,839 1

Sort (cost=900.22..927.51 rows=10,915 width=16) (actual time=2.651..3.529 rows=10,839 loops=1)

  • Sort Key: filtered.hash
  • Sort Method: quicksort Memory: 893kB
8. 1.006 1.006 ↑ 1.0 10,839 1

Seq Scan on filtered (cost=0.00..168.15 rows=10,915 width=16) (actual time=0.009..1.006 rows=10,839 loops=1)

9. 2,185.736 2,185.736 ↑ 1.0 1 1,697

Index Scan using hashes_pkey on hashes (cost=0.43..8.37 rows=1 width=49) (actual time=1.288..1.288 rows=1 loops=1,697)

  • Index Cond: (id = filtered.hash)
Planning time : 111.049 ms
Execution time : 2,207.350 ms