explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SZoG

Settings
# exclusive inclusive rows x rows loops node
1. 0.228 147,227.613 ↑ 1.0 200 1

Limit (cost=0.99..2,691.62 rows=200 width=663) (actual time=10,139.452..147,227.613 rows=200 loops=1)

2. 1.238 147,227.385 ↑ 160.2 200 1

Nested Loop (cost=0.99..431,093.07 rows=32,044 width=663) (actual time=10,139.447..147,227.385 rows=200 loops=1)

3. 1.286 147,137.747 ↑ 160.2 200 1

Nested Loop Left Join (cost=0.70..421,107.22 rows=32,044 width=585) (actual time=10,138.440..147,137.747 rows=200 loops=1)

  • Join Filter: (dicts_product.okpd2_id = dicts_okpd2.id)
  • Rows Removed by Join Filter: 3600
4. 2.076 147,135.261 ↑ 160.2 200 1

Nested Loop Left Join (cost=0.70..412,454.11 rows=32,044 width=393) (actual time=10,137.906..147,135.261 rows=200 loops=1)

5. 147,132.785 147,132.785 ↑ 160.2 200 1

Index Scan using dicts_product_name on dicts_product (cost=0.56..407,154.73 rows=32,044 width=219) (actual time=10,137.870..147,132.785 rows=200 loops=1)

  • Filter: ((ent_id IS NULL) AND (begin <= '2020-01-01'::date) AND (("end" >= '2020-01-01'::date) OR ("end" IS NULL)))
  • Rows Removed by Filter: 74525
6. 0.400 0.400 ↓ 0.0 0 200

Index Scan using dicts_okpd_pkey on dicts_okpd (cost=0.15..0.17 rows=1 width=174) (actual time=0.002..0.002 rows=0 loops=200)

  • Index Cond: (dicts_product.okpd_id = id)
7. 0.696 1.200 ↑ 1.0 18 200

Materialize (cost=0.00..1.27 rows=18 width=192) (actual time=0.004..0.006 rows=18 loops=200)

8. 0.504 0.504 ↑ 1.0 18 1

Seq Scan on dicts_okpd2 (cost=0.00..1.18 rows=18 width=192) (actual time=0.503..0.504 rows=18 loops=1)

9. 88.400 88.400 ↑ 1.0 1 200

Index Scan using dicts_unit_pkey on dicts_unit (cost=0.29..0.31 rows=1 width=78) (actual time=0.442..0.442 rows=1 loops=200)

  • Index Cond: (id = dicts_product.unit_id)
Planning time : 162.268 ms
Execution time : 147,228.064 ms