explain.depesz.com

PostgreSQL's explain analyze made readable

Result: g4sV

Settings
# exclusive inclusive rows x rows loops node
1. 102.996 103.125 ↓ 0.0 0 1

Custom Scan (Citus Adaptive) (cost=0.00..0.00 rows=0 width=0) (actual time=103.125..103.125 rows=0 loops=1)

  • Task Count: 1
  • Tasks Shown: All
  • -> Task
  • Node: host=ec2-18-209-143-100.compute-1.amazonaws.com port=5432 dbname=citus
2. 0.001 0.129 ↓ 0.0 0 1

Limit (cost=2,009.56..2,009.57 rows=2 width=348) (actual time=0.129..0.129 rows=0 loops=1)

3. 0.011 0.128 ↓ 0.0 0 1

Sort (cost=2,009.56..2,009.57 rows=4 width=348) (actual time=0.128..0.128 rows=0 loops=1)

  • Sort Key: (1)
  • Sort Method: quicksort Memory: 25kB
4. 0.001 0.117 ↓ 0.0 0 1

Append (cost=0.56..2,009.52 rows=4 width=348) (actual time=0.117..0.117 rows=0 loops=1)

5. 0.037 0.037 ↓ 0.0 0 1

Index Scan using raterow_test2_123034 on raterow_123034 rr (cost=0.56..502.39 rows=1 width=348) (actual time=0.037..0.037 rows=0 loops=1)

  • Index Cond: (((rate_set_id)::text = ANY ('{b2b9dfa6-90bb-4900-9c52-579a474ba3ef,fa435476-e6f4-499c-8489-3529c8b010cb}'::text[])) AND ((rate_table_name)::text = 'FREIGHT'::text) AND ((fields ->> 'service_name'::text) = 'POST'::text) AND ((fields ->> 'pkg_type'::text) = 'PCK'::text))
  • Filter: (((carrier_code)::text = 'UPSN'::text) AND ((client_code)::text = 'GAP2'::text) AND ((fields ->> 'effective_from'::text) <= '2019-06-04'::text) AND ((fields ->> 'effective_to'::text) >= '2019-06-04'::text) AND ((fields ->> 'cwt_ind'::text) = 'N'::text) AND ((fields ->> 'dest_state'::text) = 'US48'::text) AND ((fields ->> 'origin_state'::text) = 'US48'::text) AND ((fields ->> 'resi_comm'::text) = 'COMM'::text) AND (((fields -> 'zone_code'::text) = '8'::jsonb) OR ((fields ->> 'zone_code'::text) = '8'::text)) AND ((((fields -> 'weight_from'::text) <= '0.500000'::jsonb) AND ((fields -> 'weight_to'::text) >= '0.500000'::jsonb) AND ((fields -> 'weight_from'::text) <> (fields -> 'weight_to'::text))) OR (((fields -> 'weight_from'::text) = '0.500000'::jsonb) AND ((fields -> 'weight_from'::text) = (fields -> 'weight_to'::text)))))
6. 0.025 0.025 ↓ 0.0 0 1

Index Scan using raterow_test2_123034 on raterow_123034 rr_1 (cost=0.56..502.36 rows=1 width=348) (actual time=0.025..0.025 rows=0 loops=1)

  • Index Cond: (((rate_set_id)::text = ANY ('{b2b9dfa6-90bb-4900-9c52-579a474ba3ef,fa435476-e6f4-499c-8489-3529c8b010cb}'::text[])) AND ((rate_table_name)::text = 'FREIGHT'::text) AND ((fields ->> 'service_name'::text) = 'POST'::text) AND ((fields ->> 'pkg_type'::text) = 'PCK'::text))
  • Filter: (((carrier_code)::text = 'UPSN'::text) AND ((client_code)::text = 'GAP2'::text) AND ((fields ->> 'effective_from'::text) <= '2019-06-04'::text) AND ((fields ->> 'effective_to'::text) >= '2019-06-04'::text) AND ((fields ->> 'cwt_ind'::text) = 'N'::text) AND ((fields ->> 'dest_state'::text) = 'US48'::text) AND ((fields ->> 'origin_state'::text) = 'US48'::text) AND (((fields -> 'zone_code'::text) = '8'::jsonb) OR ((fields ->> 'zone_code'::text) = '8'::text)) AND ((((fields -> 'weight_from'::text) <= '0.500000'::jsonb) AND ((fields -> 'weight_to'::text) >= '0.500000'::jsonb) AND ((fields -> 'weight_from'::text) <> (fields -> 'weight_to'::text))) OR (((fields -> 'weight_from'::text) = '0.500000'::jsonb) AND ((fields -> 'weight_from'::text) = (fields -> 'weight_to'::text)))))
