explain.depesz.com

PostgreSQL's explain analyze made readable

Result: a06m

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 5,575.132 ↑ 1.0 1 1

Limit (cost=431,880.58..431,880.59 rows=1 width=343) (actual time=5,575.131..5,575.132 rows=1 loops=1)

2. 0.013 5,575.130 ↑ 1.0 1 1

Sort (cost=431,880.58..431,880.59 rows=1 width=343) (actual time=5,575.130..5,575.130 rows=1 loops=1)

  • Sort Key: j4_supplier_id.name NULLS FIRST, t.id NULLS FIRST
  • Sort Method: quicksort Memory: 25kB
3. 0.006 5,575.117 ↑ 1.0 1 1

Nested Loop Left Join (cost=1,306.81..431,880.57 rows=1 width=343) (actual time=5,575.076..5,575.117 rows=1 loops=1)

4. 0.000 5,575.106 ↑ 1.0 1 1

Nested Loop Left Join (cost=1,306.81..431,880.54 rows=1 width=273) (actual time=5,575.066..5,575.106 rows=1 loops=1)

5. 208.499 5,773.674 ↑ 1.0 1 1

Gather (cost=1,306.81..431,880.52 rows=1 width=272) (actual time=5,575.052..5,773.674 rows=1 loops=1)

  • Workers Planned: 4
  • Workers Launched: 1
6. 330.730 5,565.175 ↓ 0.0 0 2

