explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RB2T

Settings
# exclusive inclusive rows x rows loops node
1. 79.001 401,737.622 ↑ 1.0 10 1

Limit (cost=792,466.73..792,476.25 rows=10 width=56) (actual time=401,643.209..401,737.622 rows=10 loops=1)

  • Buffers: shared hit=548 read=235077, temp read=394056 written=431966
2. 0.000 401,658.621 ↑ 21,840.0 10 1

Group (cost=792,466.73..1,000,433.25 rows=218,400 width=56) (actual time=401,643.205..401,658.621 rows=10 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=38 read=40366, temp read=55707 written=74565
3. 6,461.339 401,737.512 ↑ 37,655.2 29 1

Gather Merge (cost=792,466.73..981,323.25 rows=1,092,000 width=56) (actual time=401,643.199..401,737.512 rows=29 loops=1)

  • Workers Planned: 5
  • Workers Launched: 5
  • Buffers: shared hit=548 read=235077, temp read=394056 written=431966
4. 1,293.029 395,276.173 ↑ 10,400.0 21 6 / 6

Group (cost=791,466.66..848,819.28 rows=218,400 width=56) (actual time=391,993.033..395,276.173 rows=21 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=548 read=235077, temp read=394056 written=431966
5. 384,059.321 393,983.144 ↑ 1.8 1,589,662 6 / 6

Sort (cost=791,466.66..798,635.73 rows=2,867,631 width=56) (actual time=391,993.013..393,983.144 rows=1,589,662 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: 149392kB
  • Buffers: shared hit=548 read=235077, temp read=394056 written=431966
6. 3,948.333 9,923.823 ↑ 1.2 2,389,788 6 / 6

Hash Join (cost=35.59..311,662.01 rows=2,867,631 width=56) (actual time=2.061..9,923.823 rows=2,389,788 loops=6)

  • Buffers: shared hit=283 read=235077
7. 5,973.733 5,973.733 ↑ 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.265..5,973.733 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 read=235075
8. 0.677 1.757 ↓ 1.0 739 6 / 6

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

  • Buffers: shared hit=243 read=2
9. 1.080 1.080 ↓ 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.092..1.08 rows=739 loops=6)

  • Heap Fetches: 1020
  • Buffers: shared hit=243 read=2
Planning time : 15.284 ms
Execution time : 401,849.343 ms