explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kI6WG

Settings
# exclusive inclusive rows x rows loops node
1. 172.078 172.184 ↓ 0.0 0 1

Custom Scan (Citus Adaptive) (cost=0.00..0.00 rows=0 width=0) (actual time=172.184..172.184 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.106 ↓ 0.0 0 1

Limit (cost=135.50..135.51 rows=2 width=348) (actual time=0.106..0.106 rows=0 loops=1)

3. 0.008 0.105 ↓ 0.0 0 1

Sort (cost=135.50..135.51 rows=4 width=348) (actual time=0.105..0.105 rows=0 loops=1)

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

Append (cost=0.56..135.46 rows=4 width=348) (actual time=0.097..0.097 rows=0 loops=1)

5. 0.027 0.027 ↓ 0.0 0 1

Index Scan using raterow_test2_123034 on raterow_123034 rr (cost=0.56..22.76 rows=1 width=348) (actual time=0.027..0.027 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 = 'FUEL'::text) AND ((fields ->> 'service_name'::text) = 'POST'::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 -> 'avg_fuel_price_from'::text) <= '3.136'::jsonb) AND ((fields -> 'avg_fuel_price_to'::text) >= '3.136'::jsonb) AND ((fields -> 'avg_fuel_price_from'::text) <> (fields -> 'avg_fuel_price_to'::text))) OR (((fields -> 'avg_fuel_price_from'::text) = '3.136'::jsonb) AND ((fields -> 'avg_fuel_price_from'::text) = (fields -> 'avg_fuel_price_to'::text)))))
6. 0.026 0.026 ↓ 0.0 0 1

Index Scan using raterow_test_123034 on raterow_123034 rr_1 (cost=0.69..27.27 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 = 'FUEL'::text) AND ((fields ->> 'service_name'::text) = 'ALL'::text) AND ((fields ->> 'origin_country'::text) = 'USA'::text) AND ((fields ->> 'dest_country'::text) = 'USA'::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 -> 'avg_fuel_price_from'::text) <= '3.136'::jsonb) AND ((fields -> 'avg_fuel_price_to'::text) >= '3.136'::jsonb) AND ((fields -> 'avg_fuel_price_from'::text) <> (fields -> 'avg_fuel_price_to'::text))) OR (((fields -> 'avg_fuel_price_from'::text) = '3.136'::jsonb) AND ((fields -> 'avg_fuel_price_from'::text) = (fields -> 'avg_fuel_price_to'::text)))))
7. 0.000 0.022 ↓ 0.0 0 1

Bitmap Heap Scan on raterow_123034 rr_2 (cost=40.62..42.69 rows=1 width=348) (actual time=0.022..0.022 rows=0 loops=1)

  • Recheck Cond: ((((rate_set_id)::text = ANY ('{b2b9dfa6-90bb-4900-9c52-579a474ba3ef,fa435476-e6f4-499c-8489-3529c8b010cb}'::text[])) AND ((rate_table_name)::text = 'FUEL'::text) AND ((fields -> 'avg_fuel_price_from'::text) <= '3.136'::jsonb) AND ((fields -> 'avg_fuel_price_to'::text) >= '3.136'::jsonb) AND ((fields ->> 'service_name'::text) = 'ALL'::text)) OR (((rate_set_id)::text = ANY ('{b2b9dfa6-90bb-4900-9c52-579a474ba3ef,fa435476-e6f4-499c-8489-3529c8b010cb}'::text[])) AND ((rate_table_name)::text = 'FUEL'::text) AND ((fields -> 'avg_fuel_price_from'::text) = '3.136'::jsonb) AND ((fields ->> 'service_name'::text) = 'ALL'::text)))
  • Filter: (((rate_set_id)::text = ANY ('{b2b9dfa6-90bb-4900-9c52-579a474ba3ef,fa435476-e6f4-499c-8489-3529c8b010cb}'::text[])) AND ((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 ->> 'origin_country'::text) = 'USA'::text) AND ((((fields -> 'avg_fuel_price_from'::text) <= '3.136'::jsonb) AND ((fields -> 'avg_fuel_price_to'::text) >= '3.136'::jsonb) AND ((fields -> 'avg_fuel_price_from'::text) <> (fields -> 'avg_fuel_price_to'::text))) OR (((fields -> 'avg_fuel_price_from'::text) = '3.136'::jsonb) AND ((fields -> 'avg_fuel_price_from'::text) = (fields -> 'avg_fuel_price_to'::text)))))
