explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nMO3

Settings
# exclusive inclusive rows x rows loops node
1. 4.156 45,294.771 ↓ 1.4 2,572 1

Sort (cost=637,682.99..637,687.49 rows=1,801 width=4) (actual time=45,294.579..45,294.771 rows=2,572 loops=1)

  • Sort Key: people_region.id
  • Sort Method: quicksort Memory: 217kB
2. 3,497.247 45,290.615 ↓ 1.4 2,572 1

Hash Join (cost=24,390.42..637,585.61 rows=1,801 width=4) (actual time=9,653.878..45,290.615 rows=2,572 loops=1)

  • Hash Cond: (people_region.region_id = regions_full.id)
3. 32,351.805 32,351.805 ↑ 1.0 21,077,075 1

Seq Scan on people_region (cost=0.00..534,138.04 rows=21,077,104 width=8) (actual time=71.513..32,351.805 rows=21,077,075 loops=1)

4. 1.832 9,441.563 ↓ 1.6 10,009 1

Hash (cost=24,310.05..24,310.05 rows=6,429 width=4) (actual time=9,441.563..9,441.563 rows=10,009 loops=1)

  • Buckets: 16384 (originally 8192) Batches: 1 (originally 1) Memory Usage: 480kB
5. 7,150.496 9,439.731 ↓ 1.6 10,009 1

Bitmap Heap Scan on regions_full (cost=225.82..24,310.05 rows=6,429 width=4) (actual time=2,306.707..9,439.731 rows=10,009 loops=1)

  • Recheck Cond: (address_of_registration ~~* '%Київ%Го%'::text)
  • Rows Removed by Index Recheck: 3700896
  • Heap Blocks: exact=93928
6. 2,289.235 2,289.235 ↓ 577.2 3,710,905 1

Bitmap Index Scan on regions_full_address_of_registration_gin_idx (cost=0.00..224.22 rows=6,429 width=0) (actual time=2,289.235..2,289.235 rows=3,710,905 loops=1)

  • Index Cond: (address_of_registration ~~* '%Київ%Го%'::text)
Planning time : 1,441.371 ms
Execution time : 45,429.927 ms