explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WY0d

Settings
# exclusive inclusive rows x rows loops node
1. 0.446 7.165 ↑ 1.1 1,007 1

WindowAgg (cost=675.16..694.83 rows=1,124 width=318) (actual time=6.643..7.165 rows=1,007 loops=1)

2. 0.898 6.719 ↑ 1.1 1,007 1

Sort (cost=675.16..677.97 rows=1,124 width=310) (actual time=6.637..6.719 rows=1,007 loops=1)

  • Sort Key: l.internal_reference_id DESC
  • Sort Method: quicksort Memory: 407kB
3. 1.333 5.821 ↑ 1.1 1,007 1

Hash Join (cost=286.97..618.20 rows=1,124 width=310) (actual time=3.994..5.821 rows=1,007 loops=1)

  • Hash Cond: (lf.load_id = l.id)
4. 0.509 0.509 ↓ 1.0 4,367 1

Seq Scan on load_fact lf (cost=0.00..303.63 rows=4,363 width=138) (actual time=0.007..0.509 rows=4,367 loops=1)

5. 0.366 3.979 ↑ 1.2 943 1

Hash (cost=273.22..273.22 rows=1,100 width=188) (actual time=3.979..3.979 rows=943 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 170kB
6. 0.408 3.613 ↑ 1.2 943 1

Hash Join (cost=226.10..273.22 rows=1,100 width=188) (actual time=3.171..3.613 rows=943 loops=1)

  • Hash Cond: (tl.id = l.id)
7. 0.121 0.121 ↑ 1.2 943 1

Seq Scan on temp_load tl (cost=0.00..32.00 rows=1,100 width=8) (actual time=0.006..0.121 rows=943 loops=1)

  • Filter: should_return
8. 1.588 3.084 ↑ 1.0 4,242 1

Hash (cost=172.71..172.71 rows=4,271 width=180) (actual time=3.084..3.084 rows=4,242 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 933kB
9. 1.496 1.496 ↑ 1.0 4,242 1

Seq Scan on load l (cost=0.00..172.71 rows=4,271 width=180) (actual time=0.006..1.496 rows=4,242 loops=1)

Planning time : 0.356 ms
Execution time : 7.454 ms