explain.depesz.com

PostgreSQL's explain analyze made readable

Result: a7rv

Settings
# exclusive inclusive rows x rows loops node
1. 2.440 166,316.595 ↑ 5,570.8 761 1

Group (cost=2,147,978.37..5,575,009.48 rows=4,239,343 width=124) (actual time=154,235.555..166,316.595 rows=761 loops=1)

  • Group Key: history_1.c_createddate, history_1.c_actiontype, history_1.c_tablegroupid
  • Buffers: shared hit=75716 read=28676, temp read=126650 written=127092
2. 6,794.532 166,314.155 ↑ 20,267.8 1,255 1

Gather Merge (cost=2,147,978.37..5,310,050.54 rows=25,436,058 width=28) (actual time=154,235.528..166,314.155 rows=1,255 loops=1)

  • Workers Planned: 6
  • Workers Launched: 6
  • Buffers: shared hit=380107 read=337677, temp read=859796 written=862823
3. 4,534.996 159,519.623 ↑ 23,683.5 179 7 / 7

Group (cost=2,146,978.27..2,217,633.99 rows=4,239,343 width=28) (actual time=150,127.55..159,519.623 rows=179 loops=7)

  • Group Key: history_1.c_createddate, history_1.c_actiontype, history_1.c_tablegroupid
  • Buffers: shared hit=380107 read=337677, temp read=859796 written=862823
4. 139,009.845 154,984.627 ↑ 1.2 6,099,203 7 / 7

Sort (cost=2,146,978.27..2,164,642.2 rows=7,065,572 width=28) (actual time=150,127.53..154,984.627 rows=6,099,203 loops=7)

  • Sort Key: history_1.c_createddate DESC, history_1.c_actiontype, history_1.c_tablegroupid
  • Sort Method: external merge Disk: 231752kB
  • Buffers: shared hit=380107 read=337677, temp read=859796 written=862823
5. 9,124.314 15,974.782 ↑ 1.2 6,099,203 7 / 7

Append (cost=0..947,125.56 rows=7,065,572 width=28) (actual time=0.05..15,974.782 rows=6,099,203 loops=7)

  • Buffers: shared hit=379831 read=337677
6. 4,537.114 4,537.114 ↑ 1.2 4,050,813 7 / 7

Seq Scan on t_e20so1_document_boolean_history_tags history_1 (cost=0..605,027.13 rows=4,675,880 width=28) (actual time=0.077..4,537.114 rows=4,050,813 loops=7)

  • Filter: ((history_1.c_tablegroupid = ANY ('{e6c4fb96-c388-11e7-a223-5792b0fed8c4,c0b2f85c-bc93-466b-a54d-b1330440db98}'::uuid[])) AND ((history_1.c_canrestore = 1) OR (history_1.c_modifiedby IS NOT NULL)) AND (history_1.c_subactiontype <> 1) AND (history_1.c_actionfrom <> 11) AND (history_1.c_actiontype = ANY ('{7,8,11,12}'::integer[])))
  • Buffers: shared hit=144756 read=337677
7. 2,313.354 2,313.354 ↓ 1.3 3,584,681 4 / 7

Seq Scan on t_e20so1_document_boolean_history_issues history (cost=0..306,770.57 rows=2,867,631 width=28) (actual time=0.033..4,048.369 rows=3,584,681 loops=4)

  • Filter: ((history.c_tablegroupid = ANY ('{e6c4fb96-c388-11e7-a223-5792b0fed8c4,c0b2f85c-bc93-466b-a54d-b1330440db98}'::uuid[])) AND ((history.c_canrestore = 1) OR (history.c_modifiedby IS NOT NULL)) AND (history.c_subactiontype <> 1) AND (history.c_actionfrom <> 11) AND (history.c_actiontype = ANY ('{7,8,11,12}'::integer[])))
  • Buffers: shared hit=235075
Planning time : 1.162 ms
Execution time : 166,350.945 ms