explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Wubm

Settings
# exclusive inclusive rows x rows loops node
1. 2,991.636 21,413.400 ↓ 531.4 2,167,071 1

Nested Loop (cost=9,601.57..234,376.93 rows=4,078 width=8) (actual time=319.935..21,413.400 rows=2,167,071 loops=1)

2. 2,508.343 9,753.480 ↓ 531.4 2,167,071 1

Hash Join (cost=9,601.14..217,286.00 rows=4,078 width=8) (actual time=300.580..9,753.480 rows=2,167,071 loops=1)

  • Hash Cond: (o.cd_ref = t.cd_nom)
3. 6,953.473 6,953.473 ↓ 1.0 4,132,314 1

Seq Scan on observations o (cost=0.00..192,329.88 rows=4,083,788 width=12) (actual time=8.817..6,953.473 rows=4,132,314 loops=1)

4. 1.901 291.664 ↓ 13.1 2,563 1

Hash (cost=9,598.70..9,598.70 rows=195 width=4) (actual time=291.664..291.664 rows=2,563 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 91kB
5. 289.763 289.763 ↓ 13.1 2,563 1

Seq Scan on vm_taxref_last t (cost=0.00..9,598.70 rows=195 width=4) (actual time=22.825..289.763 rows=2,563 loops=1)

  • Filter: (groupes_fonctionnels && '{12}'::integer[])
  • Rows Removed by Filter: 192693
6. 8,668.284 8,668.284 ↑ 1.0 1 2,167,071

Index Only Scan using pkey_releve on releves r (cost=0.43..4.18 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=2,167,071)

  • Index Cond: (rid = o.id_releve)
  • Heap Fetches: 25715
Total runtime : 21,882.987 ms