explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Iycu

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 122,950.019 ↓ 0.0 0 1

Limit (cost=1,863,764.07..1,863,764.12 rows=21 width=28) (actual time=122,950.019..122,950.019 rows=0 loops=1)

2. 0.013 122,950.018 ↓ 0.0 0 1

Sort (cost=1,863,764.07..1,863,764.12 rows=21 width=28) (actual time=122,950.018..122,950.018 rows=0 loops=1)

  • Sort Key: (max(t1._period)) DESC, t1._fld32821rref
  • Sort Method: quicksort Memory: 25kB
3. 0.000 122,950.005 ↓ 0.0 0 1

Finalize GroupAggregate (cost=1,863,757.60..1,863,762.92 rows=21 width=28) (actual time=122,950.005..122,950.005 rows=0 loops=1)

  • Group Key: t1._fld32821rref
4. 163.918 122,955.471 ↓ 0.0 0 1

Gather Merge (cost=1,863,757.60..1,863,762.50 rows=42 width=28) (actual time=122,950.003..122,955.471 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 0.024 122,791.553 ↓ 0.0 0 3 / 3

Sort (cost=1,862,757.57..1,862,757.62 rows=21 width=28) (actual time=122,791.553..122,791.553 rows=0 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.004 122,791.529 ↓ 0.0 0 3 / 3

Partial HashAggregate (cost=1,862,756.34..1,862,756.55 rows=21 width=28) (actual time=122,791.529..122,791.529 rows=0 loops=3)

  • Group Key: t1._fld32821rref
7. 711.144 122,791.525 ↓ 0.0 0 3 / 3

Hash Anti Join (cost=9.13..1,833,356.81 rows=5,879,906 width=28) (actual time=122,791.523..122,791.525 rows=0 loops=3)

  • Hash Cond: (t1._fld32821rref = t2._fld74574_rrref)
8. 121,976.583 121,976.583 ↑ 1.3 4,668,137 3 / 3

Parallel Seq Scan on _accumrg32819 t1 (cost=0.00..1,759,068.20 rows=5,892,083 width=28) (actual time=57,224.460..121,976.583 rows=4,668,137 loops=3)

  • Filter: ((_period >= '2015-01-01 00:00:00'::timestamp without time zone) AND (_fld1389 = '0'::numeric) AND ((_period < '2015-12-31 17:05:45'::timestamp without time zone) OR (_period = '2015-12-31 17:05:45'::timestamp without time zone)))
  • Rows Removed by Filter: 3609831
9. 0.023 103.798 ↓ 25.0 25 3 / 3

Hash (cost=9.12..9.12 rows=1 width=17) (actual time=103.798..103.798 rows=25 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
10. 103.775 103.775 ↓ 25.0 25 3 / 3

Index Scan using _inforg74571_1 on _inforg74571 t2 (cost=0.55..9.12 rows=1 width=17) (actual time=93.046..103.775 rows=25 loops=3)

  • Index Cond: ((_fld1389 = '0'::numeric) AND (_fld74572_type = '\\010'::bytea) AND (_fld74572_rtref = '\\000\\000\\000\\231'::bytea) AND (_fld74572_rrref = '\\214\\332\\000\\014)\\264\\362\\242\\021\\343\\272B\\301*\\010\\353'::bytea) AND (_fld74573 = false) AND (_fld74574_type = '\\010'::bytea) AND (_fld74574_rtref = '\\000\\000\\000\\327'::bytea) AND (_fld74575_type = '\\010'::bytea) AND (_fld74575_rtref = '\\000\\000\\202\\355'::bytea) AND (_fld74575_rrref = '\\231\\230\\274W?@8\\327E\\353\\354\\004d\\357\\033\\\\'::bytea) AND (_fld74576_type = '\\010'::bytea) AND (_fld74576_rtref = '\\000\\000\\202\\355'::bytea) AND (_fld74576_rrref = '\\231\\230\\274W?@8\\327E\\353\\354\\004d\\357\\033\\\\'::bytea) AND (_fld74577_type = '\\010'::bytea) AND (_fld74577_rtref = '\\000\\000\\202\\355'::bytea))
  • Filter: ((NOT _fld74573) AND (_fld74577_rrref = '\\231\\230\\274W?@8\\327E\\353\\354\\004d\\357\\033\\\\'::bytea) AND (_fld74578_type = '\\010'::bytea) AND (_fld74578_rtref = '\\000\\000\\202\\355'::bytea) AND (_fld74578_rrref = '\\231\\230\\274W?@8\\327E\\353\\354\\004d\\357\\033\\\\'::bytea))
Planning time : 279.081 ms
Execution time : 122,955.844 ms