explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NZrN

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 122.078 ↓ 0.0 0 1

Unique (cost=59,616.70..59,616.75 rows=1 width=800) (actual time=122.078..122.078 rows=0 loops=1)

2.          

CTE tcaa7b77643db44f190523ec3ccf27b1d

3. 0.000 121.936 ↓ 0.0 0 1

Nested Loop (cost=1,000.00..15,102.51 rows=1 width=118) (actual time=121.936..121.936 rows=0 loops=1)

  • Join Filter: ((tubejour.numtube)::text = (resjour.numtube)::text)
4. 49.958 126.084 ↓ 190.7 4,387 1

Gather (cost=1,000.00..15,088.93 rows=23 width=16) (actual time=1.310..126.084 rows=4,387 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 76.126 76.126 ↓ 146.2 1,462 3 / 3

Parallel Seq Scan on resjour (cost=0.00..14,086.63 rows=10 width=16) (actual time=0.313..76.126 rows=1,462 loops=3)

  • Filter: (((analyz)::text = 'ECBU2_URCUL'::text) AND (btrim((resultat)::text) = ''::text))
  • Rows Removed by Filter: 214338
6. 0.000 0.000 ↓ 0.0 0 4,387

Materialize (cost=0.00..10.15 rows=10 width=236) (actual time=0.000..0.000 rows=0 loops=4,387)

7. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on tubejour (cost=0.00..10.10 rows=10 width=236) (actual time=0.008..0.008 rows=0 loops=1)

8.          

CTE t4998696dd47b4c89a7b83eb077937f12

9. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,010.23..15,105.82 rows=2 width=118) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
10. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=10.22..14,105.62 rows=1 width=118) (never executed)

  • Hash Cond: ((resjour_1.numtube)::text = (tubejour_1.numtube)::text)
11. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on resjour resjour_1 (cost=0.00..14,086.63 rows=2,335 width=16) (never executed)

  • Filter: (((analyz)::text = 'QWBC'::text) AND (btrim((resultat)::text) <> ''::text))
12. 0.000 0.000 ↓ 0.0 0

Hash (cost=10.10..10.10 rows=10 width=236) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Seq Scan on tubejour tubejour_1 (cost=0.00..10.10 rows=10 width=236) (never executed)

14.          

CTE t1625ac314c5b4fa9bde9b0c0f9161ddc

15. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1,000.00..15,103.76 rows=1 width=118) (never executed)

  • Join Filter: ((tubejour_2.numtube)::text = (resjour_2.numtube)::text)
16. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.00..15,089.43 rows=28 width=16) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
17. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on resjour resjour_2 (cost=0.00..14,086.63 rows=12 width=16) (never executed)

  • Filter: (((analyz)::text = 'ECBU2_URGE1'::text) AND (btrim((resultat)::text) = ''::text))
18. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..10.15 rows=10 width=236) (never executed)

19. 0.000 0.000 ↓ 0.0 0

Seq Scan on tubejour tubejour_2 (cost=0.00..10.10 rows=10 width=236) (never executed)

20. 0.089 122.075 ↓ 0.0 0 1

Sort (cost=14,304.62..14,304.62 rows=1 width=800) (actual time=122.075..122.075 rows=0 loops=1)

  • Sort Key: t.numtravail, t.creerle, t.numcodebarre, ((((t.nom)::text || ' '::text) || (t.prenom)::text)), form_pj.pj_ordre, t.urgent, t.originecode, t.preleveur, t.medecin, t.zprescripteur, r.numtube, t.sexe, form_pj.pj_infos, form_pj.pj_stade, (to_char((CURRENT_TIMESTAMP - (t.dhdeballage)::timestamp with time zone), 'DDDHH24'::text)), t.dhdeballage, form_pj.pj_nom_logique
  • Sort Method: quicksort Memory: 25kB
21. 0.001 121.986 ↓ 0.0 0 1

Nested Loop (cost=1,010.30..14,304.61 rows=1 width=800) (actual time=121.986..121.986 rows=0 loops=1)

  • Join Filter: ((t.numtravail)::text = (t4998696dd47b4c89a7b83eb077937f12.numtravail)::text)
22. 0.000 121.985 ↓ 0.0 0 1

Nested Loop (cost=1,010.30..14,304.53 rows=1 width=1,160) (actual time=121.985..121.985 rows=0 loops=1)

  • Join Filter: (((tcaa7b77643db44f190523ec3ccf27b1d.numtravail)::text = (t.numtravail)::text) AND ((form_pj.pj_numtube)::text = (t.numcodebarre)::text))
23. 0.011 121.985 ↓ 0.0 0 1

Hash Join (cost=0.03..200.42 rows=1 width=182) (actual time=121.985..121.985 rows=0 loops=1)

  • Hash Cond: ((form_pj.pj_numtravail)::text = (tcaa7b77643db44f190523ec3ccf27b1d.numtravail)::text)
24. 0.033 0.033 ↑ 5,276.0 1 1

Seq Scan on form_pj (cost=0.00..180.59 rows=5,276 width=64) (actual time=0.033..0.033 rows=1 loops=1)

  • Filter: ((pj_typedoc = 1) AND ((pj_analyz)::text = 'ECBU'::text))
25. 0.003 121.941 ↓ 0.0 0 1

Hash (cost=0.02..0.02 rows=1 width=118) (actual time=121.941..121.941 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
26. 121.938 121.938 ↓ 0.0 0 1

CTE Scan on tcaa7b77643db44f190523ec3ccf27b1d (cost=0.00..0.02 rows=1 width=118) (actual time=121.938..121.938 rows=0 loops=1)

27. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1,010.27..14,103.85 rows=17 width=990) (never executed)

  • Hash Cond: ((t.numtravail)::text = (t1625ac314c5b4fa9bde9b0c0f9161ddc.numtravail)::text)
28. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,010.24..14,103.01 rows=170 width=872) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
29. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=10.24..13,086.01 rows=71 width=872) (never executed)

  • Hash Cond: ((r.numtube)::text = (t.numtube)::text)
30. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on resjour r (cost=0.00..12,063.50 rows=269,750 width=16) (never executed)

31. 0.000 0.000 ↓ 0.0 0

Hash (cost=10.13..10.13 rows=9 width=974) (never executed)

32. 0.000 0.000 ↓ 0.0 0

Seq Scan on tubejour t (cost=0.00..10.13 rows=9 width=974) (never executed)

  • Filter: ((numtravail)::text <> 'Inconnu'::text)
33. 0.000 0.000 ↓ 0.0 0

Hash (cost=0.02..0.02 rows=1 width=118) (never executed)

34. 0.000 0.000 ↓ 0.0 0

CTE Scan on t1625ac314c5b4fa9bde9b0c0f9161ddc (cost=0.00..0.02 rows=1 width=118) (never executed)

35. 0.000 0.000 ↓ 0.0 0

CTE Scan on t4998696dd47b4c89a7b83eb077937f12 (cost=0.00..0.04 rows=2 width=118) (never executed)