explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jmpc

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 16,668.394 ↓ 0.0 0 1

Limit (cost=2,103,028.98..2,103,028.99 rows=2 width=28) (actual time=16,668.394..16,668.394 rows=0 loops=1)

2. 0.005 16,668.394 ↓ 0.0 0 1

Sort (cost=2,103,028.98..2,103,028.99 rows=2 width=28) (actual time=16,668.394..16,668.394 rows=0 loops=1)

  • Sort Key: (max((max(t1._period)))) DESC, t1._fld32821rref
  • Sort Method: quicksort Memory: 25kB
3. 0.002 16,668.389 ↓ 0.0 0 1

GroupAggregate (cost=2,102,029.95..2,103,028.91 rows=2 width=28) (actual time=16,668.388..16,668.389 rows=0 loops=1)

  • Group Key: t1._fld32821rref
4. 0.001 16,668.387 ↓ 0.0 0 1

Merge Append (cost=2,102,029.95..2,103,028.88 rows=2 width=28) (actual time=16,668.387..16,668.387 rows=0 loops=1)

  • Sort Key: t1._fld32821rref
5. 0.000 16,581.505 ↓ 0.0 0 1

Limit (cost=1,880,567.77..1,880,567.79 rows=1 width=28) (actual time=16,581.505..16,581.505 rows=0 loops=1)

6. 0.001 16,581.505 ↓ 0.0 0 1

GroupAggregate (cost=1,880,567.77..1,880,567.79 rows=1 width=28) (actual time=16,581.505..16,581.505 rows=0 loops=1)

  • Group Key: t1._fld32821rref
7. 0.000 16,581.504 ↓ 0.0 0 1

Sort (cost=1,880,567.77..1,880,567.78 rows=1 width=28) (actual time=16,581.504..16,581.504 rows=0 loops=1)

  • Sort Key: t1._fld32821rref
  • Sort Method: quicksort Memory: 25kB
8. 57.450 16,581.654 ↓ 0.0 0 1

Gather (cost=8,823.34..1,880,567.71 rows=1 width=28) (actual time=16,581.498..16,581.654 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
9. 1,945.408 16,524.204 ↓ 0.0 0 3 / 3

Parallel Hash Anti Join (cost=7,823.34..1,879,567.61 rows=1 width=28) (actual time=16,524.203..16,524.204 rows=0 loops=3)

  • Hash Cond: (t1._fld32821rref = t2._fld74574_rrref)
10. 14,549.155 14,549.155 ↑ 1.2 4,668,136 3 / 3

Parallel Seq Scan on _accumrg32819 t1 (cost=0.00..1,733,199.55 rows=5,833,462 width=28) (actual time=6,095.154..14,549.155 rows=4,668,136 loops=3)

  • Filter: ((_period >= '2015-01-01 00:00:00'::timestamp without time zone) AND (_period < '2015-12-31 17:05:45'::timestamp without time zone) AND (_fld1389 = '0'::numeric))
  • Rows Removed by Filter: 3609832
11. 0.036 29.641 ↑ 2.6 8 3 / 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 72kB
12. 29.605 29.605 ↑ 1.6 13 2 / 3

Parallel Seq Scan on _inforg74571 t2 (cost=0.00..7,823.08 rows=21 width=17) (actual time=28.673..44.407 rows=13 loops=2)

  • 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: 80826
13. 0.001 86.881 ↓ 0.0 0 1

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

14. 0.000 86.880 ↓ 0.0 0 1

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

  • Group Key: t1_1._fld32821rref
15. 103.913 104.033 ↓ 0.0 0 1

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

  • Workers Planned: 2
  • Workers Launched: 2
16. 0.002 0.120 ↓ 0.0 0 3 / 3

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

  • Merge Cond: (t1_1._fld32821rref = t2_1._fld74574_rrref)
17. 0.065 0.081 ↓ 0.0 0 3 / 3

Sort (cost=221,674.86..221,802.93 rows=51,225 width=28) (actual time=0.081..0.081 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
18. 0.016 0.016 ↓ 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=0.016..0.016 rows=0 loops=3)

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

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

  • Sort Key: t2_1._fld74574_rrref
  • Sort Method: quicksort Memory: 26kB
20. 0.031 0.031 ↑ 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=0.059..0.094 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))