explain.depesz.com

PostgreSQL's explain analyze made readable

Result: v1Xf

Settings
# exclusive inclusive rows x rows loops node
1. 0.022 2.687 ↑ 1.0 1 1

Aggregate (cost=1,993.20..1,993.21 rows=1 width=8) (actual time=2.687..2.687 rows=1 loops=1)

2. 0.078 2.665 ↑ 1.0 125 1

Hash Anti Join (cost=506.90..1,992.88 rows=125 width=0) (actual time=0.987..2.665 rows=125 loops=1)

  • Hash Cond: (doc.id = edc.doctor_id)
3. 1.676 2.442 ↑ 1.0 212 1

Bitmap Heap Scan on doctor doc (cost=492.64..1,976.18 rows=212 width=8) (actual time=0.819..2.442 rows=212 loops=1)

  • Recheck Cond: (external_id IS NULL)
  • Filter: active
  • Rows Removed by Filter: 363
  • Heap Blocks: exact=316
4. 0.766 0.766 ↓ 1.0 585 1

Bitmap Index Scan on doctor_external_id_key (cost=0.00..492.59 rows=575 width=0) (actual time=0.766..0.766 rows=585 loops=1)

  • Index Cond: (external_id IS NULL)
5. 0.055 0.145 ↑ 1.0 365 1

Hash (cost=9.67..9.67 rows=367 width=8) (actual time=0.145..0.145 rows=365 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 23kB
6. 0.090 0.090 ↑ 1.0 365 1

Seq Scan on external_doctor_clinic edc (cost=0.00..9.67 rows=367 width=8) (actual time=0.012..0.090 rows=365 loops=1)

Planning time : 0.586 ms
Execution time : 2.721 ms