explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ihLH

Settings
# exclusive inclusive rows x rows loops node
1. 188.413 30,391.849 ↑ 1.0 20 1

Limit (cost=7,200,507.86..7,200,510.19 rows=20 width=1,289) (actual time=30,391.827..30,391.849 rows=20 loops=1)

  • Buffers: shared hit=10,497,936 read=677,963
2. 193.622 30,203.436 ↑ 247,646.2 20 1

Gather Merge (cost=7,200,507.86..7,778,389.34 rows=4,952,924 width=1,289) (actual time=30,024.838..30,203.436 rows=20 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=31,455,107 read=1,956,773
3. 1,162.186 30,009.814 ↑ 145,674.2 17 3 / 3

Sort (cost=7,199,507.83..7,205,698.99 rows=2,476,462 width=1,289) (actual time=30,009.812..30,009.814 rows=17 loops=3)

  • Sort Key: importmove0_.mrn DESC, importmove0_.lrn DESC
  • Sort Method: top-N heapsort Memory: 79kB
  • Buffers: shared hit=31,455,107 read=1,956,773
4. 1,254.118 28,847.628 ↑ 4.2 593,540 3 / 3

Nested Loop (cost=0.56..7,133,610.07 rows=2,476,462 width=1,289) (actual time=239.791..28,847.628 rows=593,540 loops=3)

  • Buffers: shared hit=31,455,091 read=1,956,773
5. 4,013.573 4,013.573 ↑ 1.2 2,143,631 3 / 3

Seq Scan on import_good goods1_ (cost=0..1,528,729.48 rows=2,598,232 width=18) (actual time=239.442..4,013.573 rows=2,143,631 loops=3)

  • Filter: ((goods1_.description)::text ~~ '%Banana%'::text)
  • Buffers: shared read=1,257,402
6. 23,579.937 23,579.937 ↓ 0.0 0 6,430,892 / 3

Index Scan using import_movement_pkey on import_movement importmove0_ (cost=0.56..2.16 rows=1 width=1,289) (actual time=0.011..0.011 rows=0 loops=6,430,892)

  • Index Cond: ((importmove0_.id)::text = (goods1_.movement_id)::text)
  • Filter: ((importmove0_.status)::text = 'RELEASED_FOR_FREE_CIRCULATION'::text)
  • Buffers: shared hit=31,455,091 read=699,371
Planning time : 3.717 ms
Execution time : 30,587.134 ms