explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5STr

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.85..13,839.40 rows=54 width=1,160) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.42..10,734.96 rows=417 width=412) (actual rows= loops=)

  • Join Filter: (deliveries.delivery_provider_id = delivery_providers.id)
3. 0.000 0.000 ↓ 0.0

Seq Scan on delivery_providers (cost=0.00..1.15 rows=1 width=97) (actual rows= loops=)

  • Filter: ((deleted_at IS NULL) AND (delivery_provider_type = 'mail'::text))
4. 0.000 0.000 ↓ 0.0

Index Scan using test_test_test on deliveries (cost=0.42..10,671.27 rows=5,003 width=315) (actual rows= loops=)

  • Index Cond: ((delivery_status_id = 1) AND (deleted_at IS NULL))
5. 0.000 0.000 ↓ 0.0

Index Scan using transactions_pkey on transactions (cost=0.43..7.43 rows=1 width=748) (actual rows= loops=)

  • Index Cond: (id = deliveries.transaction_id)
  • Filter: (transaction_status_id = ANY ('{3,50}'::bigint[]))