8. 0.001 0.022 ↓ 0.0 0 1

BitmapOr (cost=40.62..40.62 rows=1 width=0) (actual time=0.022..0.022 rows=0 loops=1)

9. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on raterow_test2_123034 (cost=0.00..20.86 rows=1 width=0) (actual time=0.011..0.011 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 = 'FUEL'::text) AND ((fields -> 'avg_fuel_price_from'::text) <= '3.136'::jsonb) AND ((fields -> 'avg_fuel_price_to'::text) >= '3.136'::jsonb) AND ((fields ->> 'service_name'::text) = 'ALL'::text))
10. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on raterow_test2_123034 (cost=0.00..19.75 rows=1 width=0) (actual time=0.010..0.010 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 = 'FUEL'::text) AND ((fields -> 'avg_fuel_price_from'::text) = '3.136'::jsonb) AND ((fields ->> 'service_name'::text) = 'ALL'::text))
11. 0.000 0.021 ↓ 0.0 0 1

Bitmap Heap Scan on raterow_123034 rr_3 (cost=40.62..42.69 rows=1 width=348) (actual time=0.021..0.021 rows=0 loops=1)

  • Recheck Cond: ((((rate_set_id)::text = ANY ('{b2b9dfa6-90bb-4900-9c52-579a474ba3ef,fa435476-e6f4-499c-8489-3529c8b010cb}'::text[])) AND ((rate_table_name)::text = 'FUEL'::text) AND ((fields -> 'avg_fuel_price_from'::text) <= '3.136'::jsonb) AND ((fields -> 'avg_fuel_price_to'::text) >= '3.136'::jsonb) AND ((fields ->> 'service_name'::text) = 'ALL'::text)) OR (((rate_set_id)::text = ANY ('{b2b9dfa6-90bb-4900-9c52-579a474ba3ef,fa435476-e6f4-499c-8489-3529c8b010cb}'::text[])) AND ((rate_table_name)::text = 'FUEL'::text) AND ((fields -> 'avg_fuel_price_from'::text) = '3.136'::jsonb) AND ((fields ->> 'service_name'::text) = 'ALL'::text)))
  • Filter: (((rate_set_id)::text = ANY ('{b2b9dfa6-90bb-4900-9c52-579a474ba3ef,fa435476-e6f4-499c-8489-3529c8b010cb}'::text[])) AND ((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 ->> 'dest_country'::text) = 'USA'::text) AND ((((fields -> 'avg_fuel_price_from'::text) <= '3.136'::jsonb) AND ((fields -> 'avg_fuel_price_to'::text) >= '3.136'::jsonb) AND ((fields -> 'avg_fuel_price_from'::text) <> (fields -> 'avg_fuel_price_to'::text))) OR (((fields -> 'avg_fuel_price_from'::text) = '3.136'::jsonb) AND ((fields -> 'avg_fuel_price_from'::text) = (fields -> 'avg_fuel_price_to'::text)))))
12. 0.001 0.021 ↓ 0.0 0 1

BitmapOr (cost=40.62..40.62 rows=1 width=0) (actual time=0.021..0.021 rows=0 loops=1)

13. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on raterow_test2_123034 (cost=0.00..20.86 rows=1 width=0) (actual time=0.010..0.010 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 = 'FUEL'::text) AND ((fields -> 'avg_fuel_price_from'::text) <= '3.136'::jsonb) AND ((fields -> 'avg_fuel_price_to'::text) >= '3.136'::jsonb) AND ((fields ->> 'service_name'::text) = 'ALL'::text))
14. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on raterow_test2_123034 (cost=0.00..19.75 rows=1 width=0) (actual time=0.010..0.010 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 = 'FUEL'::text) AND ((fields -> 'avg_fuel_price_from'::text) = '3.136'::jsonb) AND ((fields ->> 'service_name'::text) = 'ALL'::text))
Planning time : 0.837 ms
Execution time : 0.258 ms