Nested Loop Left Join (cost=306.81..430,880.42 rows=1 width=272) (actual time=5,528.202..5,565.175 rows=0 loops=2)

  • Filter: (((CASE WHEN validated_cla_plan_compta_agri.is_training THEN 'VALIDATED'::text WHEN (predicted_cla_plan_compta_agri.ratio < '0.900000000000000022'::double precision) THEN 'LOW'::text WHEN (predicted_cla_plan_compta_agri.ratio >= '0.900000000000000022'::double precision) THEN 'HIGH'::text ELSE 'NONE'::text END = 'HIGH'::text) AND ((CASE WHEN validated_cla_compte_tva_agri.is_training THEN 'VALIDATED'::text WHEN (predicted_cla_compte_tva_agri.ratio < '0.900000000000000022'::double precision) THEN 'LOW'::text WHEN (predicted_cla_compte_tva_agri.ratio >= '0.900000000000000022'::double precision) THEN 'HIGH'::text ELSE 'NONE'::text END = 'HIGH'::text) OR (CASE WHEN validated_cla_compte_tva_agri.is_training THEN 'VALIDATED'::text WHEN (predicted_cla_compte_tva_agri.ratio < '0.900000000000000022'::double precision) THEN 'LOW'::text WHEN (predicted_cla_compte_tva_agri.ratio >= '0.900000000000000022'::double precision) THEN 'HIGH'::text ELSE 'NONE'::text END = 'VALIDATED'::text)) AND ((CASE WHEN validated_cla_analytic.is_training THEN 'VALIDATED'::text WHEN (predicted_cla_analytic.ratio < '0.900000000000000022'::double precision) THEN 'LOW'::text WHEN (predicted_cla_analytic.ratio >= '0.900000000000000022'::double precision) THEN 'HIGH'::text ELSE 'NONE'::text END = 'HIGH'::text) OR (CASE WHEN validated_cla_analytic.is_training THEN 'VALIDATED'::text WHEN (predicted_cla_analytic.ratio < '0.900000000000000022'::double precision) THEN 'LOW'::text WHEN (predicted_cla_analytic.ratio >= '0.900000000000000022'::double precision) THEN 'HIGH'::text ELSE 'NONE'::text END = 'VALIDATED'::text))) OR ((CASE WHEN validated_cla_compte_tva_agri.is_training THEN 'VALIDATED'::text WHEN (predicted_cla_compte_tva_agri.ratio < '0.900000000000000022'::double precision) THEN 'LOW'::text WHEN (predicted_cla_compte_tva_agri.ratio >= '0.900000000000000022'::double precision) THEN 'HIGH'::text ELSE 'NONE'::text END = 'HIGH'::text) AND ((CASE WHEN validated_cla_plan_compta_agri.is_training THEN 'VALIDATED'::text WHEN (predicted_cla_plan_compta_agri.ratio < '0.900000000000000022'::double precision) THEN 'LOW'::text WHEN (predicted_cla_plan_compta_agri.ratio >= '0.900000000000000022'::double precision) THEN 'HIGH'::text ELSE 'NONE'::text END = 'HIGH'::text) OR (CASE WHEN validated_cla_plan_compta_agri.is_training THEN 'VALIDATED'::text WHEN (predicted_cla_plan_compta_agri.ratio < '0.900000000000000022'::double precision) THEN 'LOW'::text WHEN (predicted_cla_plan_compta_agri.ratio >= '0.900000000000000022'::double precision) THEN 'HIGH'::text ELSE 'NONE'::text END = 'VALIDATED'::text)) AND ((CASE WHEN validated_cla_analytic.is_training THEN 'VALIDATED'::text WHEN (predicted_cla_analytic.ratio < '0.900000000000000022'::double precision) THEN 'LOW'::text WHEN (predicted_cla_analytic.ratio >= '0.900000000000000022'::double precision) THEN 'HIGH'::text ELSE 'NONE'::text END = 'HIGH'::text) OR (CASE WHEN validated_cla_analytic.is_training THEN 'VALIDATED'::text WHEN (predicted_cla_analytic.ratio < '0.900000000000000022'::double precision) THEN 'LOW'::text WHEN (predicted_cla_analytic.ratio >= '0.900000000000000022'::double precision) THEN 'HIGH'::text ELSE 'NONE'::text END = 'VALIDATED'::text))) OR ((CASE WHEN validated_cla_analytic.is_training THEN 'VALIDATED'::text WHEN (predicted_cla_analytic.ratio < '0.900000000000000022'::double precision) THEN 'LOW'::text WHEN (predicted_cla_analytic.ratio >= '0.900000000000000022'::double precision) THEN 'HIGH'::text ELSE 'NONE'::text END = 'HIGH'::text) AND ((CASE WHEN validated_cla_plan_compta_agri.is_training THEN 'VALIDATED'::text WHEN (predicted_cla_plan_compta_agri.ratio < '0.900000000000000022'::double precision) THEN 'LOW'::text WHEN (predicted_cla_plan_compta_agri.ratio >= '0.900000000000000022'::double precision) THEN 'HIGH'::text ELSE 'NONE'::text END = 'HIGH'::text) OR (CASE WHEN validated_cla_plan_compta_agri.is_training THEN 'VALIDATED'::text WHEN (predicted_cla_plan_compta_agri.ratio < '0.900000000000000022'::double precision) THEN 'LOW'::text WHEN (predicted_cla_plan_compta_agri.ratio >= '0.900000000000000022'::double precision) THEN 'HIGH'::text ELSE 'NONE'::text END = 'VALIDATED'::text)) AND ((CASE WHEN validated_cla_compte_tva_agri.is_training THEN 'VALIDATED'::text WHEN (predicted_cla_compte_tva_agri.ratio < '0.900000000000000022'::double precision) THEN 'LOW'::text WHEN (predicted_cla_compte_tva_agri.ratio >= '0.900000000000000022'::double precision) THEN 'HIGH'::text ELSE 'NONE'::text END = 'HIGH'::text) OR (CASE WHEN validated_cla_compte_tva_agri.is_training THEN 'VALIDATED'::text WHEN (predicted_cla_compte_tva_agri.ratio < '0.900000000000000022'::double precision) THEN 'LOW'::text WHEN (predicted_cla_compte_tva_agri.ratio >= '0.900000000000000022'::double precision) THEN 'HIGH'::text ELSE 'NONE'::text END = 'VALIDATED'::text))))
  • Rows Removed by Filter: 83948
7. 371.660 5,234.442 ↓ 6.4 83,949 2

Nested Loop Left Join (cost=306.81..396,799.09 rows=13,066 width=248) (actual time=4.367..5,234.442 rows=83,949 loops=2)

8. 295.394 4,862.778 ↓ 7.0 83,949 2

