explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hxOE

Settings
# exclusive inclusive rows x rows loops node
1. 57,477.865 98,716.579 ↓ 1.0 42,694,252 1

Append (cost=0..2,338,038.13 rows=42,393,259 width=64) (actual time=0.025..98,716.579 rows=42,694,252 loops=1)

  • Buffers: shared hit=236048 read=481457
2. 13,624.618 13,624.618 ↓ 1.0 14,338,725 1

Seq Scan on t_e20so1_document_boolean_history_issues history (cost=0..557,705.04 rows=14,338,157 width=64) (actual time=0.023..13,624.618 rows=14,338,725 loops=1)

  • 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=235075
3. 27,614.096 27,614.096 ↓ 1.0 28,355,527 1

Seq Scan on t_e20so1_document_boolean_history_tags history_1 (cost=0..1,144,434.2 rows=28,055,102 width=64) (actual time=0.147..27,614.096 rows=28,355,527 loops=1)

  • Filter: (((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=973 read=481457
Planning time : 0.371 ms
Execution time : 127,540.398 ms