explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LjJK

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

Aggregate (cost=56,337.26..56,337.27 rows=1 width=32) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Gather (cost=1,000.43..56,337.25 rows=1 width=4) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..55,337.15 rows=1 width=4) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on payment (cost=0.00..50,717.55 rows=378 width=16) (actual rows= loops=)

  • Filter: (payment_provider_id = '00000000-0000-0000-0000-000000000002'::uuid)
5. 0.000 0.000 ↓ 0.0

Index Scan using payment_transaction_payment_id_idx on payment_transaction (cost=0.43..12.21 rows=1 width=20) (actual rows= loops=)

  • Index Cond: (payment_id = payment.id)
  • Filter: ((created_ts >= '2019-10-31 00:00:00'::timestamp without time zone) AND (created_ts <= '2019-11-01 00:00:00'::timestamp without time zone) AND ((state)::tex