explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Fqr1

Settings
# exclusive inclusive rows x rows loops node
1. 1.876 331.225 ↑ 5.0 5 1

GroupAggregate (cost=4,236.14..4,238.27 rows=25 width=40) (actual time=329.020..331.225 rows=5 loops=1)

  • Group Key: pa.nom_pays
2. 6.342 329.349 ↓ 8.0 2,002 1

Sort (cost=4,236.14..4,236.77 rows=250 width=44) (actual time=328.510..329.349 rows=2,002 loops=1)

  • Sort Key: pa.nom_pays
  • Sort Method: quicksort Memory: 173kB
3. 19.882 323.007 ↓ 8.0 2,002 1

Hash Join (cost=291.69..4,226.19 rows=250 width=44) (actual time=255.447..323.007 rows=2,002 loops=1)

  • Hash Cond: ((cnt.code_pays)::text = pa.code_pays)
4. 141.802 302.846 ↑ 1.0 10,000 1

Hash Join (cost=289.00..4,171.00 rows=10,000 width=15) (actual time=251.721..302.846 rows=10,000 loops=1)

  • Hash Cond: (cnt.contact_id = f.contact_id)
5. 117.226 117.226 ↑ 1.0 160,000 1

Seq Scan on contacts cnt (cost=0.00..3,182.00 rows=160,000 width=19) (actual time=0.062..117.226 rows=160,000 loops=1)

6. 21.681 43.818 ↑ 1.0 10,000 1

Hash (cost=164.00..164.00 rows=10,000 width=4) (actual time=43.818..43.818 rows=10,000 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 338kB
7. 22.137 22.137 ↑ 1.0 10,000 1

Seq Scan on fournisseurs f (cost=0.00..164.00 rows=10,000 width=4) (actual time=0.079..22.137 rows=10,000 loops=1)

8. 0.032 0.279 ↑ 1.0 5 1

Hash (cost=2.63..2.63 rows=5 width=64) (actual time=0.279..0.279 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 5kB
9. 0.090 0.247 ↑ 1.0 5 1

Nested Loop (cost=0.00..2.63 rows=5 width=64) (actual time=0.138..0.247 rows=5 loops=1)

  • Join Filter: (r.region_id = pa.region_id)
  • Rows Removed by Join Filter: 20
10. 0.066 0.066 ↑ 1.0 1 1

Seq Scan on regions r (cost=0.00..1.06 rows=1 width=4) (actual time=0.058..0.066 rows=1 loops=1)

  • Filter: (nom_region = 'Asie '::bpchar)
  • Rows Removed by Filter: 4
11. 0.091 0.091 ↑ 1.0 25 1

Seq Scan on pays pa (cost=0.00..1.25 rows=25 width=68) (actual time=0.040..0.091 rows=25 loops=1)

Planning time : 26.753 ms
Execution time : 331.804 ms