explain.depesz.com

PostgreSQL's explain analyze made readable

Result: X10s : Just the count

Settings
# exclusive inclusive rows x rows loops node
1. 1.364 2,558.674 ↑ 1.0 833 1

Seq Scan on api_rule (cost=0.00..14,608,898.44 rows=833 width=63) (actual time=0.024..2,558.674 rows=833 loops=1)

2.          

SubPlan (forSeq Scan)

3. 0.833 2,557.310 ↓ 0.0 0 833

GroupAggregate (cost=4,020.08..17,537.52 rows=195 width=12) (actual time=3.070..3.070 rows=0 loops=833)

  • Group Key: u1.rule_id
4. 313.809 2,556.477 ↑ 495.0 2 833

Hash Join (cost=4,020.08..17,530.62 rows=990 width=8) (actual time=2.132..3.069 rows=2 loops=833)

  • Hash Cond: (u1.upload_id = u0.id)
5. 2,080.834 2,215.780 ↑ 4.3 1,095 833

Bitmap Heap Scan on api_report u1 (cost=172.73..13,655.80 rows=4,685 width=8) (actual time=0.289..2.660 rows=1,095 loops=833)

  • Recheck Cond: (rule_id = api_rule.id)
  • Heap Blocks: exact=615355
6. 134.946 134.946 ↑ 4.3 1,095 833

Bitmap Index Scan on api_report_rule_id_0046fb65 (cost=0.00..171.56 rows=4,685 width=0) (actual time=0.162..0.162 rows=1,095 loops=833)

  • Index Cond: (rule_id = api_rule.id)
7. 11.517 26.888 ↓ 1.8 60,670 1

Hash (cost=3,415.30..3,415.30 rows=34,564 width=4) (actual time=26.888..26.888 rows=60,670 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2645kB
8. 11.566 15.371 ↓ 1.8 60,670 1

Bitmap Heap Scan on api_upload u0 (cost=1,130.90..3,415.30 rows=34,564 width=4) (actual time=3.868..15.371 rows=60,670 loops=1)

  • Recheck Cond: ((account)::text = '6089719'::text)
  • Filter: current
  • Rows Removed by Filter: 37
  • Heap Blocks: exact=704
9. 3.805 3.805 ↓ 1.0 60,707 1

Bitmap Index Scan on api_upload_account_e808b66a_like (cost=0.00..1,122.26 rows=60,512 width=0) (actual time=3.805..3.805 rows=60,707 loops=1)

  • Index Cond: ((account)::text = '6089719'::text)