explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2UbL

Settings
# exclusive inclusive rows x rows loops node
1. 45.988 48.151 ↑ 230.8 18 1

Gather Merge (cost=26,006.28..26,490.95 rows=4,154 width=1,949) (actual time=44.069..48.151 rows=18 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.192 2.163 ↑ 346.2 6 3

Sort (cost=25,006.26..25,011.45 rows=2,077 width=1,949) (actual time=0.720..0.721 rows=6 loops=3)

  • Sort Key: o.date_time_create
  • Sort Method: quicksort Memory: 32kB
  • Worker 0: Sort Method: quicksort Memory: 25kB
  • Worker 1: Sort Method: quicksort Memory: 25kB
3. 0.699 1.971 ↑ 346.2 6 3

Nested Loop Left Join (cost=158.99..24,891.81 rows=2,077 width=1,949) (actual time=0.289..0.657 rows=6 loops=3)

4. 0.321 1.218 ↑ 344.8 6 3

Nested Loop Left Join (cost=158.56..20,934.54 rows=2,069 width=2,426) (actual time=0.268..0.406 rows=6 loops=3)

5. 0.018 0.843 ↑ 343.7 6 3

Hash Left Join (cost=158.13..17,026.88 rows=2,062 width=2,577) (actual time=0.252..0.281 rows=6 loops=3)

  • Hash Cond: (o.order_additional_status_code = delivery_detail_additional_status.code)
6. 0.012 0.801 ↑ 343.7 6 3

Hash Left Join (cost=155.75..17,019.08 rows=2,062 width=2,061) (actual time=0.239..0.267 rows=6 loops=3)

  • Hash Cond: (o.tariff_type_code = tariff_type.code)
7. 0.012 0.615 ↑ 343.7 6 3

Nested Loop Left Join (cost=129.04..16,986.88 rows=2,062 width=2,028) (actual time=0.179..0.205 rows=6 loops=3)

8. 0.012 0.603 ↑ 343.7 6 3

Nested Loop Left Join (cost=128.48..11,293.48 rows=2,062 width=2,034) (actual time=0.178..0.201 rows=6 loops=3)

9. 0.019 0.591 ↑ 343.7 6 3

Hash Left Join (cost=127.92..5,600.09 rows=2,062 width=2,040) (actual time=0.176..0.197 rows=6 loops=3)

  • Hash Cond: (o.order_status_code = order_status.code)
10. 0.163 0.492 ↑ 343.7 6 3

Parallel Bitmap Heap Scan on "order" o (cost=124.42..5,588.60 rows=2,062 width=1,004) (actual time=0.146..0.164 rows=6 loops=3)

  • Recheck Cond: (((sender_contragent_code)::text = '56090b33d83467dd84bd15ce'::text) AND (date_time_create >= '2019-08-07 00:00:00'::timestamp without time zone) AND (date_time_create <= '2019-09-07 23:59:59'::timestamp without time zone))
  • Filter: (NOT deleted)
  • Heap Blocks: exact=18
11. 0.329 0.329 ↑ 274.9 18 1

Bitmap Index Scan on idx_order_sender_test (cost=0.00..123.18 rows=4,948 width=0) (actual time=0.329..0.329 rows=18 loops=1)

  • Index Cond: (((sender_contragent_code)::text = '56090b33d83467dd84bd15ce'::text) AND (deleted = false) AND (date_time_create >= '2019-08-07 00:00:00'::timestamp without time zone) AND (date_time_create <= '2019-09-07 23:59:59'::timestamp without time zone))
12. 0.010 0.080 ↓ 26.0 26 1

Hash (cost=3.49..3.49 rows=1 width=1,040) (actual time=0.079..0.080 rows=26 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
13. 0.027 0.070 ↓ 26.0 26 1

Nested Loop Left Join (cost=0.14..3.49 rows=1 width=1,040) (actual time=0.019..0.070 rows=26 loops=1)

  • Join Filter: (order_status."groupCode" = order_status_group.code)
  • Rows Removed by Join Filter: 29
14. 0.017 0.017 ↓ 26.0 26 1

Index Scan using "idx-order_status-lang" on order_status (cost=0.14..2.36 rows=1 width=524) (actual time=0.009..0.017 rows=26 loops=1)

  • Index Cond: ((lang)::text = 'rus'::text)
15. 0.026 0.026 ↓ 2.0 2 26

Seq Scan on order_status_group (cost=0.00..1.11 rows=1 width=520) (actual time=0.001..0.001 rows=2 loops=26)

  • Filter: ((lang)::text = 'rus'::text)
  • Rows Removed by Filter: 3
16. 0.000 0.000 ↓ 0.0 0 18

Index Scan using "idx-order_id_ek5" on "order" ro (cost=0.56..2.76 rows=1 width=26) (actual time=0.000..0.000 rows=0 loops=18)

  • Index Cond: (o.reverse_ek5_id = id_ek5)
17. 0.000 0.000 ↓ 0.0 0 18

Index Scan using "idx-order_id_ek5" on "order" so (cost=0.56..2.76 rows=1 width=26) (actual time=0.000..0.000 rows=0 loops=18)

  • Index Cond: (o.straight_ek5_id = id_ek5)
18. 0.039 0.174 ↑ 1.0 282 1

Hash (cost=23.19..23.19 rows=282 width=41) (actual time=0.173..0.174 rows=282 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 36kB
19. 0.112 0.135 ↑ 1.0 282 1

Bitmap Heap Scan on tariff_type (cost=4.66..23.19 rows=282 width=41) (actual time=0.030..0.135 rows=282 loops=1)

  • Recheck Cond: ((lang)::text = 'rus'::text)
  • Heap Blocks: exact=15
20. 0.023 0.023 ↑ 1.0 282 1

Bitmap Index Scan on "idx-tariff_type-lang" (cost=0.00..4.59 rows=282 width=0) (actual time=0.023..0.023 rows=282 loops=1)

  • Index Cond: ((lang)::text = 'rus'::text)
21. 0.008 0.024 ↓ 27.0 27 1

Hash (cost=2.36..2.36 rows=1 width=520) (actual time=0.024..0.024 rows=27 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
22. 0.016 0.016 ↓ 27.0 27 1

Index Scan using "idx-delivery_detail_additional_status-lang" on delivery_detail_additional_status (cost=0.14..2.36 rows=1 width=520) (actual time=0.006..0.016 rows=27 loops=1)

  • Index Cond: ((lang)::text = 'rus'::text)
23. 0.054 0.054 ↑ 1.0 1 18

Index Scan using "idx-city-code-lang" on city rc (cost=0.43..1.90 rows=1 width=29) (actual time=0.003..0.003 rows=1 loops=18)

  • Index Cond: ((code = (((o.receiver)::json #>> '{address,cityCode}'::text[]))::integer) AND ((lang)::text = 'rus'::text))
24. 0.054 0.054 ↑ 1.0 1 18

Index Scan using "idx-city-code-lang" on city sc (cost=0.43..1.90 rows=1 width=29) (actual time=0.003..0.003 rows=1 loops=18)

  • Index Cond: ((code = (((o.sender)::json #>> '{address,cityCode}'::text[]))::integer) AND ((lang)::text = 'rus'::text))
Planning time : 5.067 ms
Execution time : 48.349 ms