explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UTn5

Settings
# exclusive inclusive rows x rows loops node
1. 0.048 0.387 ↓ 2.7 86 1

Hash Left Join (cost=32.33..53.14 rows=32 width=136) (actual time=0.186..0.387 rows=86 loops=1)

  • Hash Cond: ((woa.vehicle_uuid = v.uuid) AND (woa.archive_uuid = v.archive_uuid))
2. 0.054 0.280 ↓ 2.7 86 1

Hash Join (cost=19.10..39.66 rows=32 width=116) (actual time=0.121..0.280 rows=86 loops=1)

  • Hash Cond: (wola.archive_uuid = woa.archive_uuid)
3. 0.010 0.134 ↓ 1.1 98 1

Append (cost=0.00..19.91 rows=90 width=65) (actual time=0.018..0.134 rows=98 loops=1)

4. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on gms_workorder_line_archive wola (cost=0.00..0.00 rows=1 width=144) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: ((is_placeholder IS FALSE) AND (company_uuid = ''11111111-0000-0000-0000-000000000000''::uuid))
5. 0.098 0.098 ↑ 1.0 87 1

Seq Scan on gms_workorder_line_invoice wola_1 (cost=0.00..10.25 rows=87 width=62) (actual time=0.013..0.098 rows=87 loops=1)

  • Filter: ((is_placeholder IS FALSE) AND (company_uuid = ''11111111-0000-0000-0000-000000000000''::uuid))
  • Rows Removed by Filter: 13
6. 0.014 0.014 ↓ 10.0 10 1

Index Scan using gms_workorder_line_portal_archive_pkey on gms_workorder_line_portal_archive wola_2 (cost=0.14..8.16 rows=1 width=144) (actual time=0.006..0.014 rows=10 loops=1)

  • Index Cond: (company_uuid = ''11111111-0000-0000-0000-000000000000''::uuid)
  • Filter: (is_placeholder IS FALSE)
7. 0.007 0.007 ↑ 1.0 1 1

Seq Scan on gms_workorder_line_external_archive wola_3 (cost=0.00..1.05 rows=1 width=144) (actual time=0.007..0.007 rows=1 loops=1)

  • Filter: ((is_placeholder IS FALSE) AND (company_uuid = ''11111111-0000-0000-0000-000000000000''::uuid))
8. 0.017 0.092 ↓ 1.1 35 1

Hash (cost=18.70..18.70 rows=32 width=67) (actual time=0.092..0.092 rows=35 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 12kB
9. 0.004 0.075 ↓ 1.1 35 1

Append (cost=0.00..18.70 rows=32 width=67) (actual time=0.008..0.075 rows=35 loops=1)

10. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on gms_workorder_archive woa (cost=0.00..0.00 rows=1 width=100) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (company_uuid = ''11111111-0000-0000-0000-000000000000''::uuid)
11. 0.050 0.050 ↓ 1.1 31 1

Seq Scan on gms_workorder_invoice woa_1 (cost=0.00..5.36 rows=29 width=64) (actual time=0.006..0.050 rows=31 loops=1)

  • Filter: (company_uuid = ''11111111-0000-0000-0000-000000000000''::uuid)
12. 0.011 0.011 ↓ 3.0 3 1

Index Scan using gms_workorder_portal_archive_pkey on gms_workorder_portal_archive woa_2 (cost=0.14..8.16 rows=1 width=100) (actual time=0.008..0.011 rows=3 loops=1)

  • Index Cond: (company_uuid = ''11111111-0000-0000-0000-000000000000''::uuid)
13. 0.008 0.008 ↑ 1.0 1 1

Seq Scan on gms_workorder_external_archive woa_3 (cost=0.00..5.01 rows=1 width=100) (actual time=0.005..0.008 rows=1 loops=1)

  • Filter: (company_uuid = ''11111111-0000-0000-0000-000000000000''::uuid)
14. 0.017 0.059 ↓ 5.3 16 1

Hash (cost=13.18..13.18 rows=3 width=68) (actual time=0.059..0.059 rows=16 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
15. 0.003 0.042 ↓ 7.3 22 1

Append (cost=0.00..13.18 rows=3 width=68) (actual time=0.008..0.042 rows=22 loops=1)

16. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on gms_vehicle_archive v (cost=0.00..0.00 rows=1 width=68) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (company_uuid = ''11111111-0000-0000-0000-000000000000''::uuid)
17. 0.028 0.028 ↓ 21.0 21 1

Index Scan using gms_vehicle_invoice_unique_inventory_vehicle_transaction on gms_vehicle_invoice v_1 (cost=0.14..8.15 rows=1 width=68) (actual time=0.006..0.028 rows=21 loops=1)

  • Index Cond: (company_uuid = ''11111111-0000-0000-0000-000000000000''::uuid)
18. 0.009 0.009 ↑ 1.0 1 1

Seq Scan on gms_vehicle_external_archive v_2 (cost=0.00..5.01 rows=1 width=68) (actual time=0.009..0.009 rows=1 loops=1)

  • Filter: (company_uuid = ''11111111-0000-0000-0000-000000000000''::uuid)
Planning time : 0.892 ms
Execution time : 0.468 ms