explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tIET

Settings
# exclusive inclusive rows x rows loops node
1. 0.086 97,815.470 ↑ 1.0 1 1

Aggregate (cost=1,003,163.25..1,003,163.26 rows=1 width=8) (actual time=97,815.469..97,815.47 rows=1 loops=1)

  • Buffers: shared hit=35 read=39072, temp read=71623 written=71894
2. 0.085 97,815.384 ↑ 2,764.6 79 1

Group (cost=792,466.73..1,000,433.25 rows=218,400 width=56) (actual time=91,722.226..97,815.384 rows=79 loops=1)

  • Group Key: history.c_createddate, history.c_actiontype, history.c_modifiedby, history.c_tablegroupid, history.c_createdby, history.c_datastoresid, history.c_canrestore
  • Buffers: shared hit=35 read=39072, temp read=71623 written=71894
3. 3,184.660 97,815.299 ↑ 7,280.0 150 1

Gather Merge (cost=792,466.73..981,323.25 rows=1,092,000 width=56) (actual time=91,722.222..97,815.299 rows=150 loops=1)

  • Workers Planned: 5
  • Workers Launched: 5
  • Buffers: shared hit=546 read=235079, temp read=429654 written=431286
4. 1,946.054 94,630.639 ↑ 8,736.0 25 6 / 6

Group (cost=791,466.66..848,819.28 rows=218,400 width=56) (actual time=89,764.666..94,630.639 rows=25 loops=6)

  • Group Key: history.c_createddate, history.c_actiontype, history.c_modifiedby, history.c_tablegroupid, history.c_createdby, history.c_datastoresid, history.c_canrestore
  • Buffers: shared hit=546 read=235079, temp read=429654 written=431286
5. 84,622.051 92,684.585 ↑ 1.2 2,389,788 6 / 6

Sort (cost=791,466.66..798,635.73 rows=2,867,631 width=56) (actual time=89,764.637..92,684.585 rows=2,389,788 loops=6)

  • Sort Key: history.c_createddate, history.c_actiontype, history.c_modifiedby, history.c_tablegroupid, history.c_createdby, history.c_datastoresid, history.c_canrestore
  • Sort Method: external merge Disk: 144584kB
  • Buffers: shared hit=546 read=235079, temp read=429654 written=431286
6. 4,204.777 8,062.534 ↑ 1.2 2,389,788 6 / 6

Hash Join (cost=35.59..311,662.01 rows=2,867,631 width=56) (actual time=1.88..8,062.534 rows=2,389,788 loops=6)

  • Buffers: shared hit=281 read=235079
7. 3,856.059 3,856.059 ↑ 1.2 2,389,788 6 / 6

Seq Scan on t_e20so1_document_boolean_history_issues history (cost=0..299,601.01 rows=2,867,631 width=64) (actual time=0.147..3,856.059 rows=2,389,788 loops=6)

  • Filter: (((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=1 read=235074
8. 0.724 1.698 ↓ 1.0 739 6 / 6

Hash (cost=26.49..26.49 rows=728 width=8) (actual time=1.696..1.698 rows=739 loops=6)

  • Buffers: shared hit=240 read=5
9. 0.974 0.974 ↓ 1.0 739 6 / 6

Index Only Scan using t_e20so1_document_datastore_13_c_documentid_idx on t_e20so1_document_datastore_13 documents (cost=0.28..26.49 rows=728 width=8) (actual time=0.081..0.974 rows=739 loops=6)

  • Heap Fetches: 1020
  • Buffers: shared hit=240 read=5
Planning time : 5.094 ms
Execution time : 97,840.436 ms