Nested Loop Left Join (cost=306.81..368,195.94 rows=12,001 width=224) (actual time=4.319..4,862.778 rows=83,949 loops=2)

9. 46.023 4,567.381 ↓ 7.0 83,949 2

Merge Join (cost=306.25..345,262.69 rows=12,001 width=207) (actual time=4.281..4,567.381 rows=83,949 loops=2)

  • Merge Cond: (t.document_id = j3_document_id.id)
10. 342.400 4,119.904 ↓ 4.3 89,776 2

Nested Loop Left Join (cost=1.54..474,857.51 rows=20,708 width=207) (actual time=1.049..4,119.904 rows=89,776 loops=2)

11. 163.965 3,777.501 ↓ 4.3 89,776 2

Nested Loop Left Join (cost=0.98..435,285.67 rows=20,708 width=182) (actual time=1.021..3,777.501 rows=89,776 loops=2)

12. 195.170 3,613.535 ↓ 4.3 89,776 2

Nested Loop Left Join (cost=0.98..434,919.81 rows=20,708 width=181) (actual time=0.978..3,613.535 rows=89,776 loops=2)

13. 190.767 3,418.364 ↓ 4.3 89,776 2

Nested Loop (cost=0.98..434,422.34 rows=20,708 width=179) (actual time=0.923..3,418.364 rows=89,776 loops=2)

14. 1,371.529 3,227.596 ↓ 4.3 89,776 2

Nested Loop Left Join (cost=0.98..431,374.34 rows=20,846 width=172) (actual time=0.869..3,227.596 rows=89,776 loops=2)

  • Filter: ((COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = '37e434fe-3ee4-4570-b2dd-c36382ca0250'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = 'bf1a1e5a-1b17-445f-851d-a3bea0f05161'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = '2d7ed5c1-3ee9-4d30-be28-87a2ed9b8b17'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = '8e06c84b-ae66-42e7-ad94-dc560f164137'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = 'acdbe6e6-73ef-4b05-8c6c-08c134ca5153'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = 'dda44f02-ac98-4f2b-899f-055981bfc463'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = '649651ff-0029-4a36-8997-c166a56a38b2'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = '0d582220-06a2-4e92-afbf-b8bfcac451bd'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = 'c52086fd-b2b4-43ab-9ebf-6cf17e36e3d3'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = '3f1c4afb-c289-4ac8-a9f5-ffc616e2ec78'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = '6446bb0b-85e5-4e18-bbf6-fa7f7194c87e'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = '1abfdbd6-0155-4014-a6af-d5295893f9b7'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = '33bdc733-7548-4396-ad63-9d1c2cb1ebe5'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = '670612ac-1f22-4bc3-8984-b98f59e3ff3d'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = 'be7e8e31-c5e0-4845-95bf-c9342c17107d'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = 'ba9c2970-7b2b-43da-99df-96202e33c5b3'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = 'f9ec2c79-584a-402b-a380-907f1dd0e78b'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = '09ffecb8-a227-42ea-9242-a9fcf08ba62a'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = '2840a6c1-3d9b-41f0-ba12-d0a690b4c21f'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = '7aba2d07-a09d-4815-b4cb-b910335600cc'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = '1c73afb1-6d65-4e8b-abca-776c687be9e4'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = 'f71af41f-e549-4792-8b7c-1cfee91c3b9b'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = '7ecd6434-6cab-4989-855c-1f4ee8a6ca13'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = 'd8d62251-4d3a-4e5f-be76-7447746c1538'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = '857c5236-0d40-495f-b0ec-960eb348d6d9'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = '996ce28b-6b82-4054-8a9c-c44fa2ed52fb'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = '9cbc2e5c-4016-435c-8d97-859e8073cf33'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = '42428fa7-fca3-464a-8408-23a6ae043078'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = 'd806e227-8d4b-4f34-9d1b-18b63f5804fa'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = '80f92932-11a4-4b84-81ba-b2c29abc88b6'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = '4987323a-1a4e-4576-90bd-95082da6969a'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = 'd9d574d8-89e9-4b56-ba54-b3ba84706df6'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = '56938f50-2d97-42d8-9b98-f122143acb1c'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = '5b3274f9-b85e-426b-9e5d-3446dd331718'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = '553d9157-52dc-416a-9b7e-87fc1f7c7284'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = '6483aca1-61aa-465a-a9f0-77f0348a3923'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = '885d06b3-9104-431f-8f8f-68576ba85b05'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = 'cf01a270-882f-4be4-bd83-4cc388865d85'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = '4ccbff75-338f-4056-bccb-b79fa386bac1'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = 'dfc60659-3a65-45ed-b743-b50f4654d712'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = '9994631c-cda4-4887-910a-ae1975e1de84'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = '762c3360-ca18-49f3-ab18-f2d891875e23'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = '4154a10c-20cd-4fc0-a83c-d59750dbda50'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = 'ec064879-f46a-4b09-8fc8-1b08a8e68a99'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = '53a560b5-7e1b-49b6-a49f-5ca40f03494a'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = '75b3dc0e-571a-4df2-bacc-37bf3b260f3d'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = '84ebb9c3-01d2-4e46-b52b-eff6da2655ad'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = '75d4d688-b85d-4623-8133-66baf0906136'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = '8fc0ac59-c84d-4ef6-a5db-adeaef283c2f'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = 'c5814fdb-03d0-4f6b-9870-84ff60c4e543'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = '0bcc9e54-4d0a-46c1-ab25-d371288a8530'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = '07f10dd5-c9b5-4477-b91d-af48b7e8cf34'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = 'fa3c6ab2-9507-4c96-8ef8-f0834e06951e'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = 'e0a7e6c5-0ed0-4869-a860-5ba0533400a2'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = '4370bb4b-82a3-4f4a-ac7a-562c85a4fa2c'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = '5281ed47-c44b-45b8-b6fc-e3482bd9f1a9'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = 'db0c5fac-7919-404c-8053-1ca47a2c887f'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = '5dc0ef17-d502-4fa0-b853-d865d73f5908'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = '3be72616-6c3a-4b9a-a66c-e4c833fe3d05'::uuid) OR (COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id) = 'f5ddc2c7-bab4-4f1e-bff5-cbf650235304'::uuid))
  • Rows Removed by Filter: 70175
