explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MrS2

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

Hash Left Join (cost=4,495.81..5,450,400.25 rows=25,071 width=59) (actual rows= loops=)

  • Hash Cond: ((main.tenderer_identifier_id)::text = (owner.tenderer_identifier_id)::text)
  • Filter: ((owner.tenderer_identifier_id IS NULL) OR ((SubPlan 2) <> '{}'::text[]))
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4,472.09..4,885.00 rows=25,197 width=9) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

HashAggregate (cost=4,469.11..4,469.16 rows=5 width=9) (actual rows= loops=)

  • Group Key: (auction_tenderer.tenderer_identifier_id)::text
4. 0.000 0.000 ↓ 0.0

Seq Scan on auction_tenderer (cost=0.00..4,468.74 rows=148 width=9) (actual rows= loops=)

  • Filter: ((tenderer ->> 'owner'::text) = 'ubiz.ua'::text)
5. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on auction_tenderer main (cost=2.98..82.84 rows=33 width=9) (actual rows= loops=)

  • Recheck Cond: ((tenderer_identifier_id)::text = (auction_tenderer.tenderer_identifier_id)::text)
6. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "idx-auction_tenderer-tenderer_identifier_id" (cost=0.00..2.97 rows=33 width=0) (actual rows= loops=)

  • Index Cond: ((tenderer_identifier_id)::text = (auction_tenderer.tenderer_identifier_id)::text)
7. 0.000 0.000 ↓ 0.0

Hash (cost=16.10..16.10 rows=610 width=50) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on auction_tenderer_owner owner (cost=0.00..16.10 rows=610 width=50) (actual rows= loops=)

9.          

SubPlan (forHash Left Join)

10. 0.000 0.000 ↓ 0.0

Sort (cost=128.99..129.07 rows=33 width=746) (actual rows= loops=)

  • Sort Key: ((auction_tenderer_1.bid_created_at)::date)
11. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on auction_tenderer auction_tenderer_1 (cost=4.54..128.16 rows=33 width=746) (actual rows= loops=)

  • Recheck Cond: ((tenderer_identifier_id)::text = (main.tenderer_identifier_id)::text)
12. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "idx-auction_tenderer-tenderer_identifier_id" (cost=0.00..4.53 rows=33 width=0) (actual rows= loops=)

  • Index Cond: ((tenderer_identifier_id)::text = (main.tenderer_identifier_id)::text)
13. 0.000 0.000 ↓ 0.0

Sort (cost=128.99..129.07 rows=33 width=746) (actual rows= loops=)

  • Sort Key: ((auction_tenderer_2.bid_created_at)::date)
14. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on auction_tenderer auction_tenderer_2 (cost=4.54..128.16 rows=33 width=746) (actual rows= loops=)

  • Recheck Cond: ((tenderer_identifier_id)::text = (main.tenderer_identifier_id)::text)
15. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "idx-auction_tenderer-tenderer_identifier_id" (cost=0.00..4.53 rows=33 width=0) (actual rows= loops=)

  • Index Cond: ((tenderer_identifier_id)::text = (main.tenderer_identifier_id)::text)