explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Hle1

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 0.088 ↑ 1.0 1 1

Hash Join (cost=2.81..49.50 rows=1 width=452) (actual time=0.087..0.088 rows=1 loops=1)

  • Hash Cond: (efi.created_alias_id = groups_clients.client_alias_id)
2.          

Initplan (for Hash Join)

3. 0.004 0.004 ↑ 1.0 1 1

Seq Scan on groups_clients groups_clients_1 (cost=0.00..1.40 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=1)

  • Filter: (client_alias_id = 25)
  • Rows Removed by Filter: 31
4. 0.006 0.006 ↑ 180.0 1 1

Seq Scan on invoices efi (cost=0.00..11.80 rows=180 width=420) (actual time=0.006..0.006 rows=1 loops=1)

5. 0.001 0.014 ↓ 4.0 4 1

Hash (cost=1.40..1.40 rows=1 width=4) (actual time=0.014..0.014 rows=4 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
6. 0.013 0.013 ↓ 4.0 4 1

Seq Scan on groups_clients (cost=0.00..1.40 rows=1 width=4) (actual time=0.011..0.013 rows=4 loops=1)

  • Filter: (group_id = $1)
  • Rows Removed by Filter: 28
7.          

SubPlan (for Hash Join)

8. 0.043 0.058 ↑ 1.0 1 1

Aggregate (cost=34.39..34.41 rows=1 width=32) (actual time=0.058..0.058 rows=1 loops=1)

9. 0.006 0.015 ↑ 1.3 3 1

Hash Semi Join (cost=33.24..34.37 rows=4 width=334) (actual time=0.012..0.015 rows=3 loops=1)

  • Hash Cond: (fi.finance_item_id = invoices_finance_items.finance_item_id)
10. 0.005 0.005 ↓ 2.0 8 1

Seq Scan on finance_items fi (cost=0.00..1.08 rows=4 width=334) (actual time=0.003..0.005 rows=8 loops=1)

  • Filter: (deleted IS FALSE)
11. 0.001 0.004 ↑ 3.0 3 1

Hash (cost=33.12..33.12 rows=9 width=4) (actual time=0.004..0.004 rows=3 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
12. 0.003 0.003 ↑ 3.0 3 1

Seq Scan on invoices_finance_items (cost=0.00..33.12 rows=9 width=4) (actual time=0.002..0.003 rows=3 loops=1)

  • Filter: (invoice_id = efi.invoice_id)
Planning time : 0.373 ms
Execution time : 0.171 ms