explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ofbn

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 6,653.829 ↑ 10.5 2 1

Limit (cost=1,864,556.33..1,864,556.39 rows=21 width=28) (actual time=6,653.829..6,653.829 rows=2 loops=1)

2. 0.013 6,653.828 ↑ 10.5 2 1

Sort (cost=1,864,556.33..1,864,556.39 rows=21 width=28) (actual time=6,653.828..6,653.828 rows=2 loops=1)

  • Sort Key: (max(t1._period)) DESC, t1._fld32821rref
  • Sort Method: quicksort Memory: 25kB
3. 0.000 6,653.815 ↑ 10.5 2 1

Finalize GroupAggregate (cost=1,864,549.86..1,864,555.18 rows=21 width=28) (actual time=6,653.813..6,653.815 rows=2 loops=1)

  • Group Key: t1._fld32821rref
4. 38.899 6,659.582 ↑ 10.5 4 1

Gather Merge (cost=1,864,549.86..1,864,554.76 rows=42 width=28) (actual time=6,653.810..6,659.582 rows=4 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 0.027 6,620.683 ↑ 21.0 1 3 / 3

Sort (cost=1,863,549.84..1,863,549.89 rows=21 width=28) (actual time=6,620.683..6,620.683 rows=1 loops=3)

  • Sort Key: t1._fld32821rref
  • Sort Method: quicksort Memory: 25kB
  • Worker 0: Sort Method: quicksort Memory: 25kB
  • Worker 1: Sort Method: quicksort Memory: 25kB
6. 0.025 6,620.656 ↑ 21.0 1 3 / 3

Partial HashAggregate (cost=1,863,548.60..1,863,548.81 rows=21 width=28) (actual time=6,620.656..6,620.656 rows=1 loops=3)

  • Group Key: t1._fld32821rref
7. 804.324 6,620.631 ↑ 169,279.9 61 3 / 3

Hash Anti Join (cost=9.09..1,811,918.23 rows=10,326,075 width=28) (actual time=41.508..6,620.631 rows=61 loops=3)

  • Hash Cond: (t1._fld32821rref = t2._fld74574_rrref)
8. 5,816.226 5,816.226 ↑ 1.2 8,277,968 3 / 3

Parallel Seq Scan on _accumrg32819 t1 (cost=0.00..1,681,462.25 rows=10,347,460 width=28) (actual time=0.081..5,816.226 rows=8,277,968 loops=3)

  • Filter: (_fld1389 = '0'::numeric)
9. 0.008 0.081 ↓ 23.0 23 3 / 3

Hash (cost=9.07..9.07 rows=1 width=17) (actual time=0.081..0.081 rows=23 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
10. 0.073 0.073 ↓ 23.0 23 3 / 3

Index Scan using _inforg74571_1 on _inforg74571 t2 (cost=0.55..9.07 rows=1 width=17) (actual time=0.049..0.073 rows=23 loops=3)

  • Index Cond: ((_fld1389 = '0'::numeric) AND (_fld74572_type = '\\x08'::bytea) AND (_fld74572_rtref = '\\x00000099'::bytea) AND (_fld74572_rrref = '\\x8cda000c29b4f2a211e3ba42c12a08eb'::bytea) AND (_fld74573 = false) AND (_fld74574_type = '\\x08'::bytea) AND (_fld74574_rtref = '\\x000000d7'::bytea) AND (_fld74575_type = '\\x08'::bytea) AND (_fld74575_rtref = '\\x000082ed'::bytea) AND (_fld74575_rrref = '\\x9998bc573f4038d745ebec0464ef1b5c'::bytea) AND (_fld74576_type = '\\x08'::bytea) AND (_fld74576_rtref = '\\x000082ed'::bytea) AND (_fld74576_rrref = '\\x9998bc573f4038d745ebec0464ef1b5c'::bytea) AND (_fld74577_type = '\\x08'::bytea) AND (_fld74577_rtref = '\\x000082ed'::bytea))
  • Filter: ((NOT _fld74573) AND (_fld74577_rrref = '\\x9998bc573f4038d745ebec0464ef1b5c'::bytea) AND (_fld74578_type = '\\x08'::bytea) AND (_fld74578_rtref = '\\x000082ed'::bytea) AND (_fld74578_rrref = '\\x9998bc573f4038d745ebec0464ef1b5c'::bytea))
Planning time : 1.628 ms
Execution time : 6,659.749 ms