explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gHJx

Settings
# exclusive inclusive rows x rows loops node
1. 135.477 135.477 ↑ 1.2 75,311 3

Parallel Hash Left Join (cost=220260.32..973449.31 rows=1318814 width=91) (actual time=2532.777..4130.584 rows=1054144 loops=3)Hash Cond: (cards_order.created_by_id = customers_customer.id)-> Parallel Hash Left Join (cost=208797.01..958524.04 rows=1318814 width=72) (actual time=2455.335..3191.120 rows=1054144 loops=3)Hash Cond: (cards_order.invoice_id = billing_invoice.id)-> Parallel Seq Scan on cards_order (cost=0.00..708969.14 rows=1318814 width=67) (actual time=0.006..917.016 rows=1054144 loops=3)-> Parallel Hash (cost=186064.34..186064.34 rows=1307734 width=13) (actual time=932.945..932.945 rows=1050437 loops=3)Buckets: 1048576 Batches: 8 Memory Usage: 26720kB-> Parallel Seq Scan on billing_invoice (cost=0.00..186064.34 rows=1307734 width=13) (actual time=0.010..497.563 rows=1050437 loops=3)-> Parallel Hash (cost=10288.14..10288.14 rows=94014 width=27) (actual time=77.093..77.093 rows=75311 loops=3)Buckets: 262144 Batches: 1 Memory Usage: 16096kB-> Parallel Seq Scan on customers_customer (cost=0.00..10288.14 rows=94014 width=27) (actual time=0.012..40.715 rows=75311 loops=3)-> Parallel Hash (cost=10288.14..10288.14 rows=94014 width=27) (actual time=85.442..85.443 rows=75311 loops=3)Buckets: 262144 Batches: 1 Memory Usage: 16128kB-> Parallel Seq Scan on customers_customer t3 (cost=0.00..10,288.14 rows=94,014 width=27) (actual time=0.009..45.159 rows=75,311 loops=3)

Planning time : 0.811 ms
Execution time : 5,056.094 ms