explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kvGJ

Settings
# exclusive inclusive rows x rows loops node
1. 179.193 1,262,638.497 ↓ 0.0 0 1

Gather (cost=1,000.00..87,038,443.44 rows=471,399 width=258) (actual time=1,262,489.266..1,262,638.497 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 1,262,459.304 1,262,459.304 ↓ 0.0 0 3 / 3

Parallel Seq Scan on _document2794 t1 (cost=0.00..86,988,928.63 rows=196,416 width=258) (actual time=1,262,459.303..1,262,459.304 rows=0 loops=3)

  • Filter: (CASE WHEN ((_fld2838_type = '\x5c303130'::bytea) AND (_fld2838_rtref = '\x5c3030305c3030305c30303066'::bytea)) THEN _fld2838_rrref ELSE NULL::bytea END = '\x745c3231375c3231325c3337375c3335365c3335325c3030345c3232365c3032315c333532355c333430725c3334305c3033365c323532'::bytea)
  • Rows Removed by Filter: 31,451,189
Planning time : 0.148 ms
Execution time : 1,262,638.652 ms