explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ijcc

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

Gather Merge (cost=67,174.21..68,275.62 rows=9,440 width=478) (actual rows= loops=)

  • Workers Planned: 2
2. 0.000 0.000 ↓ 0.0

Sort (cost=66,174.19..66,185.99 rows=4,720 width=478) (actual rows= loops=)

  • Sort Key: invoice_record_payment.invoice_payment_id, invoice_record_payment.id
3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.43..65,886.16 rows=4,720 width=478) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on invoice_record_payment (cost=0.00..54,988.73 rows=4,720 width=90) (actual rows= loops=)

  • Filter: (((date_paid)::date <= '2020-04-01'::date) AND ((date_paid)::date >= '2020-04-30'::date))
5. 0.000 0.000 ↓ 0.0

Index Scan using invoice_payment_pkey on invoice_payment invoice_payment_1 (cost=0.43..2.31 rows=1 width=388) (actual rows= loops=)

  • Index Cond: (invoice_record_payment.invoice_payment_id = id)