explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mZbe

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 6,312.726 ↑ 10.5 2 1

Limit (cost=1,838,494.24..1,838,494.29 rows=21 width=28) (actual time=6,312.725..6,312.726 rows=2 loops=1)

2. 0.012 6,312.724 ↑ 10.5 2 1

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

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

Finalize GroupAggregate (cost=1,838,487.77..1,838,493.09 rows=21 width=28) (actual time=6,312.711..6,312.712 rows=2 loops=1)

  • Group Key: t1._fld32821rref
4. 47.755 6,328.425 ↑ 10.5 4 1

Gather Merge (cost=1,838,487.77..1,838,492.67 rows=42 width=28) (actual time=6,312.707..6,328.425 rows=4 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 0.035 6,280.670 ↑ 21.0 1 3 / 3

Sort (cost=1,837,487.74..1,837,487.79 rows=21 width=28) (actual time=6,280.670..6,280.670 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.028 6,280.635 ↑ 21.0 1 3 / 3

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

  • Group Key: t1._fld32821rref
7. 352.637 6,280.607 ↑ 72,898.2 61 3 / 3

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

  • Hash Cond: (t1._fld32821rref = t2._fld74574_rrref)
8. 5,927.876 5,927.876 ↑ 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=0.061..5,927.876 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.008 0.094 ↓ 23.0 23 3 / 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
10. 0.086 0.086 ↓ 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.062..0.086 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.758 ms
Execution time : 6,328.593 ms