explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9QOQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 6,625.960 ↓ 0.0 0 1

Unique (cost=696,107.22..696,107.23 rows=1 width=18) (actual time=6,625.960..6,625.960 rows=0 loops=1)

2. 0.007 6,625.959 ↓ 0.0 0 1

Sort (cost=696,107.22..696,107.23 rows=1 width=18) (actual time=6,625.959..6,625.959 rows=0 loops=1)

  • Sort Key: ai.receipt_id
  • Sort Method: quicksort Memory: 25kB
3. 0.001 6,625.952 ↓ 0.0 0 1

Nested Loop (cost=1,000.56..696,107.21 rows=1 width=18) (actual time=6,625.952..6,625.952 rows=0 loops=1)

4. 37.174 6,625.951 ↓ 0.0 0 1

Gather (cost=1,000.00..696,098.64 rows=1 width=20) (actual time=6,625.951..6,625.951 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 6,588.777 6,588.777 ↓ 0.0 0 3

Parallel Seq Scan on accounting_invoice_line_items aili (cost=0.00..695,098.54 rows=1 width=20) (actual time=6,588.777..6,588.777 rows=0 loops=3)

  • Filter: ((credit_ledger_line_id)::text = 'test'::text)
  • Rows Removed by Filter: 3080804
6. 0.000 0.000 ↓ 0.0 0

Index Scan using accounting_invoices_pkey on accounting_invoices ai (cost=0.56..8.57 rows=1 width=38) (never executed)

  • Index Cond: ((id)::text = (aili.invoice_id)::text)