explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ilra

Settings
# exclusive inclusive rows x rows loops node
1. 0.658 516,093.650 ↑ 1.0 1 1

Aggregate (cost=11,340,599.99..11,340,600 rows=1 width=8) (actual time=516,093.648..516,093.65 rows=1 loops=1)

  • Buffers: shared hit=53620 read=44338, temp read=207597 written=208257
2. 1.298 516,092.992 ↑ 5,570.8 761 1

Group (cost=7,236,687.08..11,287,608.2 rows=4,239,343 width=56) (actual time=503,388.334..516,092.992 rows=761 loops=1)

  • Group Key: history_1.c_createddate, history_1.c_actiontype, history_1.c_modifiedby, history_1.c_tablegroupid, history_1.c_createdby, history_1.c_datastoresid, history_1.c_canrestore
  • Buffers: shared hit=53620 read=44338, temp read=207597 written=208257
3. 21,567.804 516,091.694 ↑ 21,501.3 1,183 1

Gather Merge (cost=7,236,687.08..10,842,477.19 rows=25,436,058 width=56) (actual time=503,388.325..516,091.694 rows=1,183 loops=1)

  • Workers Planned: 6
  • Workers Launched: 6
  • Buffers: shared hit=225557 read=492207, temp read=1527735 written=1532594
4. 4,930.568 494,523.890 ↑ 25,084.9 169 7 / 7

Group (cost=7,235,686.98..7,750,060.64 rows=4,239,343 width=56) (actual time=482,462.778..494,523.89 rows=169 loops=7)

  • Group Key: history_1.c_createddate, history_1.c_actiontype, history_1.c_modifiedby, history_1.c_tablegroupid, history_1.c_createdby, history_1.c_datastoresid, history_1.c_canrestore
  • Buffers: shared hit=225557 read=492207, temp read=1527735 written=1532594
5. 462,148.752 489,593.322 ↑ 4.2 6,099,203 7 / 7

Sort (cost=7,235,686.98..7,299,983.69 rows=25,718,683 width=56) (actual time=482,462.761..489,593.322 rows=6,099,203 loops=7)

  • Sort Key: history_1.c_createddate DESC, history_1.c_actiontype, history_1.c_modifiedby, history_1.c_tablegroupid, history_1.c_createdby, history_1.c_datastoresid, history_1.c_canrestore
  • Sort Method: external merge Disk: 352032kB
  • Buffers: shared hit=225557 read=492207, temp read=1527735 written=1532594
6. 10,316.795 27,444.570 ↑ 4.2 6,099,203 7 / 7

Hash Join (cost=33.95..1,495,801.17 rows=25,718,683 width=56) (actual time=0.482..27,444.57 rows=6,099,203 loops=7)

  • Buffers: shared hit=225389 read=492207
7. 9,627.194 17,127.433 ↑ 1.2 6,099,203 7 / 7

Append (cost=0..947,125.56 rows=7,065,572 width=64) (actual time=0.069..17,127.433 rows=6,099,203 loops=7)

  • Buffers: shared hit=225301 read=492207
8. 4,976.706 4,976.706 ↑ 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=64) (actual time=0.159..4,976.706 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=880 read=481553
9. 2,523.533 2,523.533 ↓ 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=64) (actual time=0.058..4,416.182 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=224421 read=10654
10. 0.106 0.342 ↑ 4.1 104 7 / 7

Hash (cost=28.6..28.6 rows=428 width=8) (actual time=0.34..0.342 rows=104 loops=7)

  • Buffers: shared hit=40
11. 0.142 0.236 ↓ 1.7 727 1 / 7

Append (cost=0.28..28.6 rows=428 width=8) (actual time=0.032..1.654 rows=727 loops=1)

  • Buffers: shared hit=40
12. 0.095 0.095 ↓ 1.7 727 1 / 7

Index Only Scan using t_e20so1_document_datastore_13_pkey on t_e20so1_document_datastore_13 documents (cost=0.28..26.46 rows=428 width=8) (actual time=0.03..0.662 rows=727 loops=1)

  • Index Cond: (documents.c_datastoresid = 13)
  • Heap Fetches: 158
  • Buffers: shared hit=40
Planning time : 20.103 ms
Execution time : 516,146.508 ms