explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JEH9

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 2,489.447 ↓ 0.0 0 1

Nested Loop (cost=1,580.56..72,216.53 rows=9,061 width=427) (actual time=2,489.446..2,489.447 rows=0 loops=1)

2. 0.002 2,489.444 ↓ 0.0 0 1

Nested Loop (cost=1,580.27..64,611.72 rows=9,061 width=331) (actual time=2,489.443..2,489.444 rows=0 loops=1)

3. 0.003 2,489.442 ↓ 0.0 0 1

Hash Left Join (cost=1,579.85..58,811.27 rows=9,061 width=225) (actual time=2,489.442..2,489.442 rows=0 loops=1)

  • Hash Cond: (t.employment_code = empt.o_id)
4. 0.002 2,489.439 ↓ 0.0 0 1

Hash Left Join (cost=1,578.35..58,685.18 rows=9,061 width=167) (actual time=2,489.438..2,489.439 rows=0 loops=1)

  • Hash Cond: (md.motif_examen_medical = mdmem.o_id)
5. 0.017 2,489.437 ↓ 0.0 0 1

Hash Join (cost=1,572.32..58,560.45 rows=9,061 width=160) (actual time=2,489.436..2,489.437 rows=0 loops=1)

  • Hash Cond: (md.statut = mds.o_id)
6. 0.016 2,489.345 ↓ 0.0 0 1

Hash Join (cost=1,570.78..58,440.55 rows=9,061 width=102) (actual time=2,489.344..2,489.345 rows=0 loops=1)

  • Hash Cond: (m.type = mt.o_id)
7. 0.006 2,489.126 ↓ 0.0 0 1

Hash Join (cost=1,567.03..58,312.21 rows=9,061 width=110) (actual time=2,489.125..2,489.126 rows=0 loops=1)

  • Hash Cond: (t.med_surv_typ_id = et.o_id)
8. 26.193 2,487.820 ↓ 0.0 0 1

Nested Loop (cost=1,551.48..58,161.62 rows=11,847 width=102) (actual time=2,487.819..2,487.820 rows=0 loops=1)

9. 765.909 1,813.447 ↑ 4.3 8,310 1

Hash Join (cost=1,551.05..26,189.12 rows=35,542 width=54) (actual time=239.762..1,813.447 rows=8,310 loops=1)

  • Hash Cond: (md.owner = m.o_id)
10. 1,034.093 1,034.093 ↓ 1.0 633,948 1

Seq Scan on meeting_detail md (cost=0.00..21,907.03 rows=633,500 width=50) (actual time=0.102..1,034.093 rows=633,948 loops=1)

  • Filter: (is_active = 'Y'::bpchar)
  • Rows Removed by Filter: 16774
11. 5.289 13.445 ↑ 1.3 3,781 1

Hash (cost=1,489.34..1,489.34 rows=4,937 width=20) (actual time=13.445..13.445 rows=3,781 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 271kB
12. 7.729 8.156 ↑ 1.3 3,781 1

Bitmap Heap Scan on meeting m (cost=112.37..1,489.34 rows=4,937 width=20) (actual time=0.522..8.156 rows=3,781 loops=1)

  • Recheck Cond: ((day >= '2018-12-01'::date) AND (day <= '2018-12-31'::date))
  • Filter: (is_active = 'Y'::bpchar)
  • Rows Removed by Filter: 1088
  • Heap Blocks: exact=781
13. 0.427 0.427 ↑ 1.0 4,869 1

Bitmap Index Scan on i_meeting_day (cost=0.00..111.13 rows=5,084 width=0) (actual time=0.426..0.427 rows=4,869 loops=1)

  • Index Cond: ((day >= '2018-12-01'::date) AND (day <= '2018-12-31'::date))
14. 648.180 648.180 ↓ 0.0 0 8,310

Index Scan using trav_pkey on trav t (cost=0.43..0.89 rows=1 width=56) (actual time=0.078..0.078 rows=0 loops=8,310)

  • Index Cond: (o_id = md.travailleur)
  • Filter: (COALESCE(trav_financial_membership(o_id, '4262592900'::bigint), 0) > 0)
  • Rows Removed by Filter: 1
15. 0.699 1.300 ↑ 1.0 469 1

Hash (cost=9.69..9.69 rows=469 width=16) (actual time=1.299..1.300 rows=469 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 31kB
16. 0.601 0.601 ↑ 1.0 469 1

Seq Scan on examen_type et (cost=0.00..9.69 rows=469 width=16) (actual time=0.007..0.601 rows=469 loops=1)

17. 0.101 0.203 ↑ 1.0 78 1

Hash (cost=2.78..2.78 rows=78 width=8) (actual time=0.203..0.203 rows=78 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
18. 0.102 0.102 ↑ 1.0 78 1

Seq Scan on meeting_type mt (cost=0.00..2.78 rows=78 width=8) (actual time=0.006..0.102 rows=78 loops=1)

19. 0.036 0.075 ↑ 1.0 24 1

Hash (cost=1.24..1.24 rows=24 width=66) (actual time=0.074..0.075 rows=24 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
20. 0.039 0.039 ↑ 1.0 24 1

Seq Scan on meeting_detail_statut mds (cost=0.00..1.24 rows=24 width=66) (actual time=0.008..0.039 rows=24 loops=1)

21. 0.000 0.000 ↓ 0.0 0

Hash (cost=3.79..3.79 rows=179 width=15) (never executed)

22. 0.000 0.000 ↓ 0.0 0

Seq Scan on motif_examen_medical mdmem (cost=0.00..3.79 rows=179 width=15) (never executed)

23. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.22..1.22 rows=22 width=66) (never executed)

24. 0.000 0.000 ↓ 0.0 0

Seq Scan on employment_type empt (cost=0.00..1.22 rows=22 width=66) (never executed)

25. 0.000 0.000 ↓ 0.0 0

Index Scan using person_pkey on person p (cost=0.42..0.63 rows=1 width=122) (never executed)

  • Index Cond: (o_id = t.person)
26. 0.000 0.000 ↓ 0.0 0

Index Scan using entreprise_pkey on entreprise e (cost=0.29..0.32 rows=1 width=36) (never executed)

  • Index Cond: (o_id = t.entreprise)