explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iIl9

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 124,144.914 ↓ 1.1 25 1

Limit (cost=2,153,494.95..2,153,495.01 rows=22 width=28) (actual time=124,144.913..124,144.914 rows=25 loops=1)

2. 0.022 124,144.913 ↓ 1.1 25 1

Sort (cost=2,153,494.95..2,153,495.01 rows=22 width=28) (actual time=124,144.912..124,144.913 rows=25 loops=1)

  • Sort Key: (max((max(t1._period)))) DESC, t1._fld32821rref
  • Sort Method: quicksort Memory: 26kB
3. 0.010 124,144.891 ↓ 1.1 25 1

GroupAggregate (cost=2,152,488.58..2,153,493.74 rows=22 width=28) (actual time=124,144.865..124,144.891 rows=25 loops=1)

  • Group Key: t1._fld32821rref
4. 0.002 124,144.881 ↓ 1.1 25 1

Merge Append (cost=2,152,488.58..2,153,493.41 rows=22 width=28) (actual time=124,144.856..124,144.881 rows=25 loops=1)

  • Sort Key: t1._fld32821rref
5. 0.002 124,080.305 ↓ 1.2 25 1

Limit (cost=1,931,026.40..1,931,031.72 rows=21 width=28) (actual time=124,080.282..124,080.305 rows=25 loops=1)

6. 0.000 124,080.303 ↓ 1.2 25 1

Finalize GroupAggregate (cost=1,931,026.40..1,931,031.72 rows=21 width=28) (actual time=124,080.281..124,080.303 rows=25 loops=1)

  • Group Key: t1._fld32821rref
7. 122.834 124,087.751 ↓ 1.7 73 1

Gather Merge (cost=1,931,026.40..1,931,031.30 rows=42 width=28) (actual time=124,080.276..124,087.751 rows=73 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
8. 0.047 123,964.917 ↓ 1.1 24 3 / 3

Sort (cost=1,930,026.38..1,930,026.43 rows=21 width=28) (actual time=123,964.915..123,964.917 rows=24 loops=3)

  • Sort Key: t1._fld32821rref
  • Sort Method: quicksort Memory: 26kB
  • Worker 0: Sort Method: quicksort Memory: 26kB
  • Worker 1: Sort Method: quicksort Memory: 26kB
9. 613.992 123,964.870 ↓ 1.1 24 3 / 3

Partial HashAggregate (cost=1,930,025.14..1,930,025.35 rows=21 width=28) (actual time=123,964.867..123,964.870 rows=24 loops=3)

  • Group Key: t1._fld32821rref
10. 1,812.642 123,350.878 ↑ 1.2 3,609,831 3 / 3

Parallel Hash Anti Join (cost=7,823.34..1,907,746.83 rows=4,455,663 width=28) (actual time=453.222..123,350.878 rows=3,609,831 loops=3)

  • Hash Cond: (t1._fld32821rref = t2._fld74574_rrref)
  • Join Filter: ((t1._period >= '2015-01-01 00:00:00'::timestamp without time zone) AND (t1._period <= '2015-12-31 17:05:45'::timestamp without time zone))
  • Rows Removed by Join Filter: 3609831
11. 121,109.495 121,109.495 ↑ 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=24.429..121,109.495 rows=8,277,968 loops=3)

  • Filter: (_fld1389 = '0'::numeric)
12. 0.065 428.741 ↑ 2.6 8 3 / 3

Parallel Hash (cost=7,823.08..7,823.08 rows=21 width=17) (actual time=428.741..428.741 rows=8 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 104kB
13. 428.676 428.676 ↑ 2.6 8 3 / 3

Parallel Seq Scan on _inforg74571 t2 (cost=0.00..7,823.08 rows=21 width=17) (actual time=360.821..428.676 rows=8 loops=3)

  • Filter: ((NOT _fld74573) 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 (_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) 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) AND (_fld1389 = '0'::numeric))
  • Rows Removed by Filter: 53884
14. 0.001 64.574 ↓ 0.0 0 1

Limit (cost=221,462.17..222,461.02 rows=1 width=28) (actual time=64.574..64.574 rows=0 loops=1)

15. 0.000 64.573 ↓ 0.0 0 1

GroupAggregate (cost=221,462.17..222,461.02 rows=1 width=28) (actual time=64.573..64.573 rows=0 loops=1)

  • Group Key: t1_1._fld32821rref
16. 42.624 64.600 ↓ 0.0 0 1

Gather Merge (cost=221,462.17..222,461.00 rows=1 width=28) (actual time=64.571..64.600 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
17. 0.002 21.976 ↓ 0.0 0 3 / 3

Merge Anti Join (cost=220,462.15..221,460.86 rows=1 width=28) (actual time=21.976..21.976 rows=0 loops=3)

  • Merge Cond: (t1_1._fld32821rref = t2_1._fld74574_rrref)
18. 0.050 13.694 ↓ 0.0 0 3 / 3

Sort (cost=221,674.86..221,802.93 rows=51,225 width=28) (actual time=13.694..13.694 rows=0 loops=3)

  • Sort Key: t1_1._fld32821rref
  • Sort Method: quicksort Memory: 25kB
  • Worker 0: Sort Method: quicksort Memory: 25kB
  • Worker 1: Sort Method: quicksort Memory: 25kB
19. 13.644 13.644 ↓ 0.0 0 3 / 3

Parallel Index Scan using _accumrg32819_1 on _accumrg32819 t1_1 (cost=0.56..217,667.90 rows=51,225 width=28) (actual time=13.644..13.644 rows=0 loops=3)

  • Index Cond: ((_fld1389 = '0'::numeric) AND (_period = '2015-12-31 17:05:45'::timestamp without time zone))
20. 0.006 8.280 ↑ 10.0 5 1 / 3

Sort (cost=294.35..294.47 rows=50 width=17) (actual time=24.840..24.841 rows=5 loops=1)

  • Sort Key: t2_1._fld74574_rrref
  • Sort Method: quicksort Memory: 26kB
21. 8.274 8.274 ↑ 2.0 25 1 / 3

Index Scan using _inforg74571_1 on _inforg74571 t2_1 (cost=0.55..292.94 rows=50 width=17) (actual time=24.785..24.822 rows=25 loops=1)

  • 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))