explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ydYTj

Settings
# exclusive inclusive rows x rows loops node
1. 20.054 2,101.701 ↑ 1.0 1 1

Aggregate (cost=212,655.69..212,655.70 rows=1 width=0) (actual time=2,101.701..2,101.701 rows=1 loops=1)

2. 43.365 2,081.647 ↓ 1.7 150,128 1

Hash Left Join (cost=2,448.42..212,435.91 rows=87,915 width=0) (actual time=166.373..2,081.647 rows=150,128 loops=1)

  • Hash Cond: ((t.poured_nomenclature_id)::text = btrim(to_char((sonp.id_for_cards)::double precision, '9999999999'::text)))
3. 43.981 2,038.128 ↓ 1.7 150,128 1

Hash Left Join (cost=2,446.90..210,895.88 rows=87,915 width=8) (actual time=166.194..2,038.128 rows=150,128 loops=1)

  • Hash Cond: ((t.written_off_nomenclature_id)::text = btrim(to_char((sonw.id_for_cards)::double precision, '9999999999'::text)))
4. 269.742 1,993.222 ↓ 1.7 150,128 1

Hash Left Join (cost=2,445.38..209,355.85 rows=87,915 width=16) (actual time=165.240..1,993.222 rows=150,128 loops=1)

  • Hash Cond: ((t.client_id)::text = (c.id)::text)
5. 1,558.383 1,558.383 ↓ 1.7 150,128 1

Index Scan using transactions_new_transaction_date_idx on transactions_new t (cost=0.44..205,052.20 rows=87,915 width=89) (actual time=0.096..1,558.383 rows=150,128 loops=1)

  • Index Cond: ((transaction_date >= '2020-08-02'::date) AND (transaction_date <= '2020-09-02'::date))
6. 14.619 165.097 ↑ 1.0 27,182 1

Hash (cost=2,104.42..2,104.42 rows=27,242 width=13) (actual time=165.097..165.097 rows=27,182 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 1,205kB
7. 150.478 150.478 ↑ 1.0 27,182 1

Seq Scan on customers c (cost=0.00..2,104.42 rows=27,242 width=13) (actual time=7.614..150.478 rows=27,182 loops=1)

8. 0.892 0.925 ↓ 1.1 26 1

Hash (cost=1.23..1.23 rows=23 width=2) (actual time=0.925..0.925 rows=26 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 1kB
9. 0.033 0.033 ↓ 1.1 26 1

Seq Scan on set_of_nomenclature sonw (cost=0.00..1.23 rows=23 width=2) (actual time=0.022..0.033 rows=26 loops=1)

10. 0.140 0.154 ↓ 1.1 26 1

Hash (cost=1.23..1.23 rows=23 width=2) (actual time=0.154..0.154 rows=26 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 1kB
11. 0.014 0.014 ↓ 1.1 26 1

Seq Scan on set_of_nomenclature sonp (cost=0.00..1.23 rows=23 width=2) (actual time=0.006..0.014 rows=26 loops=1)

Planning time : 31.190 ms