7. 0.028 0.028 ↓ 0.0 0 1

Index Scan using raterow_test2_123034 on raterow_123034 rr_2 (cost=0.56..502.36 rows=1 width=348) (actual time=0.028..0.028 rows=0 loops=1)

  • Index Cond: (((rate_set_id)::text = ANY ('{b2b9dfa6-90bb-4900-9c52-579a474ba3ef,fa435476-e6f4-499c-8489-3529c8b010cb}'::text[])) AND ((rate_table_name)::text = 'FREIGHT'::text) AND ((fields ->> 'service_name'::text) = 'POST'::text) AND ((fields ->> 'pkg_type'::text) = 'PCK'::text))
  • Filter: (((carrier_code)::text = 'UPSN'::text) AND ((client_code)::text = 'GAP2'::text) AND ((fields ->> 'effective_from'::text) <= '2019-06-04'::text) AND ((fields ->> 'effective_to'::text) >= '2019-06-04'::text) AND ((fields ->> 'cwt_ind'::text) = 'N'::text) AND ((fields ->> 'dest_country'::text) = 'USA'::text) AND ((fields ->> 'origin_country'::text) = 'USA'::text) AND (((fields -> 'zone_code'::text) = '8'::jsonb) OR ((fields ->> 'zone_code'::text) = '8'::text)) AND ((((fields -> 'weight_from'::text) <= '0.500000'::jsonb) AND ((fields -> 'weight_to'::text) >= '0.500000'::jsonb) AND ((fields -> 'weight_from'::text) <> (fields -> 'weight_to'::text))) OR (((fields -> 'weight_from'::text) = '0.500000'::jsonb) AND ((fields -> 'weight_from'::text) = (fields -> 'weight_to'::text)))))
8. 0.026 0.026 ↓ 0.0 0 1

Index Scan using raterow_test2_123034 on raterow_123034 rr_3 (cost=0.56..502.36 rows=1 width=348) (actual time=0.026..0.026 rows=0 loops=1)

  • Index Cond: (((rate_set_id)::text = ANY ('{b2b9dfa6-90bb-4900-9c52-579a474ba3ef,fa435476-e6f4-499c-8489-3529c8b010cb}'::text[])) AND ((rate_table_name)::text = 'FREIGHT'::text) AND ((fields ->> 'service_name'::text) = 'POST'::text) AND ((fields ->> 'pkg_type'::text) = 'PCK'::text))
  • Filter: (((carrier_code)::text = 'UPSN'::text) AND ((client_code)::text = 'GAP2'::text) AND ((fields ->> 'effective_from'::text) <= '2019-06-04'::text) AND ((fields ->> 'effective_to'::text) >= '2019-06-04'::text) AND ((fields ->> 'cwt_ind'::text) = 'N'::text) AND ((fields ->> 'dest_country'::text) = 'ALL'::text) AND ((fields ->> 'origin_country'::text) = 'USA'::text) AND (((fields -> 'zone_code'::text) = '8'::jsonb) OR ((fields ->> 'zone_code'::text) = '8'::text)) AND ((((fields -> 'weight_from'::text) <= '0.500000'::jsonb) AND ((fields -> 'weight_to'::text) >= '0.500000'::jsonb) AND ((fields -> 'weight_from'::text) <> (fields -> 'weight_to'::text))) OR (((fields -> 'weight_from'::text) = '0.500000'::jsonb) AND ((fields -> 'weight_from'::text) = (fields -> 'weight_to'::text)))))
Planning time : 2.029 ms
Execution time : 0.360 ms