explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ecAe

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 13.288 ↑ 1.0 1 1

Subquery Scan on t3 (cost=2,198.61..2,198.64 rows=1 width=68) (actual time=13.288..13.288 rows=1 loops=1)

2. 3.233 13.284 ↑ 1.0 1 1

Aggregate (cost=2,198.61..2,198.62 rows=1 width=64) (actual time=13.284..13.284 rows=1 loops=1)

3.          

Initplan (forAggregate)

4. 0.609 0.988 ↑ 1.0 1 1

Aggregate (cost=107.10..107.11 rows=1 width=32) (actual time=0.988..0.988 rows=1 loops=1)

5. 0.379 0.379 ↓ 1.1 4,921 1

Seq Scan on filtered filtered_1 (cost=0.00..95.88 rows=4,488 width=8) (actual time=0.005..0.379 rows=4,921 loops=1)

6. 0.000 9.063 ↓ 9.2 1,841 1

Nested Loop (cost=368.55..2,090.50 rows=200 width=81) (actual time=1.836..9.063 rows=1,841 loops=1)

7. 3.420 5.517 ↓ 9.2 1,841 1

GroupAggregate (cost=368.12..415.50 rows=200 width=48) (actual time=1.824..5.517 rows=1,841 loops=1)

  • Group Key: filtered.hash
8. 1.394 2.097 ↓ 1.1 4,921 1

Sort (cost=368.12..379.34 rows=4,488 width=16) (actual time=1.799..2.097 rows=4,921 loops=1)

  • Sort Key: filtered.hash
  • Sort Method: quicksort Memory: 423kB
9. 0.703 0.703 ↓ 1.1 4,921 1

Seq Scan on filtered (cost=0.00..95.88 rows=4,488 width=16) (actual time=0.009..0.703 rows=4,921 loops=1)

10. 3.682 3.682 ↑ 1.0 1 1,841

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

  • Index Cond: (id = filtered.hash)