explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yv53

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 2,104.523 ↓ 0.0 0 1

Limit (cost=164,461.31..164,461.32 rows=1 width=68) (actual time=2,104.523..2,104.523 rows=0 loops=1)

  • Output: id, token, phone, name, email, comment, bin_id, paymethod, utm, host_id, order_type, custom_bin_id_id, user_currency_id
2. 0.000 2,104.521 ↓ 0.0 0 1

Sort (cost=164,461.31..164,461.32 rows=1 width=68) (actual time=2,104.521..2,104.521 rows=0 loops=1)

  • Output: id, token, phone, name, email, comment, bin_id, paymethod, utm, host_id, order_type, custom_bin_id_id, user_currency_id
  • Sort Key: engine_siteorder.id
  • Sort Method: quicksort Memory: 25kB
3. 0.511 2,104.639 ↓ 0.0 0 1

Gather (cost=1,000.00..164,461.30 rows=1 width=68) (actual time=2,104.514..2,104.639 rows=0 loops=1)

  • Output: id, token, phone, name, email, comment, bin_id, paymethod, utm, host_id, order_type, custom_bin_id_id, user_currency_id
  • Workers Planned: 4
  • Workers Launched: 0
4. 2,104.128 2,104.128 ↓ 0.0 0 1

Parallel Seq Scan on public.engine_siteorder (cost=0.00..163,461.20 rows=1 width=68) (actual time=2,104.128..2,104.128 rows=0 loops=1)

  • Output: id, token, phone, name, email, comment, bin_id, paymethod, utm, host_id, order_type, custom_bin_id_id, user_currency_id
  • Filter: ((engine_siteorder.token IS NULL) AND (engine_siteorder.bin_id = 0))
  • Rows Removed by Filter: 11,804,001
Planning time : 0.115 ms
Execution time : 2,104.680 ms