explain.depesz.com

PostgreSQL's explain analyze made readable

Result: F86D

Settings
# exclusive inclusive rows x rows loops node
1. 1.828 298.107 ↑ 1.0 1 1

Aggregate (cost=2,624.02..2,624.03 rows=1 width=64) (actual time=298.107..298.107 rows=1 loops=1)

2.          

Initplan (forAggregate)

3. 0.865 1.435 ↑ 1.0 1 1

Aggregate (cost=155.69..155.70 rows=1 width=32) (actual time=1.435..1.435 rows=1 loops=1)

4. 0.570 0.570 ↑ 1.0 8,695 1

Seq Scan on filtered filtered_1 (cost=0.00..133.95 rows=8,695 width=8) (actual time=0.011..0.570 rows=8,695 loops=1)

5. 0.153 294.844 ↓ 5.4 1,089 1

Nested Loop (cost=703.29..2,467.31 rows=200 width=81) (actual time=2.051..294.844 rows=1,089 loops=1)

6. 3.648 6.106 ↓ 5.4 1,089 1

GroupAggregate (cost=702.86..792.31 rows=200 width=48) (actual time=2.037..6.106 rows=1,089 loops=1)

  • Group Key: filtered.hash
7. 1.616 2.458 ↑ 1.0 8,695 1

Sort (cost=702.86..724.60 rows=8,695 width=16) (actual time=2.014..2.458 rows=8,695 loops=1)

  • Sort Key: filtered.hash
  • Sort Method: quicksort Memory: 792kB
8. 0.842 0.842 ↑ 1.0 8,695 1

Seq Scan on filtered (cost=0.00..133.95 rows=8,695 width=16) (actual time=0.012..0.842 rows=8,695 loops=1)

9. 288.585 288.585 ↑ 1.0 1 1,089

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

  • Index Cond: (id = filtered.hash)