explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MCiG

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 136,753.931 ↓ 0.0 0 1

Limit (cost=3,812,886.50..3,812,886.50 rows=2 width=28) (actual time=136,753.931..136,753.931 rows=0 loops=1)

2. 0.020 136,753.930 ↓ 0.0 0 1

Sort (cost=3,812,886.50..3,812,886.50 rows=2 width=28) (actual time=136,753.930..136,753.930 rows=0 loops=1)

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

GroupAggregate (cost=3,812,886.29..3,812,886.42 rows=2 width=28) (actual time=136,753.910..136,753.910 rows=0 loops=1)

  • Group Key: t1._fld32821rref
4. 0.002 136,753.908 ↓ 0.0 0 1

Merge Append (cost=3,812,886.29..3,812,886.39 rows=2 width=28) (actual time=136,753.908..136,753.908 rows=0 loops=1)

  • Sort Key: t1._fld32821rref
5. 0.001 130,470.779 ↓ 0.0 0 1

Limit (cost=1,906,443.14..1,906,443.16 rows=1 width=28) (actual time=130,470.779..130,470.779 rows=0 loops=1)

6. 0.001 130,470.778 ↓ 0.0 0 1

GroupAggregate (cost=1,906,443.14..1,906,443.16 rows=1 width=28) (actual time=130,470.778..130,470.778 rows=0 loops=1)

  • Group Key: t1._fld32821rref
7. 0.000 130,470.777 ↓ 0.0 0 1

Sort (cost=1,906,443.14..1,906,443.15 rows=1 width=28) (actual time=130,470.777..130,470.777 rows=0 loops=1)

  • Sort Key: t1._fld32821rref
  • Sort Method: quicksort Memory: 25kB
8. 106.885 130,470.955 ↓ 0.0 0 1

Gather (cost=8,823.34..1,906,443.08 rows=1 width=28) (actual time=130,470.768..130,470.955 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
9. 738.045 130,364.070 ↓ 0.0 0 3 / 3

Parallel Hash Anti Join (cost=7,823.34..1,905,442.98 rows=1 width=28) (actual time=130,364.070..130,364.070 rows=0 loops=3)

  • Hash Cond: (t1._fld32821rref = t2._fld74574_rrref)
10. 124,607.482 124,607.482 ↑ 1.2 4,668,137 3 / 3

Parallel Seq Scan on _accumrg32819 t1 (cost=0.00..1,759,068.20 rows=5,833,745 width=28) (actual time=60,503.712..124,607.482 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
11. 0.095 5,018.543 ↑ 2.6 8 3 / 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 104kB
12. 5,018.448 5,018.448 ↑ 2.6 8 3 / 3

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

  • Filter: ((NOT _fld74573) AND (_fld74572_type = '\\x08'::bytea) AND (_fld74572_rtref = '\\x00000099'::bytea) AND (_fld74572_rrref = '\\x8cda000c29b4f2a211e3ba42c12a08eb'::bytea) 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) AND (_fld74577_rrref = '\\x9998bc573f4038d745ebec0464ef1b5c'::bytea) AND (_fld74578_type = '\\x08'::bytea) AND (_fld74578_rtref = '\\x000082ed'::bytea) AND (_fld74578_rrref = '\\x9998bc573f4038d745ebec0464ef1b5c'::bytea) AND (_fld1389 = '0'::numeric))
  • Rows Removed by Filter: 53884
13. 0.001 6,283.127 ↓ 0.0 0 1

Limit (cost=1,906,443.14..1,906,443.16 rows=1 width=28) (actual time=6,283.127..6,283.127 rows=0 loops=1)

14. 0.003 6,283.126 ↓ 0.0 0 1

GroupAggregate (cost=1,906,443.14..1,906,443.16 rows=1 width=28) (actual time=6,283.126..6,283.126 rows=0 loops=1)

  • Group Key: t1_1._fld32821rref
15. 0.000 6,283.123 ↓ 0.0 0 1

Sort (cost=1,906,443.14..1,906,443.15 rows=1 width=28) (actual time=6,283.123..6,283.123 rows=0 loops=1)

  • Sort Key: t1_1._fld32821rref
  • Sort Method: quicksort Memory: 25kB
16. 45.405 6,297.772 ↓ 0.0 0 1

Gather (cost=8,823.34..1,906,443.08 rows=1 width=28) (actual time=6,283.102..6,297.772 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
17. 596.194 6,252.367 ↓ 0.0 0 3 / 3

Parallel Hash Anti Join (cost=7,823.34..1,905,442.98 rows=1 width=28) (actual time=6,252.366..6,252.367 rows=0 loops=3)

  • Hash Cond: (t1_1._fld32821rref = t2_1._fld74574_rrref)
18. 5,642.801 5,642.801 ↑ 1.2 4,668,137 3 / 3

Parallel Seq Scan on _accumrg32819 t1_1 (cost=0.00..1,759,068.20 rows=5,833,745 width=28) (actual time=2,310.588..5,642.801 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
19. 0.014 13.372 ↑ 2.6 8 3 / 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 40kB
20. 13.358 13.358 ↑ 1.6 13 2 / 3

Parallel Seq Scan on _inforg74571 t2_1 (cost=0.00..7,823.08 rows=21 width=17) (actual time=12.968..20.037 rows=13 loops=2)

  • Filter: ((NOT _fld74573) AND (_fld74572_type = '\\x08'::bytea) AND (_fld74572_rtref = '\\x00000099'::bytea) AND (_fld74572_rrref = '\\x8cda000c29b4f2a211e3ba42c12a08eb'::bytea) 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) AND (_fld74577_rrref = '\\x9998bc573f4038d745ebec0464ef1b5c'::bytea) AND (_fld74578_type = '\\x08'::bytea) AND (_fld74578_rtref = '\\x000082ed'::bytea) AND (_fld74578_rrref = '\\x9998bc573f4038d745ebec0464ef1b5c'::bytea) AND (_fld1389 = '0'::numeric))
  • Rows Removed by Filter: 80826
Planning time : 469.405 ms
Execution time : 136,774.145 ms