explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lHbl

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 82,195.766 ↑ 10.5 2 1

Limit (cost=1,838,494.24..1,838,494.29 rows=21 width=28) (actual time=82,195.766..82,195.766 rows=2 loops=1)

2. 0.014 82,195.765 ↑ 10.5 2 1

Sort (cost=1,838,494.24..1,838,494.29 rows=21 width=28) (actual time=82,195.765..82,195.765 rows=2 loops=1)

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

Finalize GroupAggregate (cost=1,838,487.77..1,838,493.09 rows=21 width=28) (actual time=82,195.750..82,195.751 rows=2 loops=1)

  • Group Key: t1._fld32821rref
4. 84.915 82,210.640 ↑ 10.5 4 1

Gather Merge (cost=1,838,487.77..1,838,492.67 rows=42 width=28) (actual time=82,195.744..82,210.640 rows=4 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 0.029 82,125.725 ↑ 21.0 1 3 / 3

Sort (cost=1,837,487.74..1,837,487.79 rows=21 width=28) (actual time=82,125.725..82,125.725 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.026 82,125.696 ↑ 21.0 1 3 / 3

Partial HashAggregate (cost=1,837,486.51..1,837,486.72 rows=21 width=28) (actual time=82,125.696..82,125.696 rows=1 loops=3)

  • Group Key: t1._fld32821rref
7. 533.388 82,125.670 ↑ 72,898.2 61 3 / 3

Hash Anti Join (cost=9.09..1,815,252.56 rows=4,446,790 width=28) (actual time=489.331..82,125.670 rows=61 loops=3)

  • Hash Cond: (t1._fld32821rref = t2._fld74574_rrref)
8. 81,570.929 81,570.929 ↑ 1.2 3,609,831 3 / 3

Parallel Seq Scan on _accumrg32819 t1 (cost=0.00..1,759,068.20 rows=4,456,000 width=28) (actual time=18.961..81,570.929 rows=3,609,831 loops=3)

  • Filter: ((_period >= '2014-01-01 00:00:00'::timestamp without time zone) AND (_fld1389 = '0'::numeric) AND ((_period < '2014-12-31 23:59:59'::timestamp without time zone) OR (_period = '2014-12-31 23:59:59'::timestamp without time zone)))
  • Rows Removed by Filter: 4668137
9. 0.011 21.353 ↓ 23.0 23 3 / 3

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

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

Index Scan using _inforg74571_1 on _inforg74571 t2 (cost=0.55..9.07 rows=1 width=17) (actual time=10.062..21.342 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 : 187.555 ms
Execution time : 82,210.832 ms