15. 1,117.671 1,856.060 ↓ 2.2 159,951 2

Nested Loop Left Join (cost=0.98..240,056.13 rows=71,297 width=148) (actual time=0.214..1,856.060 rows=159,951 loops=2)

16. 371.438 738.382 ↓ 2.2 159,951 2

Nested Loop (cost=0.42..103,811.50 rows=71,297 width=123) (actual time=0.104..738.382 rows=159,951 loops=2)

17. 366.942 366.942 ↓ 1.9 170,062 2

Parallel Index Scan using invoice_line_document_id_idx on invoice_line t (cost=0.42..48,982.57 rows=87,648 width=131) (actual time=0.045..366.942 rows=170,062 loops=2)

  • Filter: ((tax_rate >= '19'::numeric) AND (tax_rate <= '20'::numeric))
  • Rows Removed by Filter: 311299
18. 0.002 0.002 ↑ 1.0 1 340,125

Index Scan using invoice_id_idx on invoice j9_invoice_id (cost=0.00..0.63 rows=1 width=24) (actual time=0.002..0.002 rows=1 loops=340,125)

  • Index Cond: (id = t.invoice_id)
  • Rows Removed by Index Recheck: 0
  • Filter: ((source_file = 'pdf'::text) AND (sub_type = 'PURCHASE'::text))
  • Rows Removed by Filter: 0
19. 0.007 0.007 ↑ 1.0 1 319,902

Index Scan using classification_pkey on classification validated_cla_plan_compta_agri (cost=0.56..1.90 rows=1 width=41) (actual time=0.006..0.007 rows=1 loops=319,902)

  • Index Cond: ((source_id = t.id) AND (classification_label = 'plan_compta_agri'::text) AND (is_training = true))
  • Filter: is_training
20. 0.007 0.007 ↑ 2.0 1 319,902

