explain.depesz.com

PostgreSQL's explain analyze made readable

Result: u3dL

Settings
# exclusive inclusive rows x rows loops node
1. 16.999 1,404.218 ↑ 1.0 1 1

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

2. 45.745 1,387.219 ↓ 1.7 150,134 1

Hash Left Join (cost=2,448.42..212,435.91 rows=87,915 width=0) (actual time=31.885..1,387.219 rows=150,134 loops=1)

  • Hash Cond: ((t.poured_nomenclature_id)::text = btrim(to_char((sonp.id_for_cards)::double precision, '9999999999'::text)))
3. 45.411 1,341.357 ↓ 1.7 150,134 1

Hash Left Join (cost=2,446.90..210,895.88 rows=87,915 width=8) (actual time=31.746..1,341.357 rows=150,134 loops=1)

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

Hash Left Join (cost=2,445.38..209,355.85 rows=87,915 width=16) (actual time=30.184..1,294.422 rows=150,134 loops=1)

  • Hash Cond: ((t.client_id)::text = (c.id)::text)
5. 1,018.469 1,018.469 ↓ 1.7 150,134 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.047..1,018.469 rows=150,134 loops=1)

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

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

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

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

8. 1.504 1.524 ↓ 1.1 26 1

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

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

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

10. 0.101 0.117 ↓ 1.1 26 1

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

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

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

Planning time : 20.764 ms