explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WwGC

Settings
# exclusive inclusive rows x rows loops node
1. 11,979.059 34,387.156 ↓ 1.1 17,039,559 1

Merge Join (cost=17.30..2,456,855.04 rows=15,179,843 width=108) (actual time=168.574..34,387.156 rows=17,039,559 loops=1)

  • Merge Cond: (ufu.id_publisher = u.id)
2. 12,353.519 12,353.519 ↑ 1.0 9,877,416 1

Index Scan using user_follow_user_id_publisher_idx on user_follow_user ufu (cost=0.56..473,376.29 rows=9,889,726 width=43) (actual time=17.894..12,353.519 rows=9,877,416 loops=1)

  • Index Cond: (id_brand = 'AC'::bpchar)
3. 3,750.252 10,054.578 ↓ 2.4 26,097,858 1

Materialize (cost=0.56..1,380,496.59 rows=10,837,371 width=52) (actual time=0.016..10,054.578 rows=26,097,858 loops=1)

4. 6,304.326 6,304.326 ↑ 1.0 10,834,272 1

Index Scan using user_pkey on "user" u (cost=0.56..1,353,403.16 rows=10,837,371 width=52) (actual time=0.013..6,304.326 rows=10,834,272 loops=1)

Planning time : 18.474 ms
Execution time : 34,902.760 ms