Index Scan using classification_source_id_idx1 on classification predicted_cla_plan_compta_agri (cost=0.00..2.36 rows=2 width=40) (actual time=0.006..0.007 rows=1 loops=319,902)

  • Index Cond: (source_id = t.id)
  • Rows Removed by Index Recheck: 0
  • Filter: ((NOT is_training) AND (classification_label = 'plan_compta_agri'::text))
  • Rows Removed by Filter: 5
21. 0.001 0.001 ↑ 1.0 1 179,552

Index Scan using entity_id_idx on entity j8_entity_id (cost=0.00..0.15 rows=1 width=39) (actual time=0.001..0.001 rows=1 loops=179,552)

  • Index Cond: (id = t.entity_id)
  • Filter: (type_activite = 'AGRI'::text)
  • Rows Removed by Filter: 0
22. 0.001 0.001 ↑ 1.0 1 179,551

Index Scan using supplier_id_idx on supplier j4_supplier_id (cost=0.00..0.02 rows=1 width=34) (actual time=0.001..0.001 rows=1 loops=179,551)

  • Index Cond: (id = t.supplier_id)
23. 0.001 0.001 ↑ 1.0 1 179,551

Index Scan using category_id_idx on category cat_plan_compta_agri (cost=0.00..0.02 rows=1 width=49) (actual time=0.001..0.001 rows=1 loops=179,551)

  • Index Cond: (id = COALESCE(validated_cla_plan_compta_agri.label_id, predicted_cla_plan_compta_agri.label_id))
24. 0.003 0.003 ↑ 1.0 1 179,551

Index Scan using classification_pkey on classification validated_cla_compte_tva_agri (cost=0.56..1.90 rows=1 width=41) (actual time=0.003..0.003 rows=1 loops=179,551)

  • Index Cond: ((source_id = t.id) AND (classification_label = 'compte_tva_agri'::text) AND (is_training = true))
  • Filter: is_training
25. 401.454 401.454 ↑ 1.0 136,944 2

Index Scan using document_pkey on document j3_document_id (cost=0.42..60,491.96 rows=137,748 width=16) (actual time=0.077..401.454 rows=136,944 loops=2)

  • Filter: ((NOT deleted) AND (error_status = 'VALIDATED'::text))
  • Rows Removed by Filter: 100846
26. 0.003 0.003 ↑ 1.0 1 167,898

Index Scan using classification_pkey on classification validated_cla_analytic (cost=0.56..1.90 rows=1 width=33) (actual time=0.003..0.003 rows=1 loops=167,898)

  • Index Cond: ((source_id = t.id) AND (classification_label = 'analytic'::text) AND (is_training = true))
  • Filter: is_training
27. 0.004 0.004 ↑ 2.0 1 167,898

Index Scan using classification_source_id_idx1 on classification predicted_cla_analytic (cost=0.00..2.36 rows=2 width=40) (actual time=0.003..0.004 rows=1 loops=167,898)

  • Index Cond: (source_id = t.id)
  • Rows Removed by Index Recheck: 0
  • Filter: ((NOT is_training) AND (classification_label = 'analytic'::text))
  • Rows Removed by Filter: 5
28. 0.003 0.003 ↑ 2.0 1 167,898

Index Scan using classification_source_id_idx1 on classification predicted_cla_compte_tva_agri (cost=0.00..2.36 rows=2 width=40) (actual time=0.002..0.003 rows=1 loops=167,898)

  • Index Cond: (source_id = t.id)
  • Rows Removed by Index Recheck: 0
  • Filter: ((NOT is_training) AND (classification_label = 'compte_tva_agri'::text))
  • Rows Removed by Filter: 5
29. 0.010 0.010 ↑ 1.0 1 1

Index Scan using category_id_idx on category cat_compte_tva_agri (cost=0.00..0.02 rows=1 width=49) (actual time=0.010..0.010 rows=1 loops=1)

  • Index Cond: (id = COALESCE(validated_cla_compte_tva_agri.label_id, predicted_cla_compte_tva_agri.label_id))
30. 0.005 0.005 ↑ 1.0 1 1

Index Scan using category_id_idx on category cat_analytic (cost=0.00..0.02 rows=1 width=49) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (id = COALESCE(validated_cla_analytic.label_id, predicted_cla_analytic.label_id))
Planning time : 9.848 ms
Execution time : 5,774.167 ms