explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cwA8

Settings
# exclusive inclusive rows x rows loops node
1. 1,657.887 180,886.668 ↑ 2.6 1,030,755 1

Gather (cost=290,370.79..9,731,155.53 rows=2,694,644 width=386) (actual time=1,287.975..180,886.668 rows=1,030,755 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
2. 162.788 179,228.781 ↑ 3.3 206,151 5 / 5

Hash Join (cost=289,370.79..9,460,691.13 rows=673,661 width=386) (actual time=615.976..179,228.781 rows=206,151 loops=5)

  • Hash Cond: (plaza_transactions.lane_id = lanes.id)
3. 146.642 179,065.362 ↑ 3.3 206,151 5 / 5

Hash Join (cost=289,310.39..9,458,855.72 rows=673,661 width=386) (actual time=615.142..179,065.362 rows=206,151 loops=5)

  • Hash Cond: (plaza_transactions.service_provider_id = service_providers.id)
4. 52,165.566 178,918.697 ↑ 3.3 206,151 5 / 5

Nested Loop (cost=289,309.23..9,456,015.57 rows=673,661 width=386) (actual time=615.068..178,918.697 rows=206,151 loops=5)

  • -> Index Scan using plaza_raw_transactions_pkey on plaza_raw_transactions (cost=0.57..2.68 rows=1 width=8) (actual time=0.252..0.252 rows=1 loops=1031
5. 126,192.092 126,753.131 ↑ 4.6 206,260 5 / 5

Parallel Hash Join (cost=289,308.66..6,916,999.26 rows=947,173 width=386) (actual time=614.484..126,753.131 rows=206,260 loops=5)

  • Hash Cond: (plaza_transactions.device_id = devices.id)
  • -> Parallel Index Scan using idx_plaza_transactions_dt_id on plaza_transactions (cost=0.57..6623959.03 rows=1421770 width=386) (actual time=3.28
  • Index Cond: ((dt >= '2019-10-31 21:00:00+00'::timestamp with time zone) AND (dt <= '2020-02-13 20:59:59+00'::timestamp with time zone) AND (
  • Filter: ((deleted_at IS NULL) AND (plaza_transaction_status_id <> ALL ('{10,11,12}'::integer[])) AND (vehicle_class_id = ANY ('{1,2,3}'::int
  • Rows Removed by Filter: 1776361
  • Index Cond: (id = plaza_transactions.plaza_raw_transaction_id)
  • Filter: (vehicle_class = ANY ('{1,2,3}'::bigint[]))
  • Rows Removed by Filter: 0
6. 89.860 561.039 ↑ 2.8 213,948 5 / 5

Parallel Hash (cost=281,931.26..281,931.26 rows=590,146 width=4) (actual time=561.038..561.039 rows=213,948 loops=5)

  • Buckets: 4194304 Batches: 1 Memory Usage: 74688kB
7. 471.179 471.179 ↑ 2.8 213,948 5 / 5

Parallel Seq Scan on devices (cost=0.00..281,931.26 rows=590,146 width=4) (actual time=1.100..471.179 rows=213,948 loops=5)

  • Filter: ((ets_provider_id = ANY ('{2,3,4}'::integer[])) OR ((pan)::text ~~ '605842%'::text) OR ((pan)::text ~~ '637219%'::text) OR ((p
  • Rows Removed by Filter: 261199
8. 0.004 0.023 ↓ 1.1 8 5 / 5

Hash (cost=1.07..1.07 rows=7 width=2) (actual time=0.023..0.023 rows=8 loops=5)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
9. 0.019 0.019 ↓ 1.1 8 5 / 5

Seq Scan on service_providers (cost=0.00..1.07 rows=7 width=2) (actual time=0.018..0.019 rows=8 loops=5)

10. 0.167 0.631 ↓ 1.0 1,134 5 / 5

Hash (cost=46.29..46.29 rows=1,129 width=4) (actual time=0.628..0.631 rows=1,134 loops=5)

  • Buckets: 2048 Batches: 1 Memory Usage: 56kB
11. 0.464 0.464 ↓ 1.0 1,134 5 / 5

Seq Scan on lanes (cost=0.00..46.29 rows=1,129 width=4) (actual time=0.028..0.464 rows=1,134 loops=5)