explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EyO

Settings
# exclusive inclusive rows x rows loops node
1. 0.046 0.502 ↓ 5.0 5 1

Sort (cost=21.82..21.83 rows=1 width=827) (actual time=0.501..0.502 rows=5 loops=1)

  • Sort Key: da."DateTime" DESC
  • Sort Method: quicksort Memory: 30kB
2. 0.175 0.456 ↓ 5.0 5 1

Nested Loop (cost=1.88..21.81 rows=1 width=827) (actual time=0.272..0.456 rows=5 loops=1)

3. 0.022 0.239 ↓ 7.0 7 1

Nested Loop (cost=1.61..21.15 rows=1 width=482) (actual time=0.135..0.239 rows=7 loops=1)

4. 0.042 0.161 ↓ 7.0 7 1

Hash Join (cost=1.33..13.52 rows=1 width=350) (actual time=0.109..0.161 rows=7 loops=1)

  • Hash Cond: (work."@Работа" = da."@Работа")
5. 0.076 0.076 ↓ 1.2 13 1

Index Scan using "iРабота-Sale" on "Работа" work (cost=0.14..12.30 rows=11 width=12) (actual time=0.039..0.076 rows=13 loops=1)

6. 0.020 0.043 ↑ 1.0 7 1

Hash (cost=1.10..1.10 rows=7 width=342) (actual time=0.043..0.043 rows=7 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
7. 0.023 0.023 ↑ 1.0 7 1

Seq Scan on "DeliveryAddress" da (cost=0.00..1.10 rows=7 width=342) (actual time=0.016..0.023 rows=7 loops=1)

  • Filter: (("DateTime" >= '2018-01-01 00:00:00'::timestamp without time zone) AND ("DateTime" <= '2020-09-01 23:59:59'::timestamp without time zone))
8. 0.056 0.056 ↑ 1.0 1 7

Index Scan using "pSale" on "Sale" sale (cost=0.28..7.58 rows=1 width=136) (actual time=0.008..0.008 rows=1 loops=7)

  • Index Cond: ("@Sale" = work."Sale")
  • Filter: ("State" <> 5)
9. 0.042 0.042 ↑ 1.0 1 7

Index Scan using "pСклад" on "Склад" wh (cost=0.28..0.47 rows=1 width=4) (actual time=0.006..0.006 rows=1 loops=7)

  • Index Cond: ("@Лицо" = sale."Warehouse")
  • Filter: ("НашаОрганизация" = 25,066,607)
  • Rows Removed by Filter: 0
Planning time : 2.747 ms
Execution time : 0.850 ms