explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fsRU

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

HashAggregate (cost=588,637.63..588,637.64 rows=1 width=9) (actual rows= loops=)

  • Group Key: package.id, package.cod
2.          

Initplan (forHashAggregate)

3. 0.000 0.000 ↓ 0.0

Index Scan using tpl_name_unique_idx on contact (cost=0.14..8.16 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((name)::text = 'lex'::text)
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=17,180.28..588,629.45 rows=4 width=9) (actual rows= loops=)

  • Join Filter: (package.id = task.package_id)
5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=17,179.71..588,514.65 rows=1 width=13) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on package (cost=17,179.28..588,506.19 rows=1 width=9) (actual rows= loops=)

  • Recheck Cond: ((status)::text = 'waiting_for_pickup'::text)
  • Filter: ((rounded_cod IS NULL) AND (cod > 0.0))
7. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on package_status_idx (cost=0.00..17,179.28 rows=652,629 width=0) (actual rows= loops=)

  • Index Cond: ((status)::text = 'waiting_for_pickup'::text)
8. 0.000 0.000 ↓ 0.0

Index Scan using uniq_b1e5ed5bf44cabff on logistics_request (cost=0.43..8.45 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (package_id = package.id)
  • Filter: (delivery_tpl_id = $0)
9. 0.000 0.000 ↓ 0.0

Index Scan using idx_527edb25f44cabff on task (cost=0.57..113.70 rows=88 width=4) (actual rows= loops=)

  • Index Cond: (package_id = logistics_request.package_id)
  • Filter: (direction = 'to_customer'::text)